MySQL-about varbinary type Chinese data--How to display the problem with PHP!

Source: Internet
Author: User
Tags what php
MySQL database has a field varbinary type, the results of the query is garbled. I do not know what PHP means ——— can make the query out of the Chinese results normal display.

Thank you first.

PS: First question, what is the ill-conceived, but also hope to forgive.

Reply content:

MySQL database has a field varbinary type, the results of the query is garbled. I do not know what PHP means ——— can make the query out of the Chinese results normal display.

Thank you first.

PS: First question, what is the ill-conceived, but also hope to forgive.

In fact, I do not know this Varbinaryz field, check the next is the field into a binary.
So I built a table test, containing the field Test1,test1 field type varbinary, the field is encoded as utf-8.
Insert a piece of data through the SQL statement, test1 to Chinese.
PHP code query, PHP file encoding for Utf-8, browser encoding for Utf-8, Chinese normal display.
It is recommended to use the mysql_query ("SET NAMES UTF8") statement before the query to convert the code to see if it works

  • Related Article

    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.