Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    61

    Unanswered: input mask and mysql

    is there a way to have MYSQL server handle input masks?

    When a person enters in data in lowercase, is there a way to have mysql server make everything uppercase?

    I know that i can do this with JAVA or PHP, but i was just wondering if MYSQL can do it.

    I'm using phpmyadmin to configure mysql...

    thanks
    Noam

  2. #2
    Join Date
    Jan 2004
    Location
    Germany
    Posts
    17
    UCASE(str) converts 'str' to uppercase. There is no way (afaik) to make mysql automatically converting all string inputs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •