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

db is unicode? Expand / Collapse
Author
Message
Posted Friday, October 10, 2008 4:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 10, 2008 5:34 PM
Points: 54, Visits: 221
how to identify sql db is unicode UTF-8?
Post #584290
Posted Friday, October 10, 2008 5:15 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
do you mean if SQL can handle unicode character's ? If so, yes of course. As long as you choose Unicode data types to represent the data you need to store, SQL Server should be able to handle it.
Post #584308
Posted Sunday, October 12, 2008 5:38 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
Just to clarify the point, you still have to choose a Collation -Page Code - for your non-Unicode data.

The Collation you choose does not affects data stored in Unicode datatypes e.g.: nchar, nvarchar and ntext.

Last but not least, at installation time you have to set two different Sort Orders, one for Unicode and one for non-Unicode data.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #584535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse