|
Posted by Alexander Kuznetsov on 10/02/87 11:47
Latin1_General_CS_AS will solve some problems, but not all:
SQL Server:
CREATE TABLE t1(c1 CHAR(10) COLLATE Latin1_General_CS_AS NOT NULL);
INSERT INTO t1 VALUES('AAA');
INSERT INTO t1 VALUES('A_A');
SELECT * FROM T1 order by c1;
c1
----------
A_A
AAA
(2 row(s) affected)
drop table t1;
The same script in Oracle running on UNIX returns rows in a different
order:
C1
----------
AAA
A_A
2 rows selected
Navigation:
[Reply to this message]
|