Change a Database Properties On SQL Anywhere 9

Question

i need to change the property (Casesnsitve = on To Casesnsitve = oFF ) for a Databse created on SQl Anywhere 9

Answer 1

You can't change the case sensitivity of an existing database. You will have to create a new database (the easiest way is to use the dbinit utility, but don't use the -c switch), and then use the dbunload utility to unload and reload the data into the new database.