Can’t insert Chinese character into MySQL

by

Use UTF-8 when you create table.

create table table_name () CHARACTER SET = utf8;

Use UTF-8 when you insert to table

set username utf8; INSERT INTO table_name (ABC,VAL);

Read More

And More

Detailed Code

Below code is tested code please do the following its works.

If you have already created database please ALTER it as below code.
And if you didn’t created database then create it and set Collation to utf8_unicode_ci

And same for table define Collation as “utf8_unicode_ci” for table fields in which you want to store chines chars.

ALTER DATABASE `stackoverflow` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

CREATE TABLE `stackoverflow`.`chines`
(
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `words` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE = InnoDB;
<?php

    define('HOSTNAME', 'localhost');
    define('USERNAME', 'root');
    define('PASSWORD', '');
    define('DATABASE', 'stackoverflow');

    $dbLink = mysql_connect(HOSTNAME, USERNAME, PASSWORD)or die(mysql_error());
    mysql_query("SET character_set_results=utf8", $dbLink)or die(mysql_error());
    mb_language('uni'); 
    mb_internal_encoding('UTF-8');
    mysql_select_db(DATABASE, $dbLink)or die(mysql_error());
    mysql_query("set names 'utf8'",$dbLink)or die(mysql_error());

    if(isset($_POST['addWord']))
    {
        mysql_query("SET character_set_client=utf8", $dbLink)or die(mysql_error());
        mysql_query("SET character_set_connection=utf8", $dbLink)or die(mysql_error());

        $sql_query = "INSERT INTO chines(words) VALUES('".$_POST['words']."')";
        mysql_query($sql_query, $dbLink)or die(mysql_error());
    }

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
    <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
    <title></title>
</head>
<body>
    <?php
        mysql_query("SET character_set_results=utf8", $dbLink);
        $sql_query = "SELECT * FROM chines";
        $dbResult = mysql_query( $sql_query, $dbLink)or die(mysql_error());

    ?>

    <form action="" method="post">

        <p>Word : <input type="text" name="words" /></p>
        <p><input type="submit" name="addWord" /></p>

    </form>
    <?php
        while($row = mysql_fetch_assoc($dbResult))
        {
            echo $row['words']. '<br />';
        }
    ?>
</body>
</html>

See the result and step visual as below.

enter image description here

More Related Contents:

  1. Is the following code valid? [closed]
  2. strange character encoding of stored data , old script is showing them fine new one doesn’t
  3. The holy grail of cleaning input and output in php?
  4. Convert latin1 characters on a UTF8 table into UTF8
  5. PDO + MySQL and broken UTF-8 encoding
  6. MySQL diacritic insensitive search (spanish accents)
  7. Whats the easiest way to determine if a user is online? (PHP/MYSQL)
  8. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  9. Javascript function post and call php script
  10. UTF-8 safe equivalent of ord or charCodeAt() in PHP
  11. onbeforeprint() and onafterprint() equivalent for non IE browsers
  12. UTF-8 character encoding battles json_encode() [duplicate]
  13. Save Accents in MySQL Database
  14. UTF-8 not working in HTML forms
  15. How is this not passing PHP values to JS and vice-versa?
  16. Php mysql tabs don’t output [closed]
  17. Update Mysql except when field not null
  18. How can I prevent SQL injection in PHP?
  19. jQuery Validate remote method usage to check if username already exists
  20. PDO get the last ID inserted
  21. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  22. How do I import a .sql file in mysql database using PHP?
  23. Pass a JS variable to a PHP variable
  24. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  25. mysql query result in php variable
  26. mysql_real_escape_string is undefined
  27. Unknown database error in PHP but it exists in PHPMyAdmin
  28. How do detect that transaction has already been started?
  29. CakePHP Database connection “Mysql” is missing, or could not be created
  30. How to get primary key of table?

Leave a Comment