Changing character set and sort order after ASE 12.5.2 GA install

After a fresh install of the ASE 12.5.2 GA CD, I wanted to change the
charset and sort order via sqlloc.

I was changing it to charset utf8 and sort order bin_utf8 ( 50 ), but I get
an error saying: 

        The sort order bin_utf8 for character set utf8 must be loaded .. blah ..


I did NOT have this problem years ago when I installed from ASE 12.5.0.3 (
That's 12.5.0.3, NOT 12.5.3 as I don't have a full distribution CD for
12.5.3 )

What to do ?

0
Jesus
11/23/2006 10:29:01 PM
sybase.ase.general 8655 articles. 0 followers. Follow

3 Replies
667 Views

Similar Articles

[PageSpeed] 40

I found a Sybase TS support case which states this is a known bug with 12.5.2 GA, ie, sqlloc normally calls the 'charset' program to load sort orders ... but sqlloc is (basically) broken in 12.5.2 (GA).

Possible fixes/work arounds:

1 - upgrade to 12.5.2 ESD #2 (or higher)

2 - use the 12.5.1 version of sqlloc (assuming you have a copy of 12.5.1 available)

3 - install the sort order by hand using the 'charset' program and then re-run the 12.5.2 (GA) version of sqlloc

Jesus M. Salvo Jr. wrote:

> After a fresh install of the ASE 12.5.2 GA CD, I wanted to change the
> charset and sort order via sqlloc.
> 
> I was changing it to charset utf8 and sort order bin_utf8 ( 50 ), but I get
> an error saying: 
> 
>         The sort order bin_utf8 for character set utf8 must be loaded .. blah ..
> 
> 
> I did NOT have this problem years ago when I installed from ASE 12.5.0.3 (
> That's 12.5.0.3, NOT 12.5.3 as I don't have a full distribution CD for
> 12.5.3 )
> 
> What to do ?
> 
0
Mark
11/24/2006 12:15:18 AM
Mark A. Parsons wrote:

> I found a Sybase TS support case which states this is a known bug with
> 12.5.2 GA, ie, sqlloc normally calls the 'charset' program to load sort
> orders ... but sqlloc is (basically) broken in 12.5.2 (GA).
> 
> Possible fixes/work arounds:
> 
> 1 - upgrade to 12.5.2 ESD #2 (or higher)
> 
> 2 - use the 12.5.1 version of sqlloc (assuming you have a copy of 12.5.1
> available)
> 
> 3 - install the sort order by hand using the 'charset' program and then
> re-run the 12.5.2 (GA) version of sqlloc
> 

Thanks ... Patched up to 12.5.3 ESD#7 and sqlloc is working.
0
Jesus
11/24/2006 12:43:08 AM
That's even better ... the later releases of 12.5.3, as well as 12.5.4, seem to be more stable/solid versions of ASE.

Jesus M. Salvo Jr. wrote:

> Mark A. Parsons wrote:
> 
> 
>>I found a Sybase TS support case which states this is a known bug with
>>12.5.2 GA, ie, sqlloc normally calls the 'charset' program to load sort
>>orders ... but sqlloc is (basically) broken in 12.5.2 (GA).
>>
>>Possible fixes/work arounds:
>>
>>1 - upgrade to 12.5.2 ESD #2 (or higher)
>>
>>2 - use the 12.5.1 version of sqlloc (assuming you have a copy of 12.5.1
>>available)
>>
>>3 - install the sort order by hand using the 'charset' program and then
>>re-run the 12.5.2 (GA) version of sqlloc
>>
> 
> 
> Thanks ... Patched up to 12.5.3 ESD#7 and sqlloc is working.
0
Mark
11/24/2006 1:10:49 AM
Reply:

Similar Artilces:

Can I use ASE 12.5.2 64-bit license on an ASE 12.5.2 32-bit install
I want to install sybase ASE 12.5.2 on my machine (2GB of memory) but my license certificate has a 64 bit license only. Can I use the 64-bit license on my 32 bit ASE 12.5.2 installation? thanks Gemma No you cannot > I want to install sybase ASE 12.5.2 on my machine (2GB of > memory) but my license certificate has a 64 bit license > only. > > Can I use the 64-bit license on my 32 bit ASE 12.5.2 > installation? > > thanks > Gemma ...

looking for recommendations about installing ASE 12.5.2 and ASE 12.5.3 on HP-UX IPF
Hi, We are about to install ASE 12.5.3 esd#7 64bit on HP-UX IPF server. Are they any recommendations regarding installing on HP Itanium 64bit servers? Is there a best practices document for ASE 12.5.3 ? thanks. Itzhak. izik_is@yahoo.com wrote: > > Hi, We are about to install ASE 12.5.3 esd#7 64bit on HP-UX IPF > server. > Are they any recommendations regarding installing on HP Itanium 64bit > servers? > Is there a best practices document for ASE 12.5.3 ? There's no specific document. There are comments and recommendations in the SAG (System Admi...

ASE 12.5.2 to ASE 12.5.0.3
Hello, I have to return to ASE 12.5.0.3 from ASE 12.5.2. I created a new server and did a dump/load of a user database and that seems to be fine. Is this a safe way to downgrade ? Is it necessary to create a new server (master database) or should it also be possible to shutdown the 12.5.2 server and start it again with the 12.5.0.3 binary ? Thanks, Luc. ...

Dump on ASE 12.5.2 and Load on ASE 12.5.3
Is possible to make one dump database in ASE 12.5.2 and later making one load of this archive in ASE 12.5.3? It is possible to dump a database in 12.5.2 and load it onto 12.5.3. -bret Leandro wrote: > Is possible to make one dump database in ASE 12.5.2 and > later making one load of this archive in ASE 12.5.3? I recently dumped from 12.0 & loaded to 12.5, was pleasantly surprised the load process upgraded the database automatically. <Leandro> wrote in message news:425d7e31.7943.1681692777@sybase.com... > Is possible to make one dump database in ASE 12...

ASE 12.5.2 or ASE 12.5.3 on Solaris 10
Hi there! Have anyone found whitepapers or documentation regarding ASE on Solaris 10? I have tried to search around on sybase.com, but without any luck. I'm particulary looking into zones/containers with ASE and if there is any issues regarding this. Any help is much appreciated. ..prn Hi, As for as i known there aren't whitepapers or docu. I have a couple of boxes with ASE in a zone. So if you have questions mail me. Sjaak Preben Olsen wrote: > Hi there! > > Have anyone found whitepapers or documentation regarding ASE > on Solaris 10? I h...

Does ASE 12.5.3 IR is a EBF for ASE 12.5.2?
This is a multi-part message in MIME format. --------------090403060603000107000502 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I noticed that release description of ASE 12.5.3 like the following: *Product Name: * Adaptive Server Enterprise *Platform: * Win NT *Release Version: * 12.5.2 *Release Description: * EBF 12150: 12.5.3 IR *Release Date: * 01 Dec 2004 So it seems that it's a EBF of ASE 12.5.2. But it seems not possible to download it. :( What's the matter? Must pay for that? Best Regards FlyBe...

Migration from ASE-64 bits 12.5.0.2 to ASE 64 bits 12.5.3 for AIX 5.3
Here there someone to indicate me the road tasks in order to migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 bits) Thank you kamel wrote: > Here there someone to indicate me the road tasks in order to > migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 > bits) > > Thank you Apply 12.5.2 IR then 12.5.3 esd 5. -- Jason L. Froebe http://jfroebe.livejournal.com http://www.propsmart.com Team Sybase On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote: > Here there someone to indicate me the road tasks in order to migrate an > ASE 12.5.0.2 ...

Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, We are in the process of planning the upgrade of our ASE 12.5.4 dataservers to ASE 15.x. What is the most recommended way to upgrade ASE dataservers from ASE 12.5.4 to ASE 15.x? Potential options: 1) Install new instances of ASE 15.x and load database dumps from our ASE 12.5.4 dataservers to the newly installed ASE 15.x dataservers. - OR - 2) Use the ASE upgrade utility (sqlupgrade) to upgrade our existing ASE 12.5.4 dataservers to ASE 15.x. What are the Pros vs. Cons for loading a 12.5.4 database into a 15.x ASE dataserver versus performing an ASE dataserv...

Vulnerability of ASE 12.5.2 vs ASE 12.5.3 ESD#3
Recently, Application Security, Inc. has run a vulnerability test on our ASE12.5.2. The program gave a 'high risk' on the ASE12.5.2 and suggested we install the latest Sybase patch 12.5.3 ESD#3. I have some question on the recommendation. 1. The latest patch is definitely not 12.5.3 ESD#3. Why did the program recommend 12.5.3 ESD#3? Isn't 12.5.4 better than 12.5.3? 2. Is it practical to keep up with the latest releases or patches? Now if we upgrade to 12.5.4 and then rerun the vulnerability test, will the program suggest that newer version is better with respect to s...

BACKUPS ASE 12 y ASE 12.5.2
Tengo un ASE 12 que demora en sacar respaldos 5 min y otro ASE 12.5.2 que se demora 8 min, la pregunta es porque en la nueva version se tarda mas tiempo en crearse el respaldo y el respaldo que se crea es bastante amplio. Robertho wrote: > Tengo un ASE 12 que demora en sacar respaldos 5 min y otro > ASE 12.5.2 que se demora 8 min, la pregunta es porque en la > nueva version se tarda mas tiempo en crearse el respaldo y > el respaldo que se crea es bastante amplio. Hi Robertho, the difference in time can often be attributed to the size difference of the transaction l...

Upgrading from ASE 12.0 to ASE 12.5.2
Hi everyone, I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2. How would the migration process be. Is it straight dump and load or otherwise ?? regards Paresh. Paresh wrote: > Hi everyone, > > I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2. > > How would the migration process be. Is it straight dump and load or > otherwise ?? > > regards > > Paresh. > > see the upgrade/installation guide joop -- Senior Consultant Sybase Professional Services New address per 21 November 2005: Zo...

bad instalation ASE 12.5.2 ESD #1 ofer 12.5.1
I install EBF 11948 on 12.5.1 This is only for 12.5.2 My serwer not start. I not have 12.5.2. My 12.5.1 dev version it isn't installed because it is statement that can't installed at new version. What I can do? Dark "Dark" <darkmartin@box43.pl> wrote: > I install EBF 11948 on 12.5.1 > This is only for 12.5.2 > My serwer not start. I not have 12.5.2. > > My 12.5.1 dev version it isn't installed because it is statement that can't > installed at new version. > > What I can do? Reinstall ASE. Next time, appl...

ASE 12.5.2. Sort Order Id issue (WIN2003)
Hello everybody, I have installed Sybase ASE 12.5.2. successfully in my WIN2003 Server, but I have an issue when I tried to change the sort order using the Server Config Tool or SQLAdvantage using the Stored procedure (sp_configure "sortorder id", 56). The default sort order is "Binary ordering for use with CodePage 850 (cp850) " but I want to change to "spanish case and accent insensitive dictionary order". This kind of change require to restart the server, when the server is restarted the changes weren't done. Could you help me, please? Best ...

WIN2K PRO ASE DEV 12.5.1 & 12.5.2 Install Fails
Completing a NEW install on WIN2KPRO SP4. Previously had installed 11.5 Sybase with no problems. No need to upgrade so performing fresh install. Process hangs with ctlib connect error at creation of master device but then succeeds (12.5.1), never succeeds 12.5.2. For 12.5.1, process again hangs ctlib connect error after sqlserver boots for masterdb creation. Never get this far in the 12.5.2 install. For fun, performed same 12.5.2 install on WINXPPRO system and it succeeded all the way thru. On WIN2KPRO, I monitor, via netstat, connections/ports and sqlserver does boot, is list...

Web resources about - Changing character set and sort order after ASE 12.5.2 GA install - sybase.ase.general

Dilbert (character) - Wikipedia, the free encyclopedia
Dilbert is a fictional character and the main character and protagonist of the Dilbert comic strip . He is a white collar office worker who has ...

Zuckerberg posted pictures of his daughter and dog dressed as 'Star Wars' characters
Mark Zuckerberg seems just as excited about the launch of "Star Wars: The Force Awakens" this week as everybody else — judging by the two new ...

‘Arrow’ Casts Vixen: Megalyn Echikunwoke To Play DC Comics Character
Team Arrow is expanding. DC Comics character Vixen (aka Mari Mable) will be joining the The CW ’s Arrow with Megalyn Echikunwoke in the role. ...

Benedict Cumberbatch Calls Sherlock Holmes Character A 'Meritocracy'
Benedict Cumberbatch says his Sherlock Holmes character in BBC's "Sherlock" is a "meritocracy."

All the character themes in SFV
... sure how the audio in this installment was shaping up. Turns out it's in good hands. You can listen to the extended themes for every character ...

"Don Verdean" and "Napoleon Dynamite" Creator Jared Hess On Character-Based Movies
... goes into creating the kooky people who populate his films. There's a reason most of Jared Hess's films share titles with their lead characters. ...

With Diverse Characters, 'The Force Awakens' Has Great Success While Practicing Inclusive Casting
There was an immediate racist backlash when trailers for 'The Force Awakens' were first released showing John Boyega as a prominent character. ...

Lex Luthor Is Most Important Character In 'Batman V Superman: Dawn Of Justice' Movie Says Affleck
Everyone's talking about Ben Affleck, Gal Gadot, or even the main villain Doomsday whenever talking about upcoming movie "Batman V Superman: ...

We Now Know the Backstory of Greg Grunberg's Star Wars Character
In grand Star Wars tradition, Greg Grunberg’s X-Wing pilot has a rich background that can only be found in the tie-in materials. Minor spoilers ...


Resources last updated: 12/24/2015 1:54:51 PM