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
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?
You need to view the result in Text mode. Press Control+T and run the select statement
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]
Please send the store procuder in gujarati language Sir
please send the store company procuder in gujarati language Sir
Dear Pinal Sir,
I want to convert aql query result from English to French.
Pls suggest
Thanks & Regards
Namit Jain
SQL Server wont do this convertion. Use any convertion tool
Dear madhivanan
Can you pls suggest me any convertion tool to convert Sql query out put to French
Thanks & Regards
Namit Jain
Have you tried Google translator?
I want to know how i could save non unicode sinhala strings in sql server 2008. Thank you.
with the help of unicode datatypes such as nvarchar(max)
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
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
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.
i need how to save the Hindi Lanaguage in sqlserver 2005.Please anyone Knowns Please help me….
Zafor iqbal
i need how to save the bangla language in sqlserver 2005.please anyone knows help me at [email removed]
You need to use unicode datatype nvarchar to store reginal characters
I use MS SQL 2005 Korea, how to change the Korean language to be english ??
Use set language option
set language english
Is is possible to insert Chinese or other languages texts in MS Access
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
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.
How to insert the Kannada in to the sql
Hello pinal,
It is possible to insert data to a table in Chinese and retrive data as English. wthout using any converter.
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.
What did you mean by did not work?
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’)
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
I dont think translation is supported in SQL Server
If is it possible then please tell me