Hi Christopher,
I knew that MySql does this, but I am using Postgres for this project
and don't know if it is possible, the default is case sensitive for
Postgres.
The unique key option is out, as it has to be an id field for our
database beans to work, but a unique constraint is possible I guess...
maybe worth looking at!
Thanks
Peter
Christopher Schultz wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Pedro,
Pedro wrote:
I basically need to implement case insensitive user names, can this be
done with a servlet filter or do I need to subclass JDBC realm:
Er, before you get too far on this, check to see if your database
already does this without you realizing that it does.
For instance, MySQL does case-insensitive VARCHAR and CHAR lookups
unless the column type is marked BINARY or you cast the type to BINARY
in your SQL query.
For instance, 'chris' = 'CHRIS' in MySQL inder normal circumstances.
Primary and unique keys respect this behavior, too, so I can't have
"chris" and "CHRIS" as two separate usernames in my user table where
"username" is a UNIQUE key.
You might be able to save yourself a lot of trouble.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFHIQru9CaO5/Lv0PARAkV6AJ9eBvJFTb8HCA5lL/6iU17AVF4DyQCgoDWg
TA5RHoInDsnxkDSqILJiYvI=
=J3qJ
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
