Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Order error |
Mon, Dec 22 2008 12:25 PM | Permanent Link |
Francisco Fernandez | Hi.
I have a table called ARTICULOS with a field CODIGO, Varchar(20), Collation ESP. I have two records with the values "CT" and "CH" in field CODIGO. If I execute SELECT * FROM ARTICULOS ORDER BY CODIGO the row with "CT" value appears before value "CH" If I change collation with ANSI works fine Thank you |
Mon, Dec 22 2008 2:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Francisco,
<< I have two records with the values "CT" and "CH" in field CODIGO. If I execute SELECT * FROM ARTICULOS ORDER BY CODIGO the row with "CT" value appears before value "CH" If I change collation with ANSI works fine >> The traditional Spanish collation under Windows treats CH as one character: http://msdn.microsoft.com/en-us/library/cc709428(VS.85).aspx To force an ANSI comparison instead, use this: SELECT * FROM ARTICULOS ORDER BY CODIGO COLLATE ANSI -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |