cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Is there a maximum length for the UNLOAD ENCRYPTED KEY value?

Breck_Carter
Participant

on ‎2018 Oct 21 4:23 PM

1,019

...as opposed to the usual fallback DECLARE @Key LONG VARCHAR?

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
VolkerBarth
Contributor
‎2018 Oct 22 4:10 AM
0 Kudos

Hm, according to the underlying an_unload_db structure, it's a C "const char*", and the v17 topic on "Security: Keys for encrypted databases" says

Encryption keys are always case sensitive, and they cannot contain leading or trailing spaces or semicolons. Encryption keys can be of arbitrary length. Longer keys are better because a shorter key is easier to guess.

So I guess LONG VARCHAR is appropriate.

Nevertheless, it's astonishing that the data type is not explicitly mentioned for functions like ENCRYPT.

Accepted Solutions (0)

Answers (0)

Ask a Question