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 <ferindo.middleton@stripped> 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: jay@stripped mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http://www.mysql.com/cluster
