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
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
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
Hello Sir,
its urgent
please give me answer
how to insert data to a table in German and retrive data as English. wthout using any converter.
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…
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
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.
Hi
How to create a foreign key in table
show the example
Hi Pinal,
How to bulk insert unicode characters by bcp? It inserts junk characters into table instead of the specified unicode characters.
how to insert Korean data in sq server 2014
i got solution just put nvarchar in database field
Correct. https://blog.sqlauthority.com/2015/02/25/sql-server-storing-data-in-hindi-chinese-gujarati-and-tamil-or-any-other-language-in-the-same-table/
Sir, how can i chage the default language for a particular database with the help of a query.
language is for connection. What exactly you want to achieve?
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
My Language Bengali .So How Can Use It SQL Server
I want to use Rupee Symbol in SQL Server 2005 ( Window 7 ) Plz Suggest me SQL Setting as well as Window Setting