on 2011 Nov 07 5:13 AM
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
Request clarification before answering.
From the 12 docs "V10 - What's new in version 10":
Character set conversion is always enabled on the database server
The -ct database server option for enabling and disabling character set conversion is no longer supported. Character set conversion is always enabled for the database server, but if the database server determines that it is not required, then it is not used. You can disable character set conversion from the client by specifying CharSet=none. See CharSet (CS) connection parameter.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
87 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.