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.

How to change charset and sort order

6 posts in General Discussion Last posting was on 2012-08-08 17:38:06.0Z
ccassano Posted on 2012-08-06 19:22:51.0Z
Sender: 3987.501ff83b.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: How to change charset and sort order
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5020198b.3d26.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 6 Aug 2012 12:22:51 -0700
X-Trace: forums-1-dub 1344280971 172.20.134.41 (6 Aug 2012 12:22:51 -0700)
X-Original-Trace: 6 Aug 2012 12:22:51 -0700, 172.20.134.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31322
Article PK: 74211

Hi, I'm trying to load a dump file and I'm getting an error
that the load failed because I have the wrong charset and
sort order. How can I change these in my database so that
the load works?

D:\>isql -Usa -SWSDDXLPPS1 -w300
Password:
1> load database CMIS from "D:\DM3\CMIS.dmp"
2> go
Backup Server session id is: 23. Use this value when
executing the 'sp_volchange
d' system stored procedure after fulfilling any volume
change request from the B
ackup Server.
Backup Server: 6.28.1.1: Dumpfile name 'CMIS12215002D5 '
section number 1 moun
ted on disk file 'D:\DM3\CMIS.dmp'
Msg 3120, Level 16, State 1:
Server 'WSDDXLPPS1', Line 1:
The database you are attempting to LOAD was DUMPed under a
different sort order
ID (52) or character set ID (1) than the ones running on
this server (SortOrd =
50, CharSet = 2). If the sort orders differ, at least one of
them is non-binary.


Rob V Posted on 2012-08-06 21:04:48.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: How to change charset and sort order
References: <5020198b.3d26.1681692777@sybase.com>
In-Reply-To: <5020198b.3d26.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50203170$1@forums-1-dub>
Date: 6 Aug 2012 14:04:48 -0700
X-Trace: forums-1-dub 1344287088 172.20.134.152 (6 Aug 2012 14:04:48 -0700)
X-Original-Trace: 6 Aug 2012 14:04:48 -0700, vip152.sybase.com
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31323
Article PK: 74212


On 06-Aug-2012 21:22, ccassano@emprisecorporation.com wrote:
> Hi, I'm trying to load a dump file and I'm getting an error
> that the load failed because I have the wrong charset and
> sort order. How can I change these in my database so that
> the load works?
>
> D:\>isql -Usa -SWSDDXLPPS1 -w300
> Password:
> 1> load database CMIS from "D:\DM3\CMIS.dmp"
> 2> go
> Backup Server session id is: 23. Use this value when
> executing the 'sp_volchange
> d' system stored procedure after fulfilling any volume
> change request from the B
> ackup Server.
> Backup Server: 6.28.1.1: Dumpfile name 'CMIS12215002D5 '
> section number 1 moun
> ted on disk file 'D:\DM3\CMIS.dmp'
> Msg 3120, Level 16, State 1:
> Server 'WSDDXLPPS1', Line 1:
> The database you are attempting to LOAD was DUMPed under a
> different sort order
> ID (52) or character set ID (1) than the ones running on
> this server (SortOrd =
> 50, CharSet = 2). If the sort orders differ, at least one of
> them is non-binary.
>

See the docs:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38421.1570/html/ntconfig/ntconfig95.htm

Note that you may need to do various follow-up actions as it can
possibly invalidate existing indexes and text columns.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


ccassano Posted on 2012-08-08 15:30:58.0Z
Sender: 1840.50228561.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Re: How to change charset and sort order
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50228632.1853.1681692777@sybase.com>
References: <50203170$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 8 Aug 2012 08:30:58 -0700
X-Trace: forums-1-dub 1344439858 172.20.134.41 (8 Aug 2012 08:30:58 -0700)
X-Original-Trace: 8 Aug 2012 08:30:58 -0700, 172.20.134.41
Lines: 73
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31324
Article PK: 74213


> On 06-Aug-2012 21:22, ccassano@emprisecorporation.com
> > wrote: Hi, I'm trying to load a dump file and I'm
> > getting an error that the load failed because I have the
> > wrong charset and sort order. How can I change these in
> > my database so that the load works?
> >
> > D:\>isql -Usa -SWSDDXLPPS1 -w300
> > Password:
> > 1> load database CMIS from "D:\DM3\CMIS.dmp"
> > 2> go
> > Backup Server session id is: 23. Use this value when
> > executing the 'sp_volchange
> > d' system stored procedure after fulfilling any volume
> > change request from the B
> > ackup Server.
> > Backup Server: 6.28.1.1: Dumpfile name 'CMIS12215002D5
> > ' section number 1 moun
> > ted on disk file 'D:\DM3\CMIS.dmp'
> > Msg 3120, Level 16, State 1:
> > Server 'WSDDXLPPS1', Line 1:
> > The database you are attempting to LOAD was DUMPed under
> > a different sort order
> > ID (52) or character set ID (1) than the ones running on
> > this server (SortOrd =
> > 50, CharSet = 2). If the sort orders differ, at least
> > one of them is non-binary.
> >
>
> See the docs:
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38421.1570/html/ntconfig/ntconfig95.htm
>
> Note that you may need to do various follow-up actions as
> it can possibly invalidate existing indexes and text
> columns.
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide"
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference
> Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------

Thank you Rob, that documentation worked perfectly. I'm
running into a new issue now (hopefully my last issue).
When I try to run a query using my application, I get this:

<tablename> not found. Specify owner.objectname or use
sp_help to check whether the object exists (sp_help may
produce lots of output).

Now, I can see that the owner of all those tables is "dbo"
and I'm connected as the user sa. Would creating a user
named "dbo" and connecting as that user fix the problem? I
don't want to have to modify all my code to use
"dbo.tablename" so how can I specify that I'm the owner?

Thanks


ccassano Posted on 2012-08-08 15:33:10.0Z
Sender: 1840.50228561.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Re: How to change charset and sort order
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <502286b5.1863.1681692777@sybase.com>
References: <50228632.1853.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 8 Aug 2012 08:33:10 -0700
X-Trace: forums-1-dub 1344439990 172.20.134.41 (8 Aug 2012 08:33:10 -0700)
X-Original-Trace: 8 Aug 2012 08:33:10 -0700, 172.20.134.41
Lines: 83
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31325
Article PK: 74214


