|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Convert to uppercase
I have a database with 50 tables that contains around 3,000 fields.
I need to convert all the data from all the fields into all uppercase. Is this possible? |
|
#3
|
|||
|
|||
|
i do not think this would be possible ..
as the upper() function makes the respective field-contents to be of the uppercase. such function could be an issue for further development in the MySql rdbms |
|
#4
|
||||
|
||||
|
I can't see there being enough demand for this type of process to build it into MySQL itself...
I would suggest writing a simple script/program to grab all the data from each table, convert it to uppercase, and update the data... It not be the most efficient process, but I hope it isn't being done too often. |
|
#5
|
|||
|
|||
|
The point of upper() is that there's no reason for it to be uppercase in your database -- leave it like it is, and use upper() as you query your data out. Formatting of the raw data should be kept to a minimum.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Convert to uppercase |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|