I'm having a lot of problems changing the default sortorder and default characterset of my ASE 18.104.22.168 EBF11338 Digital Unix box (@@version = Adaptive Server Enterprise/22.214.171.124/EBF 11338 ESD#3/P/Compaq Tru64/OSF1 V5.0A/rel12503/1933/64-bit/FBO/Fri Aug 1 04:54:12 2003.
sp_helpsort shows this (amongst other things):
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary ordering, for the ISO 8859/1 or Latin-1 character set (
What I want is sortorder noaccents and characterset iso15.
/prog/sybase125/charsets/iso15 contains noaccent.srt and noaccents.srt (note the S!).
select type, id, csid, status, name, sortfile from syscharsets shows
If I use sp_configure "default character set id", 54 it gives an error
Server Message: Number 5824, Severity 16
Server 'prod', Procedure 'sp_configure', Line 616:
Cannot reconfigure server to use sort order ID 50, because the row for its underlying character set (ID 54) does not exist in syscharsets.
(1 row affected)
(return status = 1)
That same error occurs when I try to change the sortorder id first, I tried it with all possible and useful sortorder/charset-id's.
I'm starting to get really frustrated .
Can someone point me in the right direction or give me a How-To on changing these settings?
I had a similar situation, to Load a Sort Order or Additional Character Set u will hv to run from command prompt:
$\SybaseServer\ASE-12_5\bin>charset -PsaPwd -SServerName noaccents.srt iso15
where saPwd is the sa pwd
and ServerName is the SybaseServerName
u hv to run the charset.exe in bin dir of the Sybase Server.....
Once this is done, the sort order file gets loaded...
Now if u query syscharsets , there will be a corresponding entry for noaccents.srt.
You,may now run sp_configure "default character set id", 54 for setting the default value ..