Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    95

    Unanswered: Changing Collation From Binary to SQL_Latin1_General_CP1_CI_AS?

    We have a database that is currently SQL_Latin1_General_CP850_BIN and would like to change the collation to SQL_Latin1_General_CP1_CI_AS. Would the only impact on the data be the sort order?

    The change would be made using ALTER TABLE...ALTER COLUMN.

    Thanks, Dave

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    and comparison (case sensitivity) and to some extent performance of sort & comparison

  3. #3
    Join Date
    Jan 2003
    Posts
    95
    Thanks. It's the data comparison difference that has me concerned. If the only problem will be with Binary "John Doe" does NOT equal "JOHN DOE" and after changing the collation "John Doe" does equal "JOHN DOE" that's ok because we want to have a match in this situation. But I can't think of examples where case sensitive comparisons may be necessary. I've warned the business users they may see a difference in sorting, but I'm not sure what other warnings to provide outside of a possible dip in performance during large search operations.

    Dave

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    There is a possibility that some characters will not translate properly, but these are rarely used in the US. The character differences between the two code pages are mainly in the European and Scandinavian characters, and some proofreading marks.
    http://en.wikipedia.org/wiki/Code_page_850
    http://en.wikipedia.org/wiki/Windows-1252

  5. #5
    Join Date
    Jan 2003
    Posts
    95
    That makes sense. Thanks.

Posting Permissions

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