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)

SQL Scripts
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

  • Hi Pinal,
    I am able to insert Hindi words in a table of database of SQL Server 2008 R2, but I want to know that how can I insert hindi numerals in the same table in a specific column(only for hindi numerals). Please give me any suggestion.
    Thanks,
    Sumit

    Reply
  • Sanjay Kumar Mall
    July 20, 2012 4:56 pm

    Hi Pinal,

    How to convert hindi to english in sql server.
    Suppose that we have a data in excel of goverment data then how to convert in english

    Reply
  • Sanjay Kumar Mall
    July 20, 2012 4:58 pm

    Hello Sir,

    its urgent
    please give me answer

    Reply
  • how to insert data to a table in German and retrive data as English. wthout using any converter.

    Reply
  • Hi,

    Whether SSAS support multi languages like japanese, chinese, english, russian in a single row. I mean in the database the field has the capability of having multi languages in a record as the source for the teradata database is sap r3. I heard that even after the language is set as English in sap r3 system, user can enter data other than english as well, like any symbols, chinese words etc.,

    Eventually teradata will be bringing these characters in to database. So when we create cube with teradata as a source, will SSAS be in a position to handle this. If yes, please let me know how to handle this. Thanks…

    Reply
  • Hi pinal,

    Im trying to insert kannada language in database

    and i set that variable to NVARCHAR in database, N charecter to the txt field

    but still im unable to store kannada its showing like ???????

    plz… plz… give me the solution

    Reply
  • Hi
    I m trying to insert Hindi language in database
    and i set that variable to nvarchar in database,
    N character to the text field
    but stil i m unable to store Hindi its showing like english words dqekj
    please Sir give me the solution very fast.

    Reply
  • Hi
    How to create a foreign key in table
    show the example

    Reply
  • Hi Pinal,

    How to bulk insert unicode characters by bcp? It inserts junk characters into table instead of the specified unicode characters.

    Reply
  • how to insert Korean data in sq server 2014

    Reply
  • Sir, how can i chage the default language for a particular database with the help of a query.

    Reply
  • Hello,

    Declare @CARPWorkOrderNo nVARCHAR(50)
    set @CARPWorkOrderNo=’जगभरातील नामवंत’
    SELECT
    m.CARPWorkOrderNo
    ,CONVERT(VARCHAR(10), m.CARPWorkOrderDate, 103) CARPWorkOrderDate
    FROM DOICARProposal m
    WHERE CARPWorkOrderNo =@CARPWorkOrderNo

    This didn’t work. How i use N’ before parameter. How i search marathi text into table using parameters

    Thanks

    Reply
  • My Language Bengali .So How Can Use It SQL Server

    Reply
  • I want to use Rupee Symbol in SQL Server 2005 ( Window 7 ) Plz Suggest me SQL Setting as well as Window Setting

    Reply

Leave a Reply