Software development & .NET RSS 2.0
 Monday, February 06, 2006

The project I'm working on at the moment requires the use of a Sybase database. To ensure we started with the correct version, the client made a dump of the current database. After installing the Sybase software - which went fairly smooth - we ran into the following error:

"The database you are attempting to LOAD was DUMPed under a different sort order ID (44) or
character set ID (2) than the ones running on this server (SortOrd = 41, CharSet = 2).
If the sort orders differ, at least one of them is non-binary."

For some reason Sybase removed the characterset with id #44 from ASE in the 12.5 release.
The following steps were needed to resolve the issue:
- Make a copy of C:\sybase\charsets\cp850\nocase.srt and name it nocase44.srt
- Edit the contents: change the id to 0x2C and the name to nocase_44
- CD to c:\sybase\ase-12_5\bin
- run charset nocase44.srt cp850
- Change the default sortorder id to 44 (sp_configure)
- Restart the server

Now you should be able to load the dump.

Monday, February 06, 2006 3:00:22 PM (W. Europe Standard Time, UTC+01:00)  #    Comments [2] -

Archive
<February 2012>
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
26272829123
45678910
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2012
Alex Keizer
Sign In
Statistics
Total Posts: 86
This Year: 0
This Month: 0
This Week: 0
Comments: 71
Themes
Pick a theme:
All Content © 2012, Alex Keizer
DasBlog theme 'Business' created by Christoph De Baene (delarou)