Some personal experiences about MySQL Coding

Source: Internet
Author: User
The descriptions below have no theoretical basis and are purely personal experiences. MySQL uses version 4.1 or later, and uses the default for whatever character set it is. You do not need to set MySQL. Then, let's take a look

The descriptions below have no theoretical basis and are purely personal experiences. MySQL uses version 4.1 or later, and uses the default for whatever character set it is. You do not need to set MySQL. Then, let's take a look

The descriptions below have no theoretical basis and are purely personal experiences.

MySQL uses version 4.1 or later, and uses the default for whatever character set it is. You do not need to set MySQL.

Then an example of using GB2312 and UTF-8 is given.

Well, you only need to ensure that the PHP file that you write the insert SQL statement is encoded as GB2312. Congratulations, the data you read from the PHP file that reads the GB2312 code of the select SQL statement is also GB2312.

Similarly, as long as you insert the PHP file into the database is UTF-8 encoding, then you enter the UTF-8, read out also use encoding for UTF-8 read.

What if I enter it as GB2312 and show that I want to use UTF-8?

If all your php files are UTF-8 encoded, then you must use iconv for encoding conversion during INSERT, convert str into GB2312 library, read the same, use iconv to convert UTF-8 display.

What encoding is used on your front-end page, so your strings have already been encoded in this way. So, even if they are stored in the database, their machine code must be like that, no matter where they are stored, no matter what encoding MYSQL specifies, it does not convert your data when entering data. As long as you ensure that your front-end entry uses a UTF-8, then you also read the UTF-8.

Why is there always a problem with using PHPMYADMIN for import?

I have not studied the working principle of PHPMYADMIN, but his PHP files are UTF-8 encoding, that is, the imported data is UTF-8, you use the PHP file GB2312 to read, of course, a pile of chaos.

I guess there are three solutions:

When reading data, use the set name to convert its encoding. I don't know if it is feasible,

After reading the data, use iconv to convert it to GB2312,

You do not need to use PHPMYADMIN to import data. Just write a PHP script for GB2312 to import the data.

In a word, what encoding is used when you input the data? What encoding is used when you read the data. If you want to display this encoding as another encoding type, you need to use iconv or mbstring for encoding conversion.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.