Unicode problem

[bungpeng]

If I developed a chinese application, I should use Unicode as database datatype right? What if I save my chinese characters into normal fields (varchar for example). What problem will I face?

 

Second, How can I save my chinese characters into database? can I mix it in SQL statement? or the only way is use DataSet to insert field by field?

 

TQ

[Derek Stone]

Bungpeng: The database fields should be defined as nvarchar and nchar.

 

Anything stored into a String will be stored as Unicode. Therefore the only thing the application will need to do to support Unicode strings is to use the String type. It's really that simple.

 

Do keep in mind that text direction is one of the big "gotchas" when coding globalized applications. While English might be read from left to right, Hebrew and many other languages read from right to left. Make sure to account for this in your user interface.