October 10, 2008 at 4:14 pm
how to identify sql db is unicode UTF-8?
October 10, 2008 at 5:15 pm
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.
October 12, 2008 at 5:38 am
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.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply