my sql

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



Answer this question

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


  • my sql