#35183 [Opn]: write into mysql with utf8 not right

[lzx21cn at 21cn dot com]

 ID:               35183
 User updated by:  lzx21cn at 21cn dot com
 Reported By:      lzx21cn at 21cn dot com
 Status:           Open
 Bug Type:         MySQL related
 Operating System: linux debian unstable
 PHP Version:      4.4.0-4
 New Comment:

The problem maybe "Data truncation"  When php write to mysql
but I do not know resolve it


Previous Comments:
------------------------------------------------------------------------

[2005-11-12 02:03:39] lzx21cn at 21cn dot com

do the same without PHP (using the console interface of MySQL in  
gnome-terminal
-----------------------------------------------------------
drop table test1;
create table test1(id int,name char(4));
insert into test1 values(1,'皆大欢喜');
insert into test1 values(2,'四大皆空');
select * from test1;
id | name
1  | 皆大欢喜
2  | 四大皆空
-------------------------------------------
the reslut is good!

-------------------------------------------------
Why do I think it's a problem of PHP, not MySQL

1st. read/write by console vs. by php

by console: the result is right
by php    : the result is wrong,write four Chinese character and read
only one chinese character back,and other character lost.

2nd. read Mysql by java vs. by php (creat record by console)
by java: the result is right
by php : the result is ? at field 'name'
--------------------------------------------------

------------------------------------------------------------------------

[2005-11-11 18:24:31] [EMAIL PROTECTED]

Try to do the same without PHP (using the console interface of MySQL)
and see if it works this way.
If it does, put the code somewhere in the Net and paste the link here,
so the Unicode data won't be corrupted by the bug system.
Also add the expected and actual results, I doubt I can guess them
myself.
And try to explain why do you think it's a problem of PHP, not MySQL or
something else (I'd be glad if you try to use something close to English
to do that).

------------------------------------------------------------------------

[2005-11-11 16:41:04] lzx21cn at 21cn dot com

sorry, 1st comment file is error

This is you need php file (utf8)
----------------------
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
$connect=mysql_connect("localhost","kevin","");

$select=mysql_select_db("kevin",$connect);

$query="insert into test1 values (2,\"四大皆空\");";
$result=mysql_query($query);

$result=mysql_query("select * from test1;");
mysql_close();
?>

------------------------------------------------------------------------

[2005-11-11 16:34:31] lzx21cn at 21cn dot com

you need php file (utf8)
----------------------
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
$connect=mysql_connect("localhost","kevin","");

$select=mysql_select_db("kevin",$connect);

$query="insert into test1 values (2,\"四大皆空\");";
$result=mysql_query($query);

$result=mysql_query("select * from test1;");
$rows=mysql_num_rows($result);
for ($i=0;$i<$rows;$i++)
{
    
   $a=mysql_fetch_array($result);
   echo "第一个字段是：".$a[0]." | ";
   echo "第二个字段是：".$a[1]."<br>";
}
mysql_close();
?>

------------------------------------------------------------------------

[2005-11-10 17:24:09] [EMAIL PROTECTED]

Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc.

If possible, make the script source available online and provide
an URL to it here. Try to avoid embedding huge scripts into the report.



------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/35183

-- 
Edit this bug report at http://bugs.php.net/?id=35183&edit=1