![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
![]() |
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. ![]() | 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 Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |