SQL SERVER – 2005 – Multiple Language Support

SQL Server supports multiple languages. Information about all the languages are stored in sys.syslanguages system view. You can run following script in Query Editor and see all the information about each language. Information about Months and Days varies for each language.

Syntax:
SELECT Alias, *
FROM sys.syslanguages

ResultSet: (* results not included)
Alias
————–
English
German
French
Japanese
Danish
Spanish
Italian
Dutch
Norwegian
Portuguese
Finnish
Swedish
Czech
Hungarian
Polish
Romanian
Croatian
Slovak
Slovenian
Greek
Bulgarian
Russian
Turkish
British English
Estonian
Latvian
Lithuanian
Brazilian
Traditional Chinese
Korean
Simplified Chinese
Arabic
Thai

Reference : Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – FIX : ERROR : 3260 An internal buffer has become full
Next Post
SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver

Related Posts

85 Comments. Leave new

  • CREATE TABLE [dbo].[Table_2](
    [hindi] [nvarchar](max) NULL
    ) ON [PRIMARY]

    insert into Table_2 values (N’ हिंदी अनुवाद’)
    select hindi from Table_2

    Based on many suggestions I came across, above is what I thought would work. But it does not show the inserted text correctly. Can you help?

    Reply
  • Hi sir,

    suppose my database contain various language record. but i can understand English so is there is any way so that i an cross check my record in english.

    Thanks And Regards
    Himanshu Baijal
    [email address removed]

    Reply
  • Mahendra Parmar
    March 15, 2011 10:43 am

    Please send the store procuder in gujarati language Sir

    Reply
  • Mahendra Parmar
    March 15, 2011 10:44 am

    please send the store company procuder in gujarati language Sir

    Reply
  • Dear Pinal Sir,

    I want to convert aql query result from English to French.

    Pls suggest

    Thanks & Regards
    Namit Jain

    Reply
  • Dear madhivanan

    Can you pls suggest me any convertion tool to convert Sql query out put to French

    Thanks & Regards
    Namit Jain

    Reply
  • I want to know how i could save non unicode sinhala strings in sql server 2008. Thank you.

    Reply
  • Dear Pinal.
    I’m new in implementing databases for Asia Regions , i have a problem with the manage languages and correct collations for vietnamese,indonesian and Hindi, when create sql user what language set to default if not exists vietnamese , indonesian or Hindi, what is the language set to sql users? and i need change stored procedures for to load information and add or include character “N” precedent for character columns? exists a guideline o best practices? thanks

    Reply
  • dear all,

    pls help me i want to communicate by mail to abroad & my english is week so how can i communicate so any software or any way to i am thinking in Gujarati language i write & convert in english

    Reply
  • i need how to save the Russian Lanaguage string in sqlserver 2005 and after i am insert to russian string to sqlserver 2005 then this string display ??????
    .if any body knowns please help me.

    Reply
  • i need how to save the Hindi Lanaguage in sqlserver 2005.Please anyone Knowns Please help me….

    Reply
  • Zafor iqbal
    i need how to save the bangla language in sqlserver 2005.please anyone knows help me at [email removed]

    Reply
  • I use MS SQL 2005 Korea, how to change the Korean language to be english ??

    Reply
  • Is is possible to insert Chinese or other languages texts in MS Access

    Reply
  • I have a request. user get data in multy languages like chinese, japanese, korean and english all in a single table, ahinese or japanese characters are not read in his table please suggest a tep to support multi language support by SQL database

    Reply
  • Dear Pinal,
    I have a requirement like to translate the data into different languages and that data should be displayed using ssrs report.primarily the data should be in english. when ever the user select the other language (eg: French, spanish) the data should be translated to that language.

    can you please help me out of this and what are the steps i have to follow for achieving this goal.

    Thanks in advance.

    Reply
  • How to insert the Kannada in to the sql

    Reply
  • Shivendra Kumar Yadav
    April 27, 2012 1:52 pm

    Hello pinal,
    It is possible to insert data to a table in Chinese and retrive data as English. wthout using any converter.

    Reply
  • Hi Pinal,

    i want to use variable in my sp.

    I am passing the value to a SP as a parameter and try to insert that value in db table by passing @TextData.

    INSERT INTO table1 VALUES (N’@TextData’) or
    INSERT INTO table1 VALUES (‘N’”+@TextData)

    did not work.

    Please tell me the exact syntax for insert statement to use in SP.

    Reply
    • What did you mean by did not work?

      Reply
    • Hello Drashti,
      Try to get “@TextData” in String datatype object. Just like

      dim str as string or String str
      str=@TextData
      INSERT INTO table1 VALUES(N’str’)

      Reply
      • Gurpreet Singh
        March 30, 2015 11:43 am

        How to multi insert data in particular column in sql server 2008 r2

      • Gurpreet – I didn’t understand your question. Could you please explain little more.

      • CREATE PROCEDURE INSERT_data
        (
        @data nvarchar(4000)
        }
        AS
        insert into table_name (column1) values (N@data)
        GO

        did not work.

  • how to convert english to gujatai using sql

    Reply

Leave a Reply

Menu