Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Uppcase string

Status
Not open for further replies.
jkscript

jkscript

Programmer
Jun 20, 2002
9
0
0
GB
Hi All,

Is it possible to accept a string and make it uppercase before storing it in the database?

Can this be done in the CREATE TABLE method?


Cheers
 
Sort by date Sort by votes
What you are asking is not a property of a table. "CREATE TABLE" will not do it.

When you insert your data, use MySQL's ucase() function:

insert into bar (the_data) values (ucase('foo')) ______________________________________________________________________
TANSTAAFL!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cmayo
  • Locked
  • Question
LIKE with wildcard where the string being matched ends with a non-digit 1
Replies
2
Views
53
cmayo
cmayo
m0nkie
  • Locked
  • Question
String pattern find and set as variable
Replies
1
Views
57
jpadie
jpadie
penguinspeaks
  • Locked
  • Question
Connection String Giving issues
Replies
8
Views
88
jpadie
jpadie
spamjim
  • Locked
  • Question
Finding one of an array of tokens in a particular string position 2
Replies
3
Views
41
jpadie
jpadie
admoore
  • Locked
  • Question
select part of a field string
Replies
1
Views
39
admoore
admoore

Part and Inventory Search

Sponsor

Back
Top