Re: TripleDES output size



On Tue, 10 Oct 2006 10:21:02 -0500, "Joe Kaplan"
<joseph.e.kaplan@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:

It is probably a good idea to use either Unicode or UTF-8 if you may need to
support non-ASCII characters, as you'll have much better luck getting the
data back into the right format when you decrypt if you just use Unicode
consistently. That's what it is there for.

You could save some actual size in some cases by using UTF-8, but since it
is variable length, it will be harder to predict how big the encrypted data
will be. Using Unicode, if your strings have a maximum length, your size
will be very predictable.

You also have the option of not storing the data in SQL as string but as
binary instead. That will save you 1/3 with the overhead generated by
base64, but you'll have to be a little more careful getting the data in and
out of the database. Base64 is easiest.

I'd suggest trying not to worry about it too much and just making your SQL
columns be the size they need to be. :)

That's the way I'm going.

Thanks again.
.



Relevant Pages

  • Re: cannot convert between unicode and non-unicode data types
    ... change the error message I am trying to go into a nvarchar on Sql and never ... product can't actually produce a meaningful error message. ... Tried dumping to a raw file but the output is still unicode when I try to ... new SSIS. ...
    (microsoft.public.sqlserver.dts)
  • Re: How to check variables for uniqueness ?
    ... characters is the sequence SS. ... is simply capitalizing strings. ... The fact that case mapping in English /is/ simple is neither here not ... That is a fair criticism of the Unicode position. ...
    (comp.lang.java.programmer)
  • Re: Dangerous behavior of CString
    ... If I'm reading a data file or serial port or something, if the raw data are multibyte but the compilation is Unicode or vice-versa, then sometimes the converting constructors in CString are convenient. ... I did not actually write code like this; in fact I was pretty careful always to use the _T macro with any literal strings. ... But it does the conversion using the current 8-bit code page, which is not what I want. ...
    (microsoft.public.vc.mfc)
  • Re: Help please
    ... i would like to provide "CSimString" class code because the settings ... I agree with Tom that first step is project clean and rebuild all. ... with a Unicode string, ... Consider that VS2005 strings are Unicode by default, ...
    (microsoft.public.vc.mfc)
  • Re: UNICODE Querys in Access und MSSQL
    ... > ich habe eine Access DB auf einen SQL Server portiert. ... > Gibt es eine UNICODE taugliche Syntax die auf beiden System geht? ... > Oder sind hier die Jet Engine und der SQL Server wiedereinmal verschieden? ...
    (microsoft.public.de.sqlserver)