Last post Jul 02, 2008 06:57 AM by SkyStrike
Sep 29, 2005 11:46 PM|rx|LINK
Sep 30, 2005 06:00 AM|Caddre|LINK
SQL Server supports two Chinese code pages Chinese Traditional 950 and Chinese Simplified 936 which is Chinese_PRC in Windows collation. SQL Server 2000 uses two sort orders with each collation, one for Unicode data and another for the character code page.
Many SQL Server collations use the same code page, but have a different sort order for the code page. Run a search for Chinese collation sort in the BOL (books online). Hope this helps.
Sep 30, 2005 06:02 PM|rx|LINK
Sep 30, 2005 07:36 PM|Caddre|LINK
Sep 30, 2005 07:44 PM|rx|LINK
Sep 30, 2005 08:03 PM|Caddre|LINK
Aug 10, 2006 05:46 AM|indaravind|LINK
My doubt is somewhat related to this topic.
My asp.net application accepts chinese characters and stores them in SQL Server 2000 DB. It also displays them back to the screen sucessfully.
But I need to find the rows which has chinese characters stored in it. To be precise, I need a SQL select query which finds whether a specific column has chinese characters or not?.
Thanks in advance.
Sep 26, 2007 04:45 AM|sal_mahesh|LINK
We are facing a problem while storing the chinese characters in sql server 2000. It is storing as question marks(?????..) . Can u pls provide us the solution with code to store the chinese characters in sql server 2000 ?
My Mail Id : -> email@example.com
Jul 02, 2008 06:57 AM|SkyStrike|LINK
Better late than never.
You may have choosed "varchar" instead or "nvarchar". It happened to me when i was playing around with chinese input.