|
Home > Archive > ASE Database forum > September 2005 > Will sort order affect data searching?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Will sort order affect data searching?
|
|
|
| If Sybase is set to case insensitive in sort order, will
that affect data
search? Will select field1 from table1 where field1 = 'abc'
return both
ABC and abc?
Thanks!
> On Thu, 22 Sep 2005 11:09:24 -0700, Frank Rizzo wrote:
>
>
> Case sensitivity is based on the sort-order loaded in the
> server, and is an all-or-nothing configuration. If you
> have a case-insensitive sort order then a table called
> 'order' and one called 'ORDER' would be one and the same,
> same thing for users called 'user' and 'USER', etc.
>
> AFAIK this is true of all versions of ASE.
>
> Michael
> --
> Michael Peppler [TeamSybase] mpeppler@peppler.org -
> http://www.peppler.org/ Sybase DBA/Developer
> Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
>
>
| |
| Sherlock, Kevin 2005-09-26, 8:25 pm |
|
<Jmgxu> wrote in message news:43385ab1.7c08.1681692777@sybase.com...
> If Sybase is set to case insensitive in sort order, will
> that affect data
> search? Will select field1 from table1 where field1 = 'abc'
> return both
> ABC and abc?
yes
|
|
|
|
|