how to make multi-lanuage database

All Replies

• Monday, October 15, 2012 6:21 AM

   

   
  

  0

  Hi,

  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
  

  MyBlog

  

  • Reply
  • Quote

   
• Monday, October 15, 2012 6:39 AM

   

   
  

  0

  Would you please check-out below threads

  http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/0d559276-c669-46f0-b36a-e28fd8fb1bb7

  http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/e04a1824-f2fe-4e70-ada2-7f800b3272b9

  ---

  Regards,
  Ahmed Ibrahim
  SQL Server Setup Team
  My Blog
  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.
  

  • Reply
  • Quote

   
• Monday, October 15, 2012 8:19 AM

  Moderator

   

   
  

  0

  Hi newOneDev,

  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:
  http://msdn.microsoft.com/en-us/library/ms144260(v=sql.105).aspx

  Using Unicode Data:
  http://msdn.microsoft.com/en-us/library/ms191200(v=sql.105).aspx

  ---

  Allen Li

  TechNet Community Support

  

  • Proposed As Answer by Allen Li - MSFTModerator Monday, October 22, 2012 1:44 AM
  • Marked As Answer by Allen Li - MSFTModerator Tuesday, October 23, 2012 1:55 AM
  •  
  • Reply
  • Quote