471,073 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Unicode ..

Hi,

I have got couple of questions about unicode settings for database and I
would be thankful if someone can clear the same for me. Here I go -

a. How can I find out whether unicode has been
initialised for an existing SQL Server database?

b. If unicode is initiated, would there be any difference
in performance? In particular, would there be any
performance degradation?

Thanks in advance,

Harish Mohanbabu

*********************************
Long way to go before I sleep ..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #1
2 3927
Harish Mohanbabu <ha*****@msn.com> wrote in message news:<40*********************@news.frii.net>...
Hi,

I have got couple of questions about unicode settings for database and I
would be thankful if someone can clear the same for me. Here I go -

a. How can I find out whether unicode has been
initialised for an existing SQL Server database?

b. If unicode is initiated, would there be any difference
in performance? In particular, would there be any
performance degradation?

Thanks in advance,

Harish Mohanbabu

*********************************
Long way to go before I sleep ..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


You don't mention which version of SQL Server you have, but 7/2000
supports Unicode data using the nchar/nvarchar/ntext data types. So if
you have columns in your tables of those types, they are capable of
holding Unicode data.

Unicode data types require double the amount of storage, so in some
cases they may be slightly slower - you need to move more data over
the network to return results, data and index pages will require more
space etc. But if you need to store Unicode data, then you need to use
those data types, so unless you have some specific performance issue,
there should be no reason to avoid them.

You may want to check out "Using Unicode Data" and "Collations" in
Books Online.

Simon
Jul 20 '05 #2
Hi Simon,

Thank you very much for your kind response. Now I am quite clear about
Collations ...

Harish Mohanbabu

*********************************
Long way to go before I sleep ..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Michael Weir | last post: by
8 posts views Thread by Bill Eldridge | last post: by
8 posts views Thread by Francis Girard | last post: by
4 posts views Thread by webdev | last post: by
2 posts views Thread by Neil Schemenauer | last post: by
10 posts views Thread by Nikolay Petrov | last post: by
6 posts views Thread by Jeff | last post: by
13 posts views Thread by Tomás | last post: by
24 posts views Thread by ChaosKCW | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.