SQL SERVER – 2005 – Multiple Language Support | SQL Server Journey with SQL Authority

« SQL SERVER – FIX : ERROR : 3260 An internal buffer has become full

SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver »

SQL SERVER – 2005 – Multiple Language Support

September 21, 2007 by pinaldave

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 (http://blog.SQLAuthority.com)

About these ads

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology | Tagged SQL Language | 69 Comments

69 Responses

on September 26, 2007 at 1:01 pm | Reply JKim

That’s great but how do you add new languages?
on September 27, 2007 at 4:55 am | Reply Sreenath

Hi..

I have a doubt about the languae support in SQL. If Iam using a chinese version of windows, and my SQL server is also a chinese version, what will happen to the stored procedures and table names that I type in? all that will be in chinese?? that means, if I type a table name “tblMyTable” that will come as chinese??? or only the GUI of SQL will be in chinese and all othere stuffs will b same as in english??

thanks in advance.
Srinath
on March 2, 2008 at 11:52 pm | Reply harry

hi all,

please tell me
how to insert japanese characters in a table????

thanks…!!
- on April 22, 2011 at 11:48 pm | Reply Ashok
  
  Create table Test_Nchar
  
  (strHindi nvarchar(max))
  
  insert into Test_Nchar values ( N’बहन’)
on April 24, 2008 at 11:14 am | Reply sanaullah

can any one tell me is their any possiblity that I can made entries in table in URDU lanaguage
- on April 23, 2013 at 4:26 pm | Reply syedbarkath
  
  Create table WorldLangs
  (
  LangID int identity
  ,CountryName nvarchar(100)
  ,Language nvarchar(100)
  ,SampleSentence nvarchar(100)
  )
  
  insert into WorldLangs values(‘Saudi Arabia’,'Arabic’,N’ترحيب’)
on October 3, 2008 at 1:12 pm | Reply sandeep

Hi,

I stored the values in Japanese in database, how do i convert
these into English..

Please help me
on January 23, 2009 at 12:17 am | Reply vijay

We want to use Hindi and Telugu and Tamil most of the Indian Languages in our project how do we support this.

Please, help me regards to this.

BR
Vijay
- on May 27, 2010 at 3:08 pm | Reply gomathi
  
  how you have saved tamil text in sql 2005..help me save tamil text in sql..
  
  With regards,
  Gomathi.P
on February 12, 2009 at 11:50 am | Reply DCB Sureshkumar

i need how to save the Hindi Lanaguage in sqlserver 2005.if any body knowns please help me.

with thanks

SureshKumar DCB
on April 3, 2009 at 5:04 pm | Reply Anu

How to insert and retrive tamil characters in SQL 2005. Kindly tell me the way if you know.
on May 8, 2009 at 1:13 am | Reply Ignacio

How to insert cambodian characters in a table, i has been using BI and Import/Export proces also it doesn’t work
on July 2, 2009 at 5:20 pm | Reply Krutesh

can any one tell me is their any possiblity that I can made entries in table in Gujarati lanaguage
on September 30, 2009 at 3:59 pm | Reply vaibhav

I am using select query on danish word H̨āyirat as-Salam. It is propely stored in sql server , but when I try to select it. It return zero record .
Why it is not selected can any one help me. my query is

select count(*) as num from tblcity where City =’H̨āyirat as-Salam’
- on May 12, 2010 at 4:26 pm | Reply Madhivanan
  
  What happens when you try this?
  
  select count(*) as num from tblcity where City =N’H̨āyirat as-Salam’
on March 4, 2010 at 12:54 pm | Reply Dinesh Asanka

Should be able to.
I have done this for sinhala charactors. So hindi should be possibel
http://dineshasanka.spaces.live.com/blog/cns!22A79FCE82651673!905.entry?sa=222981668

for hindi you can check the collation http://msdn.microsoft.com/en-us/library/ms188046.aspx
on March 18, 2010 at 12:28 pm | Reply ANIL KUMAR DUBEY

Hi,

Is it possible in sql 2005 to translate english text in multilanguage using any service supported by sql 2005 or higher version. We are working on sap project where we save text in english and later it is translated to different languages. Can we perform this task from sql server side instead of using .net code using google translate api which is causng performance issue. Any suggestion is welcome.

Thanks

Anil kumar
on March 26, 2010 at 6:23 pm | Reply falguni

i have to implement my website in multiple language .But how can my read the data from Database in another language .Means suppose in my table there are 10 fields and i have all this fields display in grid view in another language .go Please give me suggestion what i have to do ?
- on March 27, 2010 at 11:59 pm | Reply Marko Parkkola
  
  Hi,
  
  I sided this in my last comment to my article here
  
  http://blog.sqlauthority.com/2010/03/22/sql-server-enumerations-in-relational-database-best-practice/
  
  My example is rather limited but I think you get the hang of it. And if not don’t hesitate to ask for more info.
  
  Do you use ASP.NET in your website? If yes, then you could try using Page.UICulture.TwoLetterISOLanguageName property as language identifier.
on March 27, 2010 at 9:51 pm | Reply Pinal Dave

Hello Falguni,

There is no setting changes to define a language for a column of table. You can store data of any language in a column of NVARCHAR data type.
So just specy the data ype of column to NVARCHAR and use the N character with string while inserting value in that column as below:
INSERT INTO table1 VALUES (N’your multi langual value here’)

Regards,
Pinal Dave
- on March 29, 2010 at 1:15 pm | Reply falguni
  
  ok.. thanks you
  - on April 29, 2011 at 5:58 pm | Reply VISHAL DESHMUKH
    
    Hello Pinal..!
    
    In my case data is accessed from different Databases like ORACLE, MS SQL Server 2008 , DB2.
    
    In case of ORACLE using NVARCHAR2 data-type for column having unicode data and using AL32UTF8 charset solves my problem of using multilingual data.
    
    But in case of SQL server just using NVARCHAR datatype doesnt work, there is need to use suffix N before string as you mentioned.
    
    My questions are
    1. Is their other solution to avoid use of prefix N as we don’t want to modify the queries which are large in number.
    2. What is the AL32UTF8 equivalent charset for SQL Server.
    3. How to modify charset of existing SQL Server Datbase.
    
    Thanks and Warm Regards
    Vishal
- on March 7, 2013 at 5:01 pm | Reply priya
  
  how to use in java with database connection. i want to store the data in tamil using netbeans with java
on April 6, 2010 at 1:03 pm | Reply Mano

Hi Gurus,

Could you please confirm with me whether SQL server 2005 express edition supports thai language..?

thanks alot…
on April 22, 2010 at 1:17 pm | Reply Rakesh

HI Dave

I am working on multilingual web site but getting problem to retrive data in multiple language,data store in sql as english formate. if any idea plz help me.
- on May 12, 2010 at 4:32 pm | Reply Madhivanan
  
  What is the problem you are getting?
  Post the code you used
on May 12, 2010 at 1:12 pm | Reply JAYASON

Hi
I need to insert Chinese charters in to my MSSQL Server 2005 DB. When i inserted its showing me some squares . I tried changing the collation of the column , it still didn’t work
Thanks
JAYASON
- on May 12, 2010 at 4:23 pm | Reply Madhivanan
  
  Apart from collation, you should use nvarchar datatype to store unicode data
on September 6, 2010 at 9:17 am | Reply Chamil

Hello Pinal,

The below insert statement works fine with Arabic text.
INSERT INTO table1 VALUES (N’your multi langual value here’)

But I am passing the text to a SP as a parameter and pleae let me know how to insert the arabic text from SP using a parameter.

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

did not work.

Please tell me the exact syntax for insert and update stetements to use in SP.
on November 4, 2010 at 1:01 pm | Reply Tony Ng

I am using the 2005 sql server as backend and using delphi as frontend. using ADO connection to input Chinese in application. When input the Chinese, I can see it is correct. But when save to Database, Chinese character change to ???.
I using the MS tools to insert Chinese character, it has same problem. Does any one know what is the problem? How to fix this problem.
Thanks!
- on November 4, 2010 at 5:48 pm | Reply madhivanan
  
  Have you used unicode datatypes such as nchar or nvarchar?
on January 14, 2011 at 12:33 am | Reply Anoop Verma

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?
- on January 14, 2011 at 4:59 pm | Reply madhivanan
  
  You need to view the result in Text mode. Press Control+T and run the select statement
on February 24, 2011 at 11:39 am | Reply Himanshu

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]
on March 15, 2011 at 10:43 am | Reply Mahendra Parmar

Please send the store procuder in gujarati language Sir
on March 15, 2011 at 10:44 am | Reply Mahendra Parmar

please send the store company procuder in gujarati language Sir
on May 24, 2011 at 12:00 pm | Reply Namit Jain

Dear Pinal Sir,

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

Pls suggest

Thanks & Regards
Namit Jain
- on May 24, 2011 at 2:54 pm | Reply madhivanan
  
  SQL Server wont do this convertion. Use any convertion tool
on May 30, 2011 at 10:51 am | Reply Namit Jain

Dear madhivanan

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

Thanks & Regards
Namit Jain
- on June 2, 2011 at 5:03 pm | Reply madhivanan
  
  Have you tried Google translator?
on May 31, 2011 at 8:39 am | Reply Chathurange

I want to know how i could save non unicode sinhala strings in sql server 2008. Thank you.
- on June 2, 2011 at 3:27 pm | Reply madhivanan
  
  with the help of unicode datatypes such as nvarchar(max)
on August 10, 2011 at 1:19 am | Reply ricardo

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
on August 18, 2011 at 10:30 am | Reply dear all

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
on September 23, 2011 at 10:56 am | Reply Rahul Chavhan

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.
on October 4, 2011 at 5:13 pm | Reply Rahul Chavhan

i need how to save the Hindi Lanaguage in sqlserver 2005.Please anyone Knowns Please help me….
on October 25, 2011 at 12:20 pm | Reply Zafor iqbal

Zafor iqbal
i need how to save the bangla language in sqlserver 2005.please anyone knows help me at [email removed]
- on November 3, 2011 at 3:22 pm | Reply madhivanan
  
  You need to use unicode datatype nvarchar to store reginal characters
on November 18, 2011 at 5:33 am | Reply Ara

I use MS SQL 2005 Korea, how to change the Korean language to be english ??
- on November 23, 2011 at 4:34 pm | Reply madhivanan
  
  Use set language option
  
  set language english
on January 6, 2012 at 12:54 pm | Reply Nelson

Is is possible to insert Chinese or other languages texts in MS Access
on January 20, 2012 at 1:56 pm | Reply kamlesh

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
on April 13, 2012 at 11:43 am | Reply Surendra

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.
on April 26, 2012 at 10:03 am | Reply Manju

How to insert the Kannada in to the sql
on April 27, 2012 at 1:52 pm | Reply Shivendra Kumar Yadav

Hello pinal,
It is possible to insert data to a table in Chinese and retrive data as English. wthout using any converter.
on May 29, 2012 at 6:37 pm | Reply drashti

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.
- on May 30, 2012 at 1:11 pm | Reply madhivanan
  
  What did you mean by did not work?
- on August 30, 2012 at 1:39 pm | Reply swapnil
  
  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’)
on June 18, 2012 at 2:33 pm | Reply param

how to convert english to gujatai using sql
- on June 18, 2012 at 6:23 pm | Reply madhivanan
  
  I dont think translation is supported in SQL Server
  - on June 20, 2012 at 10:23 am | Reply param
    
    If is it possible then please tell me
on July 9, 2012 at 1:10 pm | Reply Sumit

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
on July 20, 2012 at 4:56 pm | Reply Sanjay Kumar Mall

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
on July 20, 2012 at 4:58 pm | Reply Sanjay Kumar Mall

Hello Sir,

its urgent
please give me answer
on July 26, 2012 at 4:05 pm | Reply karthik

how to insert data to a table in German and retrive data as English. wthout using any converter.
on August 20, 2012 at 8:19 pm | Reply HN

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…
on October 31, 2012 at 1:13 pm | Reply megha

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
on May 9, 2013 at 10:55 pm | Reply santosh

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.
on May 9, 2013 at 10:57 pm | Reply santosh

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