> I have column and I want to make sure the db is always making sure the
> 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
> be lowercase. I know how to use the LOWER() function when performing
> 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
> forgot to make sure all the characters were lowercase.
If you're using MySQL 5, you could do this with a trigger.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!