You could always use a trigger on BEFORE UPDATE/BEFORE INSERT which
changes NEW.column to LOWER(column). I know it's not declarative, but
it works.
sheeri kritzer wrote:
Not that I know of, but if you don't do binary (case-sensitive)
searching then does it really matter?? You can retrieve with LOWER, or
put it in your application, if your application needs to display it
that way.
-Sheeri
On 5/18/06, Ferindo Middleton <[EMAIL PROTECTED]> wrote:
I have column and I want to make sure the db is always making sure the
value
that gets input into this VARCHAR() column is always lowercase;
Is there a way to set the value of a column within a table to
automatically
be lowercase. I know how to use the LOWER() function when performing
queries
but is there a way to define LOWER( ) within the definition of the table
column itself without having the application specify LOWER( ) to any
value
passed to this column or if a record had to be manually input and the
admin
forgot to make sure all the characters were lowercase.
Ferindo
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED] mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http://www.mysql.com/cluster
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]