Shulou(Shulou.com)06/01 Report--

How does mysql convert strings to uppercase? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

In mysql, you can use the uppercase conversion function UPPER () to convert all alphabetic characters in a string to uppercase; the "UPPER (str)" function returns the string str, changing all characters mapped to uppercase based on the current character set.

The uppercase conversion function UPPER (str) in MySQL converts all alphabetic characters in the string str to uppercase.

Returns the string str, changing to uppercase based on all characters mapped by the current character set.

[example] use the UPPER function to convert all alphabetic characters in a string to uppercase. The input SQL statement and the execution result are shown below.

Mysql > SELECT UPPER ('green'), UPPER (' Green') +-+ | UPPER ('green') | UPPER (' Green') | +-+-+ | GREEN | GREEN | +-+- -+ 1 row in set (0.03 sec)

As can be seen from the results, all alphabetic characters were originally lowercase, converted to uppercase, such as "green", then converted to "GREEN"; strings with mixed uppercase and lowercase letters were converted to uppercase letters, such as "Green", and converted to "GREEN".

Thank you for reading! After reading the above, do you have a general idea of mysql's method of converting strings to uppercase? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.