Re: Always Storing Upper Case Text in a Table

2005-11-03 Thread Paul DuBois
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

Re: Always Storing Upper Case Text in a Table

2005-11-03 Thread SGreen
Malik Kuldeep-LKM041 [EMAIL PROTECTED] wrote on 11/03/2005 10:48:21 AM: 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? Kuldeep Malik No. That is something

RE: Always Storing Upper Case Text in a Table

2005-11-03 Thread Malik Kuldeep-LKM041
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; mysql@lists.mysql.com Subject: Re: Always Storing Upper Case Text in a Table