[PEAR-BUG] Bug #17692 [Opn]: character corruption

On Sat, Aug 14, 2010 at 4:06 PM, wrote:
Edit report at http://pear.php.net/bugs/bug.php?id=17692&edit=1

ID:               17692
Updated by:       [email protected]
Reported By:      acego2006 at gmail dot com
Summary:          character corruption
-Status:           Open
+Status:           Bogus
Type:             Bug
Package:          HTTP_Session2
Operating System: centos5.5
Package Version:  0.7.3
PHP Version:      5.2.10
Roadmap Versions:
New Comment:

-Status: Open
+Status: Bogus
Glad you got it working


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

[2010-08-13 03:25:03] acego2k

maybe  this issue was solved.
i change order about require dbconnection script.

look like working good.

---execute this first in dbcon script---
"SET NAMES 'utf8' COLLATE 'utf8_unicode_ci"

[0.7.3]
require_once 'dbcon.php';
require_once 'session_start';
[0.7.2]
require_once 'session_start';
require_once 'dbcon.php';

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

[2010-08-11 12:17:35] bate

so lets check the diff :)

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

[2010-08-11 12:16:37] acego2k

hi.
but when i use version 0.7.2 is no problem.

mysql,httpd,os other things is all same.

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

[2010-08-11 12:06:04] bate

I think you should convert your character to non unicode stuff to get
this working, maybe you database connection is too not unicode
compatible

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

[2010-08-11 12:03:23] acego2k

Description:
------------
hi,i using this library with japanese environment.

i have a problem.

i set session variable  was no problem, but
a problem occurred when use updateIdle function .
the characters will be null.

Test script:
---------------
HTTP_Session2::set("strins","japanese character");

HTTP_Session2::updateIdle();


//sql query

INSERT INTO sessiondata (id, expiry, data) VALUES ('************',
000000000,
'__HTTP_Session2_Info|i:1;__HTTP_Session2_Expire|i:86400;__HTTP_Session2_Expire_TS|i:00000000;__HTTP_Session2_Idle|i:1800;__HTTP_Session2_Idle_TS|i:0000000000000;strings|s:6:\"japanese\";')
UPDATE sessiondata SET expiry = 000000000, data =
'__HTTP_Session2_Info|i:2;__HTTP_Session2_Expire|i:86400;__HTTP_Session2_Expire_TS|i:00000000;__HTTP_Session2_Idle|i:1800;__HTTP_Session2_Idle_TS|i:00000000;strings|N;'
WHERE id = '***********' AND expiry >= 0000000000000

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


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