uppercase field constraints
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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: uppercase field constraints
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 Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: uppercase field constraints
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 Message- 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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]