•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,133 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,756 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 1040 | Replies: 2
 |
•
•
Join Date: Jun 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
how to update garbled characters 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..
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..
•
•
Join Date: Aug 2005
Posts: 4,782
Reputation:
Rep Power: 17
Solved Threads: 319
http://www.herongyang.com/php/non_ascii_mysql.html
That's mysql but I presume ms sql would have something similar.
That's mysql but I presume ms sql would have something similar.
I'm not a programmer. My attitude starts with ignorance, holds steady at conversation, and ends with a trip to the hospital. Get used to it.
•
•
Join Date: Dec 2004
Location: Hiawassee, Georgia
Posts: 129
Reputation:
Rep Power: 4
Solved Threads: 1
Junior Poster
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/lib...3(SQL.80).aspx
Here is a link to get you started:
http://msdn2.microsoft.com/en-US/lib...3(SQL.80).aspx
If in doubt, reach into the trash can and remove the user guide.
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Error 624: The system could not update the phone book file (Windows NT / 2000 / XP / 2003)
- Error while trying the update query (ASP)
- Problem using the UPDATE command in VBA (Visual Basic 4 / 5 / 6)
- Help with compression program (C)
- Auto update columns? (Database Design)
- Problem with Windows Update and WinXP (Web Browsers)
Other Threads in the MS SQL Forum
- Previous Thread: Check Free Space in .MDF
- Next Thread: constraints
