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)
85 Comments. Leave new
That’s great but how do you add new languages?
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
hi all,
please tell me
how to insert japanese characters in a table????
thanks…!!
Create table Test_Nchar
(strHindi nvarchar(max))
insert into Test_Nchar values ( N’बहन’)
can any one tell me is their any possiblity that I can made entries in table in URDU lanaguage
Create table WorldLangs
(
LangID int identity
,CountryName nvarchar(100)
,Language nvarchar(100)
,SampleSentence nvarchar(100)
)
insert into WorldLangs values(‘Saudi Arabia’,’Arabic’,N’ترحيب’)
Hi,
I stored the values in Japanese in database, how do i convert
these into English..
Please help me
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
how you have saved tamil text in sql 2005..help me save tamil text in sql..
With regards,
Gomathi.P
create table Table_Tamil(ID int, TamilName nVarchar(4000))
insert into Table_Tamil(1,’N’கோமதி’)
i need how to save the Hindi Lanaguage in sqlserver 2005.if any body knowns please help me.
with thanks
SureshKumar DCB
How to insert and retrive tamil characters in SQL 2005. Kindly tell me the way if you know.
How to insert cambodian characters in a table, i has been using BI and Import/Export proces also it doesn’t work
can any one tell me is their any possiblity that I can made entries in table in Gujarati lanaguage
Use Google Language Tools for your preferred language with uni-code Character set and NVARCHAR / NChar Data type to input in your preferred language. numbers and Date controls work only with base installed language
Rushikesh
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’
What happens when you try this?
select count(*) as num from tblcity where City =N’H̨āyirat as-Salam’
Should be able to.
I have done this for sinhala charactors. So hindi should be possibel
!22A79FCE82651673!905.entry?sa=222981668
for hindi you can check the collation https://docs.microsoft.com/en-us/sql/t-sql/statements/windows-collation-name-transact-sql?view=sql-server-2017
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
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 ?
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
ok.. thanks you
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
Hi Pinal
My case is also similar to Vishal. Could you please provide your assistance on this.
Regards
Pawan Singh
how to use in java with database connection. i want to store the data in tamil using netbeans with java
Hi, sir How can i use with parameter for insert
Hi Gurus,
Could you please confirm with me whether SQL server 2005 express edition supports thai language..?
thanks alot…
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.
What is the problem you are getting?
Post the code you used
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
Apart from collation, you should use nvarchar datatype to store unicode data
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.
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!
Have you used unicode datatypes such as nchar or nvarchar?