Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to update sqlserver2005 to unicode,support multinational Expand / Collapse
Author
Message
Posted Tuesday, February 3, 2009 2:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 28, 2010 7:22 PM
Points: 5, Visits: 46
as topic
Post #648642
Posted Wednesday, February 4, 2009 1:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 11, 2014 2:28 PM
Points: 1,218, Visits: 890
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.
Post #649578
Posted Wednesday, February 4, 2009 2:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 28, 2010 7:22 PM
Points: 5, Visits: 46
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.
Post #649591
Posted Tuesday, November 24, 2009 8:05 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 30, 2010 7:19 AM
Points: 246, Visits: 502
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!
Post #823906
Posted Tuesday, November 24, 2009 3:26 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 30, 2010 7:19 AM
Points: 246, Visits: 502
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
Post #824183
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse