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

carolstone's gravatar image

carolstone
3413817
accept rate: 22%

Just to understand: Is this an issue with DBISQL's auto complete feature using different case when listing table/column names?

Or does the Win7 version even distinguish case for identifiers when you write them out manually - i.e. does differ between MyTable and MYTABLE or does not find MyTable when spelled as MYTABLE? - That would be a bug IMHO...

That being said, I don't use case-sensitive databases, so I won't be able to help further:(

(20 Jun '11, 07:39) Volker Barth
Replies hidden

I'm not sure what behavior you're seeing, exactly. I just created a 10.0.1 case sensitive database on a Windows 7 machine, and connected with DBISQL. When I run

select db_property( 'CaseSensitive' );

I get "On" (just confirming that I'm connected to the right database).

I created a table called "Test":

drop table Test;
create table Test ( Catfish int primary key );

Then I typed the following

select * from Te

and pressed Ctrl+Space to open the text completer. It showed "Test". If you press Enter, it replaces "Te" with "Test". If I type

select * from te

and open the completer, I still see "Test", and completing the table name gives "Test" again. This is the expected behavior.

Is that what you are seeing?

I'm running 10.0.1.3415.

(20 Jun '11, 15:45) Chris Irie
Replies hidden

It's the autocomplete feature. It sounds like it's not a big deal, but it's not the only odd behavior we're experiencing related to case sensitivity, so I'm hoping to make some sense out of it.

(21 Jun '11, 10:41) carolstone

If you open the completer, you're seeing the table at all? If I have a table named TEST and I type te, I don't see it at all. If I have a table named test and I type T and open the completer, it's not in the list.

I am becoming convinced this is because my table owner is DBA (not dba).

(21 Jun '11, 10:44) carolstone

In my test, I also used "DBA" rather than "dba", so I'm not sure that's the problem. Would it be possible for you to post the exact statement you were working on when you ran into the problem?

(21 Jun '11, 13:43) Chris Irie
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×119
×105
×13

question asked: 17 Jun '11, 18:19

question was seen: 2,300 times

last updated: 21 Jun '11, 13:43