Todd,
I absolutly disagree:
A database is a container holding some peaces of information.
Usually, a database is transparent for the programmer: He doesn't need
to about the details of the soring-mechanisms, but *what* he has to
know is that "fooBar" != "FooBar" - fullstop.
if you application needs a feature, that i.e. a search is
case-insensitiv, then he will have to code it - there are tons of
functions available just exactly for this purpose (i.s.
String.equalsIgnoreCase() etc.).
Anyways, coming slightly back topic:
If somebody else should run into the same problem, it's easy to fix by
either using a sliglty modified "create-table" - statement having the
"binary"-attribute:
create table foo (
bar varchar (40) binary not null;
)
or changing existing tables using this alter-statement also containing
the "binary"-attribute:
alter table [table-name] change [column-name-old] [column-name-new]
varchar(length) binary;
Cheers
Gregor
--
what's puzzlin' you, is the nature of my game
gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2
gpgp-key available @ http://pgpkeys.pca.dfn.de:11371
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
