Application Server Solutions for Microsoft IIS and ASP.NET
       solutions   products   partners   company   support   downloads         store
ServletExec Self-Help: FAQ
Back to Search >  Back to Search Results

Faq ID 108
Product JTurbo
Category Internationalization
Question How do I insert Unicode into my SQL Server database ?
Answer The only SQL Server datatypes that use Unicode are:
  • nchar
  • nvarchar
  • ntext

If you wish to store unicode data in your database, be certain that the column is one of these types.
When you later fetch the String data, if you don't want to use the Unicode charset then you'll need to convert the String that was fetched into its raw bytes using the appropriate charset name, and then use the bytes to create a new String that is encoded to the charset that your application expects. There is another FAQ which shows how to do this.

company media information terms of use privacy policy contact us