Re: Collation issue,

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 11:00:42 +0100

Most Windows natural language collations ignore underscores, hyphen, spaces
etc when sorting. If you want to include them in your sorting, you most
likely have to use a binary collation, like Latin1_General_BIN. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Chris Hoare" <ChrisHoare@discussions.microsoft.com> wrote in message
news:EE290A60-5CB2-49AE-BA7A-38D3CA1FFBC3@microsoft.com...
> I have a query in SQL server that queries data on the
Latin_1_General_CI_AS collation, code page 1252. On that code page the
character _ appears after the capital A (as it does in ASCII) (I have also
tried this query with case sensitve Latin_1_General_CS_AS with the same
results)
>
> However when i query the data in sql I do not get AA before A_ when
ordering asc. What collation should i be using to get this to work; as i am
somewhat baffled at this point.

Relevant Pages

  • Latvian collagtion issue
    ... in particular the NEW Latvian collation added to SQL Server 2008. ... Well, like you said, if this kind of sorting is what ... Field txt is set up with collation Latvian / Disctionary Sort / Accent- ...
    (microsoft.public.sqlserver.server)
  • Re: sql Cannot resolve collation conflict equals - comparing rows and fileds between Table1 and
    ... View1 is a query from 2 or 3 tables that works fine on its own. ... However in my current query if I try to use it...something like... ... Clearly I need to use collation between Table1 and View1, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: xp_sendmail problems with windows security
    ... I do have a case sensitive collation. ... > b) Right click on the SQL server and choose properties. ... > Each sort order ID has a corresponding SQL Collation name. ... > If the Collation is case sensitive, the query is working as expected. ...
    (microsoft.public.sqlserver.security)
  • Re: Sorting by performance difference - int vs. varchar
    ... Sorting the int column will be faster or much faster, ... The most important performance difference is that for all but the binary ... see if two values are equal according to the used collation. ...
    (microsoft.public.sqlserver.programming)
  • RE: Problem with different collation
    ... As my understanding of your question, there is a query that will run on ... 'Cannot resolve collation conflict' error, ... I have to say it is an known issue of the SQL Server 2000. ... Then I add the colation of the linked server table. ...
    (microsoft.public.sqlserver.programming)