Introduction to MySQL CONVERT Functions

MySQL CONVERT function is one of our most common MySQL functions. The following describes the syntax and usage of MySQL CONVERT function for your reference.

MySQL CONVERT) provides a way to CONVERT data between different character sets.
Syntax:
CONVERT (expr USING transcoding_name)
In MySQL, the conversion code name is the same as the corresponding Character Set Name.

Example of the MySQL CONVERT function:

Select convert (_ latin1 'müler' USING utf8 );
Insert into utf8table (utf8column)
Select convert (latin1field USING utf8) FROM latin1table;
CONVERT (... USING...) is implemented in accordance with standard SQL specifications.

In traditional SQL mode, if you CONVERT a "0" date string to the date type, CONVERT) function returns NULL. A warning is also generated in MySQL5.1.

The application is as follows:
SELECT * FROM utf8table WHERE name like convert (_ gb23

How to Create MySQL Functions

How to modify MySQL character set in Liunx

Take you to understand mysql Variables

Provides you with an in-depth understanding of MySQL user permissions.

MySQL user permission setting method