I'm trying to follow the instructions on this page to start the database with character set translation turned off. According to the instructions from this page: dbeng9 -ct- c:\oem.db Since, I'm using version 12. I'm trying dbeng12 -ct- c:\oem.db Error in command near "ct". In the server options of dbeng12 also I can not find the option -ct. Can someone please tell me how can I start the database with character set translation turned off, for the Sybase Anywhere v 12. Thanks |
From the 12 docs "V10 - What's new in version 10":
So you will have to omit this option with v12. If the reload does not work as expected, I would try using DBISQL with the CS parameter (as specified above) or with a fitting ENCODING clause of the LOAD TABLE statements in the reload.sql script. Thanks. Could you tell how I can add encoding clause to the load statement? currently i'm simply doing "read reload.sql". The problem i'm having is after updating db, the non-english characters become unreadable.
(07 Nov '11, 07:09)
sam
Replies hidden
1
I would suggest to answer the questions on your other question, i.e. what collation you have used so far and what collation you want to use (or what locale do you use) - that may help us to give better help.... To your current question: The reload.sql script might contain LOAD TABLE statements (when the UNLOAD tool was told to use internal reload), and these can have an ENCODING <your-code-page> clause. Alternatively, the DBISQL READ statement can use an ENCODING clause itself.
(07 Nov '11, 07:41)
Volker Barth
|
Here is a v12 doc page "Change a database from one collation to another" that seems more suitable than the v9-specific dpo page you relate to.
Unfortunately, it doesn't have a sample but you might get the impression...