Post reply

Multi language database

  • August 5, 2011 at 7:35 am

    #255317

    Hello,

    We have a sql server database which stores english characters. Recently an requirment has come where we need to store chinese characters too. That means

    we need to store both english and chinese characters.

    Can any suggest how can this be achieved?

    thanks,

    aman

  • August 5, 2011 at 7:44 am

    #1364353

    If during the original design phase someone had such a scenario already in mind (and therewith decided to use unicode data type (NVARCHAR() / NCHAR() ) for both, table structure and variables in procedures/functions, data storage shouldn't be a major issue.

    If not, you moght need to change all non-unicode data type to the corresponding unicode type. Or there might be the chance to get away with a few lookup tables. It depends.

    The frontend app, however, might need to require a few more changes...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • August 5, 2011 at 7:48 am

    #1364355

    Hey thanks for the reply.

    In order to achieve this requirment we need to change all char,varchar, text to nchar,nvarchar and ntext in all SP,Function, triggers and the table. These changes are clear.

    However my question was what should be the collation be set for the same so that we can save data in chinese and english language? I am not sure abt this part.

    Please help.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply