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 |
|
gukguk
Starting Member
3 Posts |
 Posted - 2008-02-04 : 05:02:47
|
| Hi!I'm pretty new in SQL and I'm kinda confused with the concept of encoding in SQL. I tried to read several article but there are still things that I don't understand. I have a table with two columns and these column contain english and chinese character.CREATE TABLE Names(FirstName NVARCHAR (50), LastName NVARCHAR (50));The collation for both column is Latin1_General_BINMy question is 1. Does all data that is saved in nvarchar column have the same encoding type which is UCS-2?2. If a client application input a chinese character into the database table, what is the encoding type of that data? Is it UCS-2?3. If a client application successfully enter chinese characters into database table and i want to display those chinese characters saved in the database into a web page, do i need to convert those chinese character from UCS-2 (Unicode) into Big-5 encoding?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-04 : 05:12:18
|
| This article gives list of collations available in sql:-ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/11ce1a3d-8314-41a3-be5f-03db90bea61b.htm |
 |
|
|
|
|
|
SQL Column Encoding