I've got dbisqlg (10.0.1 build 4075) with our database built in SQL Anywhere Version 10.0.1.4075.
When we run this combination on a Windows XP machine and press control-space, table names are NOT case sensitive. When we run this combination on a Windows 7 64-bit machine and press control-space, table names ARE case sensitive.
I would like to know if there is a way to make the table names not case sensitive while leaving the data case sensitive. When we created our database in the first place, we set some switches:
CREATE DATABASE 'my.db' TRANSACTION LOG ON CASE RESPECT PAGE SIZE 4096 BLANK PADDING OFF
The documentation states "Identifiers in the database are always case insensitive, even in case-sensitive databases" if you choose 'Case Respect,' but that doesn't seem to be working the same? Did we use the wrong switch or is there another switch we should set somewhere? Is there something Win7 does differently from XP that we didn't set right?
I think I've read through the entire list under "database options" (unless I missed one) and I haven't been able to find anything.
This may not sound like a big deal, but we've got a few case-sensitivity issues going on and I'm really hoping if I can understand (or fix) this relatively simple case, I can make headway against the ones that involve a larger set of applications.
asked 17 Jun '11, 18:19