Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4

    Thumbs down Unanswered: Characterset/sortorder-change ASE12.5.0.3 HP-UX

    Hi,

    I'm having a lot of problems changing the default sortorder and default characterset of my ASE 12.5.0.3 EBF11338 Digital Unix box (@@version = Adaptive Server Enterprise/12.5.0.3/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 (
    iso_1).

    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
    Code:
    type        id          csid        status      name                           sortfile                       
    ----------- ----------- ----------- ----------- ----                           --------                       
           1001           0           0           0 ascii_8                        NULL                           
           2004           0         190           0 dynix                          dynix.ust                      
           2003           0         192           0 defaultml                      defaultml                      
           1001           1           0           0 iso_1                          NULL                           
           2004           1         190           0 gbpinyin                       gbpinyin.ust                   
           2003           1         192           0 thaidict                       thaidict                       
           1001           2           0           0 cp850                          NULL                           
           2004           2         190           0 sjisbin                        sjisbin.ust                    
           1001           3           0           0 cp437                          NULL                           
           2004           3         190           0 cyrdict                        cyrdict.ust                    
           1001           4           0           0 roman8                         NULL                           
           2004           4         190           0 rusdict                        rusdict.ust                    
           2003           4         192           0 utf8bin                        utf8bin                        
           1001           5           0           0 mac                            NULL                           
           2004           5         190           0 turdict                        turdict.ust                    
           2004           6         190           0 big5bin                        big5bin.ust                    
           2004           7         190           0 cp932bin                       cp932bin.ust                   
           2004           8         190           0 eucjisbn                       eucjisbn.ust                   
           2004           9         190           0 euckscbn                       euckscbn.ust                   
           2004          10         190           0 gb2312bn                       gb2312bn.ust                   
           1001          14           0           0 iso15                          NULL                           
           2003          39         192           0 altnoacc                       altnoacc                       
           2001          44           2           0 noaccents_cp850                noaccents.srt                  
           2003          45         192           0 altdict                        altdict                        
           2003          46         192           0 altnocsp                       altnocsp                       
           2003          47         192           0 scandict                       scandict                       
           2003          48         192           0 scannocp                       scannocp                       
           2001          50           1           0 bin_iso_1                      binary.srt                     
           2003          50         192           0 binary                         binary                         
           2003          51         192           0 dict                           dict                           
           2003          52         192           0 nocase                         nocase                         
           2003          53         192           0 nocasep                        nocasep                        
           2001          54          14           0 noaccents_iso15                noaccent.srt                   
           2003          54         192           0 noaccent                       noaccent                       
           2003          55         192           0 espdict                        espdict                        
           2003          56         192           0 espnocs                        espnocs                        
           2003          57         192           0 espnoac                        espnoac                        
           2003          59         192           0 rusnocs                        rusnocs                        
           2003          64         192           0 cyrnocs                        cyrnocs                        
           2003          65         192           0 elldict                        elldict                        
           2003          69         192           0 hundict                        hundict                        
           2003          70         192           0 hunnoac                        hunnoac                        
           2003          71         192           0 hunnocs                        hunnocs                        
           2003          73         192           0 turknoac                       turknoac                       
           2003          74         192           0 turknocs                       turknocs


    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?

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606

  3. #3
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    I'm getting really crazy now. I just can't get anything to work.
    The sp_configue commands don't work, the sqllocres give stupid errors and I can't use any xWindows..

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    intersting... I'd say that iso15 has some dependency on availability of another charset.

    There is nothing wrong with your steps. Check with Sybase support

  5. #5
    Join Date
    Dec 2004
    Posts
    1
    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 ..

    Cheers,
    Albina

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •