ASE 12.5 SQL -SELECT (Case sensitive)

[alexcubillos]

I'm upgrading an old application from sybase 7.0 to ASE 12.5. Actually, I have converted the database, but I have a problem, when I execute a simple Sql Sentence, the database engine is rejecting it, because it is validating the owner.table in case-sensitive format.
For example:
In the database i have a user DBA who owns a table BRANCH
If I execute this sentence: select * from dba.branch, it causes error because the name of user and table exists in database in UPPER CASE format.
This happens in development tool (PowerBuilder) and IJSQL..

The question is:
Exists any setting parameter or any instrucction to avoid this situation?.. All my Client program code is not case-sensitive... so...

Thanks a lot.

 

[nickpark]

Look up sort collation order - character sets in the sybase manual.

I think you can make it case insensitive, but that might apply to the data aswell. Sorry, cant be more help.