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]