Hi Einar,
in SQLCE (at least in 2005) I see only "N prefixed" datatypes: only nvarchar, ntext, ecc.
so, I think, you have losed a week-end :))
Franco
>I have been pondering this all weekend. I can't decide if I should use a data type with the N prefix (i.e. NChar, NVarChar, NText, etc.) or if I should use a data type without the N prefix (i.e. Char, VarChar, Text, etc.).
>
>A string in .NET is always unicode, so that lead me to think that I should use a data type with the N prefix. Now I have to worry about tables in a PPC (SQL CE) and storage space is premium (even more premium than on a desktop PC). I would love to cut the storage cost in half by switching to a data type without the N prefix, but I I also want to remain flexible and extensible for the future. The application might be used outside the US, and I have always thought that was the biggest benefit of unicode.
>
>Any thoughts on this would be appreciated and please state if you use NVarChar or VarChar.
>
>Thanks,
>Einar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only