Re: Using Unicode with MS-SQL-Server 2000

[PaulH **AdobeCommunityExpert** <paul@xxxxxxxxxxxxxxxxxx>]

mcd wrote:
>  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?

no need to worry, the db driver will handle that for you. just make sure your 
encoding is the same end-to-end.

also a potential gotcha has just been exposed in unicode handling for sql server 
related to cfqueryparam under loads, you need to convert everything to "N" 
datatypes to avoid this. see jochem's blog:

http://jochem.vandieten.net/2008/03/22/ms-sql-server-and-the-coldfusion-string-format-setting/