What collation to use for Simplified + Traditional chinese, and English languages? RSS

• • Reply
  

  vchany

  Member

  23 Points

  32 Posts

  What collation to use for Simplified + Traditional chinese, and English languages?

  Apr 10, 2012 03:31 AM|LINK

  Hi all,

  What collation should I choose for a website wherein Simplified/Traditional Chinese and English languages are used? The database is currently default to "Chinese_Hong_Kong_Stroke_90_CI_AS".. I am wondering if this is compatible enough? If UTF8 is the best option then I couldn't find this option in SQL Server Management Studio.

  Thanks.

• • Reply
  

  yrb.yogi

  Star

  14460 Points

  2402 Posts

  Re: What collation to use for Simplified + Traditional chinese, and English languages?

  Apr 10, 2012 04:34 AM|LINK

  you must visit here to know 

  http://msdn.microsoft.com/en-us/library/aa176552(v=sql.80).aspx

  & this solve thread..

  http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/23179712-e8a5-45b1-b933-9aed22ca577b

  Yogesh Bhadauriya
  .Net All About
  
  • Marked as answer by vchany on Apr 11, 2012 02:04 AM