Hi,
Sybase is (by default) in a search not case sensitive.
This is in general fine by me, but in some cases, I want the (Servoy) search or Servoy Query to be case sensitive.
Is this possible, without doing this server-wide?
Thanks.
anyone?
Hi Harjo! I think it’s just you & me in here today.
Of course this would have something to do with the collation chosen. By the way, if you use Sybase Central to set up your db’s and you click the button to emulate ASE settings, the default becomes “case senstive” string comparison.
Now I can’t be much help because (1) I’ve never tackled this problem myself, and (2) Sybase Central is choking on some kind of incompatibility on my computer at the moment.
But what I can offer is this link to what looks like the relevant chapter in Sybase’s online docs.
good luck! let us know what the trick is,
kazar
When you create your database, as kazar mentions, you can make it case sensitive for string comparisons (using an option in Sybase Central, or the -c switch for the dbinit utility or the CASE clause of the CREATE DATABASE statement).
However, if you just want to occasionally do a case sensitive comparison, you can use the COMPARE function, documented in the online help:
http://dcx.sybase.com/index.php#http%3A … 23d4e10039
Fyi,
In Servoy 4.2 it will be possible to define relations with case-insensitive comparison operators.
Rob