storing and retrieving UTF data in SQL Server 2000
Hello! I'm working with JSP that accepts input in different languages. I'm using SQL Server2000 to store these input. My data are in UTF8 format. According to KB232580, SQL SErver uses UCS-2 encoding which is different with UTF8. It then suggest that I store my UTF8 data using binary/varbinary/image column.
Now here's my problem.
I insert my input in this manner:
UPDATE RMS
SET Message = CONVERT(varbinary, varInput)
WHERE Condition=whateverValue
Is this the right way to store UTF8 as binary? If yes, how do I retrieve it and format it back as UTF? Please help me!
Thanks!
Now here's my problem.
I insert my input in this manner: UPDATE RMS
SET Message = CONVERT(varbinary, varInput)
WHERE Condition=whateverValue
Is this the right way to store UTF8 as binary? If yes, how do I retrieve it and format it back as UTF? Please help me!
Thanks!