Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2002
    Location
    Rochester, Kent, United Kingdom
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Collation (SQL 2005)

    Hi Guys
    Does anyone know about Collation?
    What is it? what does it do? how does it work? any documentation in English rather than Microsoftspeak?
    The company I work for is changing versions, when I run the upgrade program I get a Collation error. I've checked the collation on ALL databases and they appear the same!
    Any Ideas??

    Many Thanks

    Si

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Collation (SQL 2005)

    Hi Si

    Collations control the code page used for storing non-Unicode data in a SQL Server and the rules governing how SQL sorts and compares characters stored in non-Unicode data types.

    If you are upgrading from SQL 2k to 2K5 you will find the collation settings remain

    HTH
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •