Case sensitivity in Sybase Database

[filagan]

I am a new Sybase user and just installed sybase 12.5 on a Win2K system. I noticed that column names and tables names are case sensitive when used in an SQL command. Is there a database option that can be set to disable case sensitivity?

 

[sybaseguru]

I assume that you are coming from Oracle background or something similar. Sybase enforces case sensitivity for object names etc. All stored procedures are case sensitive as well. Commands such as "CREATE TABLE" or "create table" you can use both cases. However not objects. As far as I know there is no such flag to turn the case sensitivity option off. The reason being that sybase stores information about database objects in system tables starting with "sys" such as sysobjects etc. These are stored in case sensitive format. Sorry

 

[expostfacto]

you just need to set the sort order to a case-insensitive one.

http://manuals.sybase.com/onlinebooks/group-ch/chg0300e/charsets/@Generic__BookTextView/796

http://www.carnageblender.com:

Carnage Blender. Over 40 million battles served.