Home Forums SQL Server 2008 SQL Server 2008 - General SQL Server Collation (ASCII Table sort and Case Insensitive/Accent Insensitive) RE: SQL Server Collation (ASCII Table sort and Case Insensitive/Accent Insensitive)

  • January 20, 2012 at 12:49 am

    #1436301

    remember what case-Insensitive collations are used for: if i search for "apple' or "Apple" or "APPLE", i'd get results. that's perfect. now if i want to ORDER those results, i can order by a binary sensitive collation; i think that's the thing you are missing, so there's no need to come up with your own collation.

    so the thing to remember is you can order your data differently than the collation it is stored in.

    SELECT

    YourColumn,

    OtherData

    FROM YourTable

    WHERE YourColumn = 'Apple'

    ORDER BY YourColumn Collate SQL_Latin1_General_CP850_BIN

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!