Is Sybase 12.5 case sensitive for table name
This is a discussion on Is Sybase 12.5 case sensitive for table name within the Sybase forums, part of the Database Server Software category; --> Hi, Is it possible to change case sensitive attribute for Sybase database ? Thanks, Laurent...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 04:09 PM
| |||
| |||
 Re: Is Sybase 12.5 case sensitive for table name On Wed, 17 Dec 2003 17:53:46 +0100, Laurent RUHLMANN wrote: > Hi, > > Is it possible to change case sensitive attribute for Sybase database ? 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@peppler.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      |
|
04-08-2008, 04:10 PM
| ||||
| ||||
| Re: Is Sybase 12.5 case sensitive for table name Michael Peppler wrote: > However you should be aware that this will make the entire server case > insensitive - i.e. for *all* string comparisons. 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 |
Linear Mode
