Thanks, I am running MySQL 5.0. So the solution is applicable. Kuldeep Malik
-----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 10:00 AM To: Malik Kuldeep-LKM041; [email protected] Subject: Re: Always Storing Upper Case Text in a Table 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]
