At 10:48 -0500 11/3/05, Malik Kuldeep-LKM041 wrote:
Hi, I have a requirement to always store the UPPER CASE text for the VAR and VARCHAR type columns in a table. Is there a way I can specify it during the CREATE TABLE statement?
Not in the CREATE TABLE statement. If you have MySQL 5.0, you could create an INSERT BEFORE trigger that uppercases the relevant column values before storing them. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]