Post reply

How to store & retrieve mulilingual data from sql server

  • June 19, 2005 at 11:54 pm

    #164947

    For Example.,

    Database created (with Chinese Collation) for an application to handle chinese

    data. Database created (with Korean Collation) to store Korean data.

    Another Database created (With Latin) to handle english data.

    All these regional data are consolidated in central repository sql server.

    on quering the data..chinese, korean data are in junk characters. Pls advise how to handle these issues.

    How to store & retrieve mulilingual data from sql server

    Is there any Collation that handles all the characters. Thx

     

  • June 20, 2005 at 1:38 pm

    #566865

    Have a look in BOL (Books on line) for unicode. Really the multiple language requirements are satisfied using unicode datatypes. The collation in this case will be relevant for specifying the sort order but the code page won't be relevant for storage.

    Rgds,

    Paul Ibison SQL Server MVP, http://www.replicationanswers.com

      


    Paul Ibison
    Paul.Ibison@replicationanswers.com

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

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