Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

About "sort order" ?

2 posts in Windows NT Last posting was on 2001-04-11 06:28:53.0Z
Ray Wang Posted on 2001-02-02 21:23:39.0Z
From: "Ray Wang" <rw_ebox@yahoo.com>
Subject: About "sort order" ?
Date: Fri, 2 Feb 2001 16:23:39 -0500
Lines: 10
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <GFR4#EWjAHA.309@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 204.50.182.62
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1251
Article PK: 1088723

When we restore the user database from the dump data files, the warnning is
" There are two different sort order, the sort order of the dump data file
is 44. But the default of current database is 50. So I use (sp_configure
"default sortorder id",44). But it does not work. Error message is " the
row for its underlying character set 'ID2 ' do not exist in charsets.

Thanks


Thuc Posted on 2001-04-11 06:28:53.0Z
From: "Thuc" <tdo@elders.com.au>
References: <GFR4#EWjAHA.309@forums.sybase.com>
Subject: Re: About "sort order" ?
Date: Wed, 11 Apr 2001 15:58:53 +0930
Lines: 29
Organization: Elders
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <SYViQNlwAHA.191@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 203.38.229.146
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:965
Article PK: 1087574

Hi Ray,

Just had the same problem.

Check to see if you have created a database "for load". If you have then
delete all the for load database shell(s) and then change the default sort
order(you can do it throught sp_configure or syconfig.exe). Restart ASE
server. You may need to log off server and log back on to restart ASE
server.

It worked for me...

Cheers,
Thuc.

Ray Wang wrote in message ...
>
>When we restore the user database from the dump data files, the warnning is
>" There are two different sort order, the sort order of the dump data file
>is 44. But the default of current database is 50. So I use (sp_configure
>"default sortorder id",44). But it does not work. Error message is " the
>row for its underlying character set 'ID2 ' do not exist in charsets.
>
>Thanks
>
>