can i create a constraint to a field so that every data entered to that
field (string) be stored in uppercase, if is posible can anybody give me an
example or point me to a link with documentation.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi Ricardo,
can i create a constraint to a field so that every data entered to that
field (string) be stored in uppercase, if is posible can anybody give me
an
example or point me to a link with documentation.
MySQL doesn't support check constraints.
With regards,
Martijn Tonies
Database
Think that is for your script to work on, i.e.
INSERT INTO table
(field1, field2)
VALUES (UCASE('form.field1'), form.field2)
depending on the syntax of your programming language (and which MySQL
version you are using). The above works on 4.1.1.
Terry
--Original