Question
Using Unicode with MS-SQL-Server 2000
Hello,
i want to migrate my coldfusion application to support unicode. for that i read some articles here in the knowledge bas e and on the web. So i actually tested with:
* correct use of cfcontent,cfprocessingdirective
* storing source-files with UTF8 (BOM)
* activating Unicode-handling for strings in datasource-settings of coldfusion admin
* using nvarchar instead of varchar on mssql-server
my firsts test displaying diffrent characters of different languages (chinese, japanese, arabic) look good. Tests storing and selecting example strings in that languages also look good.
but now i read, that mssql stores unicode data with the UCS-2 implementation and cannot handle UTF-8 directly. but my coldfusion-application will be converted to UTF-8.
now my question: Do i have to do special handling storing and selecting the application data or does this the mssql jdbc driver for me. What about characters in some languages which use 3 Bytes in UTF8. How are they handled when MS-SQL-Server 2000 uses UCS-2 (max 2 Bytes) instead?
Many regards for your answers
McD
i want to migrate my coldfusion application to support unicode. for that i read some articles here in the knowledge bas e and on the web. So i actually tested with:
* correct use of cfcontent,cfprocessingdirective
* storing source-files with UTF8 (BOM)
* activating Unicode-handling for strings in datasource-settings of coldfusion admin
* using nvarchar instead of varchar on mssql-server
my firsts test displaying diffrent characters of different languages (chinese, japanese, arabic) look good. Tests storing and selecting example strings in that languages also look good.
but now i read, that mssql stores unicode data with the UCS-2 implementation and cannot handle UTF-8 directly. but my coldfusion-application will be converted to UTF-8.
now my question: Do i have to do special handling storing and selecting the application data or does this the mssql jdbc driver for me. What about characters in some languages which use 3 Bytes in UTF8. How are they handled when MS-SQL-Server 2000 uses UCS-2 (max 2 Bytes) instead?
Many regards for your answers
McD
AdChoices