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 wOOdy-Soft 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
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
187
cmayo
cmayo
m0nkie
  • Locked
  • Question
String pattern find and set as variable
Replies
1
Views
174
jpadie
jpadie
penguinspeaks
  • Locked
  • Question
Connection String Giving issues
Replies
8
Views
284
jpadie
jpadie
spamjim
  • Locked
  • Question
Finding one of an array of tokens in a particular string position 2
Replies
3
Views
156
jpadie
jpadie
admoore
  • Locked
  • Question
select part of a field string
Replies
1
Views
120
admoore
admoore

Part and Inventory Search

Sponsor

Back
Top