Post reply

How - Multiple languages

  • September 3, 2005 at 11:18 am

    #165840

    Hi,

    I am fairly new to SQL Server and I am involved in a project to create a database which needs to support English, Spanish and the Slovene language.

    I have been reading about globalization and collations but I am still not sure as to the way to proceed.  I would really appreciate some help.

    1) What collation to use for creating the DB so that it supports all three languages?

    2) There will be a VB.NET client accessing the DB.  What do I need to bear in mind to access the database. I've looked at the .NET internationalization.  is this the best way to go?

    3) There will be an ASP.NET website which needs to work also in the three languages.  What is the best way to proceed.

    Many thanks in advance for any help that you can give me.

    Thanks

     

    Kindest Regards,

    JM

  • September 3, 2005 at 10:55 pm

    #587455

    Try the links below for all you need to do localization in Asp.net and SQL Server including Unicode encoding your tables and in Visual Studio 2003.  You can do column level collation in SQL Server 2000 and use NVarchar, NChar and NText the former are 4000 while the later is 1gig. In the second link I have posted links for the .NET localization tool kit and some sample code for application level localization.  Hope this helps

    http://www.aspnetresources.com/blog/unicode_in_vsnet.aspx

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=230&messageid=205432

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

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

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