I have encoutered a problem when upgrading from sybase 5 to 10 on DBs. It
happpens when it is run under regional settings other than "English".


This is for example when runing under Chinese tradional:

dbunload.exe -c "DBF=c:\pixelsql\PIXELSQLBASE.DB;UID=DBA;PWD=passw ord" -an
c:\pixelsql\PIXELSQLBASE10.DB -o c:\pixelsql\migration.log -v

this is the error ( not legible in most part , except for the charset cp850
part... )

***** SQL error: AL?kab!n?D??arA? 'os_charset' ?PcU?a?warA? 'cp850' Ai?O??


If the OS is set to "english" then the upgrade process runs fine but the
data in the resulting DB is not legible.
The unlegible DB is showing as cp850 charset.


So far the best work around I found is to create a blank DB (UNC for
example) and then migrate the structure using the unlegible DB as source.
Then pump ( custom ODBC to ODBC utiltiy ) the data again from Sybase 5 to
the just created Sybase 10 ( UNC ).


It is ok to do one such way , but my goal is develop a utility for out of
the box install that could be used by 1000s ( our install base running
sybase 5 is in many 1000s and we expect a good portion of them migrate to
Sybase 10 as they upgrade our software ).

Any tips?

perfect would be to find a way to just use the DB unlaod in a way that would
upgrade a legacy DB to a new Sybase 10 ( 11? ) witout too much effort.