PHP SQL Chinese garbled

Source: Internet
Author: User
First of all, the IE browser encoding format and database collation are set to "UTF-8". Again, it's okay to follow this print. However, the result is that the display is normal on the Web page, but the information in the inserted database is garbled. As follows.


Reply to discussion (solution)

mysql_query ("Set names UTF8"); Add this sentence before inserting



This is what is printed in the browser, the first image of the first line of Print_r printed out. Coding is also UTF-8. But why is the database a problem? I can't think of ... Seeking the Great God

1. Document Flow: Header ("Content-type:text/html;charset=utf-8");

2. Database: $pdo->query (' SET NAMES UTF8 ');

3.PHP script file: Utf-8 no BOM format.

These three items all do, can not garbled.

  • 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.