Sunday, October 14, 2012 7:37 PM
I want to create database with alot of language , plz tell me how to create it :)
Monday, October 15, 2012 6:21 AM
you can configure your collation in server, database, table, and column level, so all you need is to determine what is collation for each column or table you want and take is in your consideration when you query your database.
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
MCTS: SQL Server Administration/Development
Monday, October 15, 2012 6:39 AM
Would you please check-out below threads
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
Monday, October 15, 2012 8:19 AMModerator
First, we should choose a SQL Server collation that supports the Windows system locale most commonly used at your organization, and then use Unicode data types to store other language characters. For example:
declare @MultipLanguageTable table ( ID int identity (1,1) primary key, Name1 varchar(50), Name2 Nvarchar(50) ) --English insert into @MultipLanguageTable values ('Hello','Hello'); --Chinese insert into @MultipLanguageTable values ('你好',N'你好'); --German insert into @MultipLanguageTable values ('Hallo',N'Hallo'); --Japanese insert into @MultipLanguageTable values ('もしもし',N'もしもし'); select * from @MultipLanguageTable;
With the above example, we will get the following result:
1 Hello Hello
2 ?? 你好
3 Hallo Hallo
4 ???? もしもし
For more detail information, please refer to the following documents:
Using SQL Server Collations:
Using Unicode Data:
TechNet Community Support