db is unicode?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » db is unicode?

db is unicode?

Rate Topic

Display Mode

Topic Options

Author

Message

bang.prashant

Posted Friday, October 10, 2008 4:14 PM

Valued 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

sqlGDBA

Posted Friday, October 10, 2008 5:15 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 03, 2013 10:05 AM
Points: 78, Visits: 185

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

PaulB-TheOneAndOnly

Posted Sunday, October 12, 2008 5:38 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:03 AM
Points: 2,979, Visits: 4,389

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 »

Permissions