When we unload our Database in dat-Files with ASA 9 or ASA
11 (Dataformat: cp850), we can't reload the exported data &
structur in a new ASA 11 UTF-8 DB. Create a new ASA 11
Database is not the Problem. Only run the Reload.sql - File
with the cp850 Encoding Data.

What is the Problem?

First off you should only use V11 of DBUnload
for this. (v9 dbunload will not know how to prepare
for a V11 upgrade and can introduce behaviours
that are addressed in the V11 dbunload)

To make dbisql handle the different charsets
you used to use the -codepage switch. But
since that switch was deprecated you should
probably use the ENCODING parameter
in your READ statement, as in:

dbisql -c "..." READ reload.sql ENCODING CP850

http://dcx.sybase.com/1101en/sachang...s-5021262.html
[search for -codepage and link to the READ statement as well]

It seems to parse that okay but cp850 is not listed as a supported
code page, so if you find you have data conversion troubles
with that you could convert the charset using the v9 s\w
first (to utf8) and upgrade that result later with dbunload -ar
[with the v11 s\w for that last step].

<Thomas Hoffmann> wrote

Dear Nick,

thank you for your response. We can now create a new SQL9
UTF8-DB
and unload the Data from Customer in this the new db. It
only works with the Sybase-Tool when we choose the option
"Unload and Reload in an existing DB". But we have over 1200
Customer-DB's. We will create a tool, what it make this
automatically.

What is the Console-Command by the option "Unload and Reload
in an existing DB"?

We have try:
unload -c "uid=dba;pwd=XXX;dbf=C:\custDBcp850.db" -ac
"uid=dba;pwd=sql;dbf=C:\newDButf8.db"

And we have try:
unload -c
"uid=dba;pwd=XXX;charset=cp850;dbf=C:\custDBcp850. db"
-ac
"uid=dba;pwd=sql;charset=utf8;dbf=C:\newDButf8.db"

But it doesn't works. We have Problem with some special
signs (æ).

Kind regards,

Thomas

-ar is your dbunload switch of choice here.

<Thomas Hoffmann> wrote

Dear Nick,

thank you for your response. We can now create a new SQL9
UTF8-DB
and unload the Data from Customer in this the new db. It
only works with the Sybase-Tool when we choose the option
"Unload and Reload in an existing DB". But we have over 1200
Customer-DB's. We will create a tool, what it make this
automatically.

What is the Console-Command by the option "Unload and Reload
in an existing DB"?

We have try:
unload -c "uid=dba;pwd=XXX;dbf=C:\custDBcp850.db" -ac
"uid=dba;pwd=sql;dbf=C:\newDButf8.db"

And we have try:
unload -c
"uid=dba;pwd=XXX;charset=cp850;dbf=C:\custDBcp850. db"
-ac
"uid=dba;pwd=sql;charset=utf8;dbf=C:\newDButf8.db"

But it doesn't works. We have Problem with some special
signs (æ).

Kind regards,

Thomas