Member Avatar for 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.. :):)

  • 3 Contributors
  • 2 Replies
  • 81 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by Geek-Master
Member Avatar for Geek-Master

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.