Hi,
I'm using ASE 15.0 on Linux and I have the problem whit the
sort order on iso88592.
A maked this :

charset –Usa -P -I../interfaces hunnocs.srt iso88592

isql >sp_configure 'default sortorder id', 71,'iso88592'
isql >go
shotdown database
I checked:
isql>sp_helpsort
Character Set = 20, iso88592
ISO_8859-2:1987, Latin2, Eastern Europe
Sort Order = 71, hunnocs_iso88592
Hungarian dictionary sort order for use in Hungary.
Uses the
ISO 8859-2 character set and is case-insensitive.

And the log :
00:00000:00001:2005/11/24 04:55:57.65 server ASE's default
unicode sort order is 'binary'.
00:00000:00001:2005/11/24 04:55:57.65 server ASE's default
sort order is:
00:00000:00001:2005/11/24 04:55:57.65 server
'hunnocs_iso88592' (ID = 71)
00:00000:00001:2005/11/24 04:55:57.65 server on top of
default character set:
00:00000:00001:2005/11/24 04:55:57.65 server 'iso88592'
(ID = 20).

So the codepage and the sort order is ready.
A makes a table whit test dates:
Create table AA
(
NAME char(50)
)
go
insert into AA (NAME) values ("ab")
insert into AA (NAME) values ("ac")
insert into AA (NAME) values ("á")
insert into AA (NAME) values ("áa")
insert into AA (NAME) values ("ác")
insert into AA (NAME) values ("áá")
insert into AA (NAME) values ("a")
insert into AA (NAME) values ("áz")
insert into AA (NAME) values ("cs")
insert into AA (NAME) values ("c")
insert into AA (NAME) values ("ct")
insert into AA (NAME) values ("a")
insert into AA (NAME) values ("aa")
insert into AA (NAME) values ("áb")
insert into AA (NAME) values ("ab")
insert into AA (NAME) values ("áb")
insert into AA (NAME) values ("cc")

bat the hungarin sortorder is not ready .
isql> select NAME from AA order by NAME

NAME
---
a
a
á
aa
áa
áá
ab
ab
áb
áb
ac
ác
áz
c
cc
cs
ct

The correct order be :
a
a
aa
ab
ab
ac
á
áa
áá
áb
áb
ác
áz
c
cc
ac
cs

I think, the Sybase hunnocs.srt (and
hunnoac.srt,hundict.srt) is not correct.
I tried whit cp1250 and the result is alike wrong, or I
makes any badly?

Thanks,
Zoltan.morvai[at]drkw[dot]com.