I think matt is thinking more automagically like having upper() called
on a column on insert for him instead of putting it into every query.
You can't do this yet. sorry.
-Eric
Jay Blanchard wrote:
[snip]
Can I setup a table so that no matter how data is entered into it (web
form,
command line) The data in one of the columns ALWAYS gets converted to
uppercase? I remeber MSSQL had this feature of being able to apply a
function to a field in its configuration.
[/snip]
The manual, it is amazing no?
http://dev.mysql.com/doc/mysql/en/string-functions.html
UPPER()
INSERT INTO `table` (`colFoo`)
VALUES (UPPER('myData'));
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]