how to update garbled characters

[sql_lad]

hi,

does anybody know how to update garbled characters that are being stored in the database..i am storing vietnamese characters in my db and found out that it some characters are garbled appeared as ? or squares...

any help is grately appreciated..thanks in advance.. :):)

http://www.herongyang.com/php/non_ascii_mysql.html

That's mysql but I presume ms sql would have something similar.

I would check your collation schema for that database. For those who don't know what I'm talking about. A collation defines how SQL will handle unicode characters. Most likely you have your collation set to something like SQL_Latin1_General. I'm not sure what collation is best for Vietnamese. I did find out that Windows has a collation support for Vietnamese.

Here is a link to get you started:

http://msdn2.microsoft.com/en-US/library/aa258233(SQL.80).aspx