How To Change UTF

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  September 7, 2011 at 8:46 am

  #390357

  How to change Database Encode to UTF_8 or UTF_16?

• winash

  SSChampion

  Points: 11446

  More actions

  September 7, 2011 at 9:26 am

  #1378059

  Could you elaborate on what you mean? Do you mean storing UTF-8 or UTF-16 data in the DB?

  These links might help:

  http://blogs.msdn.com/b/qingsongyao/archive/2009/04/10/sql-server-and-utf-8-encoding-1-true-or-false.aspx

  From this article:

  When you choose nvarchar as your data type, you automatically get UTF-16 Encoding. Please note, For nvarchar types, we always use UTF-16 encoding to store the data no matter which collation you use. The collation is only matter on what method it will use to compare two string. Since different language has different sorting rule, that is the reason we have many different collations.

  http://forums.asp.net/t/1200021.aspx

  http://support.microsoft.com/kb/232580

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  September 7, 2011 at 9:49 am

  #1378074

  I mean how to change UTF_8 setting in my database

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  September 7, 2011 at 10:22 am

  #1378112

  What Collation I need to change from Default to UTF_8