Hi,

Is it possible to change case sensitive attribute for Sybase database ?


Thanks,

Laurent

On Wed, 17 Dec 2003 17:53:46 +0100, Laurent RUHLMANN wrote:

Yes - you simply load a case-insensitive sort order, via sqlloc (on unix,
don't know what the program is called under Windows).

However you should be aware that this will make the entire server case
insensitive - i.e. for *all* string comparisons.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html

Michael Peppler wrote:

Just to add to what Michael wrote -- with a case-insensitive
character set, you can still manage to do case-sensitive
string comparisons in your SQL statements, but it isn't pretty.


Larry Coon
University of California