Problem while inserting UTF-8 characters in MS-SQL Server 2000 Database

[sagarsway]

Hi All ,

I have to insert an UTF-8 encoded string in database in MS SqlServer 2000

My application need to process spanish chracters, I get this in an XML string from the Flash Application,

e.g
if I have input string like "ÀÁÂÅÉËÜÝÛÑŽŸåãÔ"
after UTF-8 encoding that gets converted into "À�ÂÅÉËÜ�ÛÑŽŸåãÔ"

this string I need to insert in the databse in MS-SQLServer 2000
but after insertion this encoded string converts into "���������������������œ�žà ?�����"

So when later I try to retrieve the string and decode it I get incorrect output.

please help me in finding solution.

[Steve11235]

There are many 8-bit character sets in use. Your Flash application is passing you data in a specific set. Apparently, it is not UTF-8. It *might* be ISO 8859-1.

Java uses Unicode, which is a 16 bit character set. UTF-8 is essentially the first 256 Unicode characters.

1. Find out what character set (encoding) the Flash application is using. Until you know this for certain, you will have data corruption.

2. Determine if UTF-8 supports all the characters you are receiving. If not, you will have to modify the database or live with some data loss. SQL Server 2000 supports Unicode.

3. Use the proper Charset class to decode your input to a String, which will be in Unicode.

4. Normally, JDBC drives handle character set conversions. I suspect you are losing data when you first bring it into your Java program and convert it to a String.