Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bakerjon
Posting Yak Master
145 Posts |
 Posted - 2005-11-28 : 13:17:42
|
| I'm looking for some help with inserting Chinese characters into a SQL Server 2000 database. We have converted the appropriate fields to unicode data types, but now I'm not sure how to test. 1. How do I insert Chinese characters into my tables?2. Do I need to be concerned with Collation?3. What changes to my web reports might be necessary? (PHP, Classic ASP)ThanksJon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-11-28 : 14:28:45
|
| INSERT INTO Mytable (Firstname) VALUES N'abc'Insert the Chinese characters replacing abc...When you can select the data in Query Analyzer and view it as Chinese (in QA), you're off to a good start.Next... UTF-8 character set in you HTML pages, CODEPAGE 65000 in your ASP pages. You may need to save your ASP pages as UNICODE (using Notepad, FILE, SAVE AS).What code editor are you using?Sam |
 |
|
|
|
|
|
Chinese Characters in English database