Table/Column name case

[Former Member]

I have a database in SQL Anywhere 9 and the application is written in PowerBuilder 10.

I created the tables and columns with all upper case names. When I connect in PowerBuilder it shows them all in lower case. When I view them in Sybase Central they show in upper case.

I there a setting in SA or PB that can fix this issue?

[VolkerBarth]

I would assume that this is a PB issue. AFAIK, table names (as all identifiers) are generally case-insensitive, and SA stores them exaclty as you enter them. - That assumed, I don't know PB so can't tell whether there's an according option...

[Breck_Carter]

I will take your word for the fact Sybase Central honors the original CREATE TABLE case, since that behavior is predicted by the motto "Watcom does things the way they should be done."

SQL Anywhere Adaptive Server Anywhere Version 9 dbisql does the same, echoes the names back in the original case:

PowerBuilder 10 mucks it up differs in two ways... all lower case in the tree view on the left, and capitalized in the DataWindow view on the right (the latter is probably desired behavior, but the former is not):

So, it ain't got nothing to do with the SQL Anywhere engine... that leaves PowerBuilder and ODBC.

However, an examination of the ODBC Driver Properties in the PowerBuilder Database painter reveals that SQL_IDENTIFIER_CASE = 4 which (I am pretty sure) means "SQL_IC_MIXED – identifier names are not case sensitive, and are stored in mixed case in the system catalog" which AFAIK is an accurate description of how SQL Anywhere, er, Adaptive Server Anywhere databases present themselves to the outside world:

So... that leaves PowerBuilder... perhaps something in that funky PB - ODB - INI file that has bedeviled generations of PowerBuilder developers?

I leave that as an exercise for others 🙂

[Former Member]

Thanks. I found the setting in the .ini file and got it to work how I want it.

[MarkCulp]

@Roland: For future users that have this problem, can you tell everyone what the name of the setting was and what change you made? - Thanks