how to update sqlserver2005 to unicode,support multinational

• liuch

  Valued Member

  Points: 61

  More actions

  February 3, 2009 at 2:24 am

  #126013

  as topic

• Robert-378556

  SSCertifiable

  Points: 5917

  More actions

  February 4, 2009 at 1:37 am

  #937749

  It supports unicode by default, no updates needed.

  If you have an existing database, you have to alter it to use nvarchar instead of varchar.

• liuch

  Valued Member

  Points: 61

  More actions

  February 4, 2009 at 2:02 am

  #937758

  thanks.

  Now,DB existing the char,varchar or text,i want to change these to nchar,nvarchar,nvarchar(max) automatic.

  however,the sp ,fn too.

  And what will be affected in this change is my consideration.

• MTY-1082557

  SSCarpal Tunnel

  Points: 4540

  More actions

  November 24, 2009 at 8:05 am

  #1083472

  Im actually in this situation right now. My boss want me to be sure if our DB can support unicode.

  Anyone knows any link or tell your experience about this matter?

  My database is on SQL 2005 Standard Edition.

  Advice will be appreciated!

• MTY-1082557

  SSCarpal Tunnel

  Points: 4540

  More actions

  November 24, 2009 at 3:26 pm

  #1083711

  Ok people.. this is a great link

  http://msdn.microsoft.com/en-us/library/bb330962(SQL.90).aspx#intlftrql2005_topic2

  more info:

  http://www.codeproject.com/KB/aspnet/Encoding_in_ASPNET.aspx

  http://msdn.microsoft.com/en-us/library/ms187508(SQL.90).aspx

  http://msdn.microsoft.com/en-us/library/bb330962(SQL.90).aspx#intlftrql2005_topic14

  http://msdn.microsoft.com/en-us/library/ms143508.aspx

  hope it helps you as well