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 |
|
johncogan
Starting Member
20 Posts |
 Posted - 2002-10-25 : 05:12:54
|
| Hi What do I need to do to a database on SQL7/2000 to make it ready for working with chinese characters? Are there any things that I need to do to my HTML, ASP and SQL scripts when working with these double byte characters. Microsofts site is not exactly simple to find this information, is there some good "to the point" articles on this any where on the web please? TIA John |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-10-25 : 06:26:54
|
| SQL Server is unicode compliant (See BOL) so it will store Chinese, Japanese (in our case) or english happily without having to do anything clever.You need to store your string data in nvarchar or nchar datatypes as these hold double byte characters.The harder part is displaying the data. In our case we have a Japanese machine i.e. Japanese operating system and software for this purpose.You may be able to try installing Chinese fonts on an english machine to see if that displays ok. We have had problems doing this with Japanese though. Experiment on a test system.When viewing Japanese or Chinese on a machine with english an english operating system you will probably see a lot of ??????? instead of the Chinese characters.Hope that helps a bit.===========Paul |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
|
|
|
|
|
working with double-byte characters (chinese)