O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
If you want to convert a string to uppercase or lowercase, but UPPER() and LOWER() won’t work, you’re probably trying to convert a binary string. Convert it to a nonbinary string so that
...
If you want to convert a string to uppercase or lowercase, use the
UPPER() or
LOWER() function. If they
don’t work, see “Converting the lettercase of a...