Unicode ..

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Harish Mohanbabu
    #1

    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!
    Tags: None
    • Simon Hayes
      #2
      Re: Unicode ..

      Harish Mohanbabu <harishm@msn.co m> wrote in message news:<40320ffa$ 0$200$75868355@ news.frii.net>. ..[color=blue]
      > 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![/color]

      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

        Comment

        • Harish Mohanbabu
          #3
          Re: Unicode ..

          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!

            Comment

            Previous template Next
            Working...