nvchar question

when I view nvchar data via SQL editor, it appears as printable characters e.g. $#43252; Is the data actually stored as ascii strings, like above, or in some binary format? I need to know in order to judge the correct length to declare for nvchar variables. For up to 10 2-byte unicode characters, do I say nvchar(20) or nvchar(80)? Sent via Deja.com http://www.deja.com/ Before you buy.

david_henry@my-deja.com wrote: > > when I view nvchar data via SQL editor, it appears as printable > characters e.g. $#43252; > Is the data actually stored as ascii strings, like above, or in some > binary format? > I need to know in order to judge the correct length to declare for > nvchar variables. For up to 10 2-byte unicode characters, do I say > nvchar(20) or nvchar(80)? I believe you need NVARCHAR(20) for 10 2-byte characters. Why would you need 80? June -- june_t@hotmail.com Living on Snickers bars in San Mateo