none
How to configure language support

    Question

  • Hello,

    I m using sql server 2005 express edition. I need to store data in one of the indian language. Can you pls guid , how to configure language support and store/ retrieve data in my local language?

    Thanks
    Saturday, February 20, 2010 11:47 AM

Answers

  • hi,
    if I correctly understand your meaning, resource files should be something related to "application level", in order to localize UI and the like, and not regarding the actual data..
    actual data is to be stored in a database.. and unicode data require the national type, thus nvarchar, nchar...
    the link provided by Chirag Shah are in order to understand the working scenario you have to deal with... more, the actual collation is relative to the semantic of ordering rules and not to the actual stored data.. you can have a cyrillic collation and store greeks characters, and this is not a problem...
    on the "client side" of the application, the machine connecting to the SQL Server instance should be instructed to "understand" the relative unicode representation of the data.. on my latin machine (italian Windows code page) I will not be able to "see" those chars as they will be rendered as [] or the like, as my code page is not defined to represent them.. but the data (if only I were able to reed them) is correct.. not correctly represented, but correct.. so tha "regional settings" of the machine matter as well.. the "rendering" machine and not the SQL Server machine :)
    regards
    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools
    Monday, February 22, 2010 11:09 PM
    Moderator

All replies

  • >>one of the indian language


    There is hindi collocation available ('Hindi_CI_AI_WS')  but  your regional language may not be set as a collocation.  

    Your best bet is to store the data as unicode (NVARCHAR or NVARCHAR(MAX) ) columns. 

    For more info 

    Working with Unicode Data in SQL Server
    http://msdn.microsoft.com/en-us/library/ms175180.aspx 

    Programming Database Applications That Use Unicode
    http://msdn.microsoft.com/en-us/library/ms175142.aspx

    • Edited by Chirag Shah Saturday, February 20, 2010 6:07 PM content
    Saturday, February 20, 2010 5:53 PM
  • hi,

    >There is hindi collocation available ('Hindi_CI_AI_WS')  ...

    Chirag Shah eveantually means "collation".. the rest is ok :)

    regards


    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools
    Saturday, February 20, 2010 8:16 PM
    Moderator
  • Thank you both. i think, i need to do by using resource file.
    Monday, February 22, 2010 8:41 AM
  • hi,
    if I correctly understand your meaning, resource files should be something related to "application level", in order to localize UI and the like, and not regarding the actual data..
    actual data is to be stored in a database.. and unicode data require the national type, thus nvarchar, nchar...
    the link provided by Chirag Shah are in order to understand the working scenario you have to deal with... more, the actual collation is relative to the semantic of ordering rules and not to the actual stored data.. you can have a cyrillic collation and store greeks characters, and this is not a problem...
    on the "client side" of the application, the machine connecting to the SQL Server instance should be instructed to "understand" the relative unicode representation of the data.. on my latin machine (italian Windows code page) I will not be able to "see" those chars as they will be rendered as [] or the like, as my code page is not defined to represent them.. but the data (if only I were able to reed them) is correct.. not correctly represented, but correct.. so tha "regional settings" of the machine matter as well.. the "rendering" machine and not the SQL Server machine :)
    regards
    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools
    Monday, February 22, 2010 11:09 PM
    Moderator
  • >> I need to store data in one of the indian language

    Andrea, I am in agreement with you. Question that was asked was how to store data and not how to present data. Resour file (.resx) only take cares of presenting the data.
    Tuesday, February 23, 2010 2:42 PM