SQL Server Collation and Unicode Data Type

  • Hi Every one,

    I got to create a new database for my application which is going to support the following countries:

    United States

    Argentina

    Australia

    France

    Germany

    Mexico

    Spain

    United Kingdom

    What is the Database Collation I need to set up and Do I need to create any unicode data type columns.

    Basically my question do I need to create a unicode supporting database for these countries ?

    Thanks,

    Ganesh

  • I would suggest that you use unicode to ensure you can handle any strange characters that may arise.  There's no single codepage that covers both spanish, english, etc that I know of?  Unicode will also allow you to easily expand to other countries with very different alphabets with little changes to you DB

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

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