mySQL Uppercase fields

[daveporter]

Hi All,

Can a mySQL varchar field be forced to have it's content automatically uppercase ?

An attribute maybe...

Can't find any details...

regards Dave P

[kennyisnotdead]

I'm not to sure about setting it to all uppercase. but you can write script that will make the content upper case before it is entered into the table.

[redemption]

yup i'm also not sure about setting it as an attribute but you could always use UPPER(col_name) in your SELECT statements to extract them in uppercase...

[TheDude]

From the mySQL manual, http://www.mysql.com/documentation/m...ring_functions

- - - - - - - - - - - - - - -

LCASE(str)
LOWER(str)
Returns the string str with all characters changed to lowercase according to the current character set mapping (the default is ISO-8859-1 Latin1):

mysql> SELECT LCASE('QUADRATICALLY');
-> 'quadratically'

This function is multi-byte safe. UCASE(str)
UPPER(str)
Returns the string str with all characters changed to uppercase according to the current character set mapping (the default is ISO-8859-1 Latin1):

mysql> SELECT UCASE('Hej');
-> 'HEJ'

This function is multi-byte safe.
- - - - - - - - - - - - - - -