|
can i have help with the codes in mysql to save chinese characters in the database i am using the ms sql server with vb studio 2003. thanks |
|
can i have help with the codes in mysql to save chinese characters in the database i am using the ms sql server with vb studio 2003. thanks |
my sql
Brendan42376
I don't have any experience in dealing with Chinese characters, so I'm no expert, but I beleive all you need to do is to create a column of type nchar, nvarchar, or ntext, and you should be able to read and write chineese strings to and from it just as easily as you would english text.
Are you having any particular problems
-Scott Wisniewski
Maartin
Scott, is indeed correct with the data types required in the database
If you want to store Uni-Code Characters then you can use the nchar and nvarchar
http://msdn2.microsoft.com/en-us/library/ms176089.aspx
If your wanting to store non-unicode characters then you can use vhar and varchar.
http://msdn2.microsoft.com/en-us/library/ms176089.aspx
There is a different data storage size implication in using the nchar, nvarchar datatypes which may be unneccesary if you are using non-unicode characters.
Ziation
In your post you talk about two different database systems... Which are you trying to use.. MySQL or Microsoft SQL Server.
JatinShah
sorry about it.
what i m using is the ms sql server.
thanks