Post reply

Help needed in setting collation for the SQL Server

  • May 18, 2010 at 1:55 am

    #224529

    Hi All,

    I have two tasks to do.

    1. Installing the SQL Server 2008 Enterprise edition.

    2. Migrate the data from Oracle to newly installed sql server.

    Issue here is the Oracle contains both English & Japanese data in the database.

    So for inserting this data into the SQL Server what will be the collation type need to be set for the SQL Server.

    Please provide me the inputs.

    Thanks.

    Regards,

    Mohan

  • May 18, 2010 at 2:20 am

    #1168642

    You don't need to set the collation for the server.

    You can set the collation at the database or column level.

    http://msdn.microsoft.com/en-us/library/ms177439.aspx

    http://msdn.microsoft.com/en-us/library/ms187582%28v=SQL.100%29.aspx

  • May 18, 2010 at 2:29 am

    #1168648

    Have default collation at Sever level and change the collation of particular column as per your requirement.

    Nag.

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

  • May 18, 2010 at 2:44 am

    #1168655

    Thanks for the reply...

    ok i will set the collation at dataabase/ column level.

    But my question is, what will be the collation type to accept Japanese and English character set in the database? so that both the character sets will present in the database.

  • May 18, 2010 at 3:28 am

    #1168671

    BOL is your friend 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

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