> > On 06-Aug-2012 21:22, ccassano@emprisecorporation.com
> > > wrote: Hi, I'm trying to load a dump file and I'm
> > > getting an error that the load failed because I have
> > > the wrong charset and sort order. How can I change
> > > these in my database so that the load works?
> > >
> > > D:\>isql -Usa -SWSDDXLPPS1 -w300
> > > Password:
> > > 1> load database CMIS from "D:\DM3\CMIS.dmp"
> > > 2> go
> > > Backup Server session id is: 23. Use this value when
> > > executing the 'sp_volchange
> > > d' system stored procedure after fulfilling any volume
> > > change request from the B
> > > ackup Server.
> > > Backup Server: 6.28.1.1: Dumpfile name 'CMIS12215002D5
> > > ' section number 1 moun
> > > ted on disk file 'D:\DM3\CMIS.dmp'
> > > Msg 3120, Level 16, State 1:
> > > Server 'WSDDXLPPS1', Line 1:
> > > The database you are attempting to LOAD was DUMPed
> > > under a different sort order
> > > ID (52) or character set ID (1) than the ones running
> > > on this server (SortOrd =
> > > 50, CharSet = 2). If the sort orders differ, at least
> > > one of them is non-binary.
> > >
> >
> > See the docs:
> >
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38421.1570/html/ntconfig/ntconfig95.htm
> >
> > Note that you may need to do various follow-up actions
> > as it can possibly invalidate existing indexes and text
> > columns.
> >
> > HTH,
> >
> > Rob V.
> >
> >
> ----------------------------------------------------------
> ------- Rob Verschoor >
> > Certified Professional DBA for Sybase ASE, IQ,
> > Replication Server
> >
> > Author of Sybase books (order online at
> > www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> > ASE" "The Complete Sybase IQ Quick Reference Guide"
> > "The Complete Sybase ASE Quick Reference Guide"
> > "The Complete Sybase Replication Server Quick Reference
> > Guide"
> >
> > rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> > @rob_verschoor Sypron B.V., The Netherlands | Chamber
> > of Commerce 27138666
> >
> >
> ----------------------------------------------------------
> -------
>
> Thank you Rob, that documentation worked perfectly. I'm
> running into a new issue now (hopefully my last issue).
> When I try to run a query using my application, I get
> this:
>
> <tablename> not found. Specify owner.objectname or use
> sp_help to check whether the object exists (sp_help may
> produce lots of output).
>
> Now, I can see that the owner of all those tables is "dbo"
> and I'm connected as the user sa. Would creating a user
> named "dbo" and connecting as that user fix the problem?
> I don't want to have to modify all my code to use
> "dbo.tablename" so how can I specify that I'm the owner?
>
> Thanks

I also want to add that when I connect with the username
"sa" through iSQL the queries work perfectly and I don't get
that error. So it's weird that using the same username from
my application gets different results then iSQL.


ccassano Posted on 2012-08-08 15:38:57.0Z
Sender: 1840.50228561.1804289383@sybase.com
From: ccassano@emprisecorporation.com
Newsgroups: sybase.public.ase.general
Subject: Re: How to change charset and sort order
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50228810.187f.1681692777@sybase.com>
References: <502286b5.1863.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 8 Aug 2012 08:38:57 -0700
X-Trace: forums-1-dub 1344440337 172.20.134.41 (8 Aug 2012 08:38:57 -0700)
X-Original-Trace: 8 Aug 2012 08:38:57 -0700, 172.20.134.41
Lines: 93
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31326
Article PK: 74215


> > > On 06-Aug-2012 21:22, ccassano@emprisecorporation.com
> > > > wrote: Hi, I'm trying to load a dump file and I'm
> > > > getting an error that the load failed because I have
> > > > the wrong charset and sort order. How can I change
> > > > these in my database so that the load works?
> > > >
> > > > D:\>isql -Usa -SWSDDXLPPS1 -w300
> > > > Password:
> > > > 1> load database CMIS from "D:\DM3\CMIS.dmp"
> > > > 2> go
> > > > Backup Server session id is: 23. Use this value when
> > > > executing the 'sp_volchange
> > > > d' system stored procedure after fulfilling any
> > > > volume change request from the B
> > > > ackup Server.
> > > > Backup Server: 6.28.1.1: Dumpfile name
> > > > 'CMIS12215002D5 ' section number 1 moun
> > > > ted on disk file 'D:\DM3\CMIS.dmp'
> > > > Msg 3120, Level 16, State 1:
> > > > Server 'WSDDXLPPS1', Line 1:
> > > > The database you are attempting to LOAD was DUMPed
> > > > under a different sort order
> > > > ID (52) or character set ID (1) than the ones
> > > > running on this server (SortOrd =
> > > > 50, CharSet = 2). If the sort orders differ, at
> > > > least one of them is non-binary.
> > > >
> > >
> > > See the docs:
> > >
> >
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38421.1570/html/ntconfig/ntconfig95.htm
> > >
> > > Note that you may need to do various follow-up actions
> > > as it can possibly invalidate existing indexes and
> > > text columns.
> > >
> > > HTH,
> > >
> > > Rob V.
> > >
> > >
> >
> >
> ----------------------------------------------------------
> > > ------- Rob Verschoor > Certified Professional DBA for
> > > Sybase ASE, IQ, Replication Server
> > >
> > > Author of Sybase books (order online at
> > > www.sypron.nl/shop): "Tips, Tricks & Recipes for
> > > Sybase ASE" "The Complete Sybase IQ Quick Reference
> > > Guide" "The Complete Sybase ASE Quick Reference Guide"
> > > "The Complete Sybase Replication Server Quick
> > > Reference Guide"
> > >
> > > rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> > > @rob_verschoor Sypron B.V., The Netherlands |
> > > Chamber of Commerce 27138666
> > >
> > >
> >
> >
> ----------------------------------------------------------
> ------- >
> > Thank you Rob, that documentation worked perfectly. I'm
> > running into a new issue now (hopefully my last issue).
> > When I try to run a query using my application, I get
> > this:
> >
> > <tablename> not found. Specify owner.objectname or use
> > sp_help to check whether the object exists (sp_help may
> > produce lots of output).
> >
> > Now, I can see that the owner of all those tables is
> > "dbo" and I'm connected as the user sa. Would creating
> > a user named "dbo" and connecting as that user fix the
> > problem? I don't want to have to modify all my code to
> > use "dbo.tablename" so how can I specify that I'm the
> owner? >
> > Thanks
>
> I also want to add that when I connect with the username
> "sa" through iSQL the queries work perfectly and I don't
> get that error. So it's weird that using the same
> username from my application gets different results then
> iSQL.

Well I think I know what's causing the issue but I need to
figure out how to fix it. If I login through iSQL and I
don't type "use master" and "use <DBNAME>" then I get the
same error. So I think my application isn't seeing the
table because it's not in the correct database.


Bret Halford Posted on 2012-08-08 17:38:06.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: How to change charset and sort order
References: <502286b5.1863.1681692777@sybase.com> <50228810.187f.1681692777@sybase.com>
In-Reply-To: <50228810.187f.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5022a3fe$1@forums-1-dub>
Date: 8 Aug 2012 10:38:06 -0700
X-Trace: forums-1-dub 1344447486 172.20.134.152 (8 Aug 2012 10:38:06 -0700)
X-Original-Trace: 8 Aug 2012 10:38:06 -0700, vip152.sybase.com
Lines: 109
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31327
Article PK: 74216


On 8/8/2012 9:38 AM, ccassano@emprisecorporation.com wrote:
>>>> On 06-Aug-2012 21:22, ccassano@emprisecorporation.com
>>>>> wrote: Hi, I'm trying to load a dump file and I'm
>>>>> getting an error that the load failed because I have
>>>>> the wrong charset and sort order. How can I change
>>>>> these in my database so that the load works?
>>>>>
>>>>> D:\>isql -Usa -SWSDDXLPPS1 -w300
>>>>> Password:
>>>>> 1> load database CMIS from "D:\DM3\CMIS.dmp"
>>>>> 2> go
>>>>> Backup Server session id is: 23. Use this value when
>>>>> executing the 'sp_volchange
>>>>> d' system stored procedure after fulfilling any
>>>>> volume change request from the B
>>>>> ackup Server.
>>>>> Backup Server: 6.28.1.1: Dumpfile name
>>>>> 'CMIS12215002D5 ' section number 1 moun
>>>>> ted on disk file 'D:\DM3\CMIS.dmp'
>>>>> Msg 3120, Level 16, State 1:
>>>>> Server 'WSDDXLPPS1', Line 1:
>>>>> The database you are attempting to LOAD was DUMPed
>>>>> under a different sort order
>>>>> ID (52) or character set ID (1) than the ones
>>>>> running on this server (SortOrd =
>>>>> 50, CharSet = 2). If the sort orders differ, at
>>>>> least one of them is non-binary.
>>>>>
>>>>
>>>> See the docs:
>>>>
>>>
>>
> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38421.1570/html/ntconfig/ntconfig95.htm
>>>>
>>>> Note that you may need to do various follow-up actions
>>>> as it can possibly invalidate existing indexes and
>>>> text columns.
>>>>
>>>> HTH,
>>>>
>>>> Rob V.
>>>>
>>>>
>>>
>>>
>> ----------------------------------------------------------
>>>> ------- Rob Verschoor > Certified Professional DBA for
>>>> Sybase ASE, IQ, Replication Server
>>>>
>>>> Author of Sybase books (order online at
>>>> www.sypron.nl/shop): "Tips, Tricks & Recipes for
>>>> Sybase ASE" "The Complete Sybase IQ Quick Reference
>>>> Guide" "The Complete Sybase ASE Quick Reference Guide"
>>>> "The Complete Sybase Replication Server Quick
>>>> Reference Guide"
>>>>
>>>> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
>>>> @rob_verschoor Sypron B.V., The Netherlands |
>>>> Chamber of Commerce 27138666
>>>>
>>>>
>>>
>>>
>> ----------------------------------------------------------
>> ------- >
>>> Thank you Rob, that documentation worked perfectly. I'm
>>> running into a new issue now (hopefully my last issue).
>>> When I try to run a query using my application, I get
>>> this:
>>>
>>> <tablename> not found. Specify owner.objectname or use
>>> sp_help to check whether the object exists (sp_help may
>>> produce lots of output).
>>>
>>> Now, I can see that the owner of all those tables is
>>> "dbo" and I'm connected as the user sa. Would creating
>>> a user named "dbo" and connecting as that user fix the
>>> problem? I don't want to have to modify all my code to
>>> use "dbo.tablename" so how can I specify that I'm the
>> owner? >
>>> Thanks
>>
>> I also want to add that when I connect with the username
>> "sa" through iSQL the queries work perfectly and I don't
>> get that error. So it's weird that using the same
>> username from my application gets different results then
>> iSQL.
>
> Well I think I know what's causing the issue but I need to
> figure out how to fix it. If I login through iSQL and I
> don't type "use master" and "use <DBNAME>" then I get the
> same error. So I think my application isn't seeing the
> table because it's not in the correct database.
>

Two main possibilities, I think:

1) your application issues a "use database <name>" and the
database no longer has the same name, in which case you either
rename the database to match the application, or change the
application.

2) your previous server had the user set up with a default
database. You can change the default database for a login
using sp_modifylogin

-bret