Subject | Collation bug? |
---|---|
Author | balanyi_zsolt |
Post date | 2006-03-23T15:11:31Z |
Hello!
I have found problems with collation.
FB 1.5.2, Win XP Pro SP2, English
The following code is self-explaining:
CREATE TABLE TABLE6 (
FIELD1 VARCHAR (30) CHARACTER SET WIN1250 NOT NULL
COLLATE PXW_HUNDC);
select * from TABLE6
order by field1 collate pxw_hundc
returns
b
f
h
o
t
é
ó
á
ú
instead of:
á
b
é
f
h
o
ó
t
ú
I have found problems with collation.
FB 1.5.2, Win XP Pro SP2, English
The following code is self-explaining:
CREATE TABLE TABLE6 (
FIELD1 VARCHAR (30) CHARACTER SET WIN1250 NOT NULL
COLLATE PXW_HUNDC);
select * from TABLE6
order by field1 collate pxw_hundc
returns
b
f
h
o
t
é
ó
á
ú
instead of:
á
b
é
f
h
o
ó
t
ú