|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-11-10 17:39 UTC] tony2001@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 18:00:01 2025 UTC |
Description: ------------ In MySQL 4.1.7 version, any text in table with charset type UTF-8, are not correctly inserted by mysqli_fetch_row function. UTF-8 text is inserted into tables correctly. When looking in some mysql management tool (like MySQL Control Center or MySQL Query Browser or command line mysql) all text are displayed incorrectly. Executed in commandline INSERT command correctly inserts utf-8 characters. Reproduce code: --------------- <?php $link = mysqli_connect('localhost', 'root', 'root', 'test'); mysqli_query($link, "CREATE TABLE utf8_test(a CHAR(100)) CHARACTER SET 'utf8'"); $text = '─?┼Ī┼?'; // any text non-ASCII text (in UTF-8) mysqli_query($link, "INSERT INTO utf8_test VALUES ('$text')"); $res = mysqli_query($link, "SELECT * FROM utf8_test"); list($new_text) = mysqli_fetch_row($res); mysqli_free_result($res); mysqli_close($link); echo ($text == $new_text ? "TRUE" : "FALSE"); ?> Expected result: ---------------- TRUE Actual result: -------------- FALSE