From:             [EMAIL PROTECTED]
Operating system: win2000
PHP version:      4.2.2
PHP Bug Type:     ODBC related
Bug description:  Why Can't insert chinese into MS-ACCESS by COM

Why Can't insert chinese into MS-ACCESS by COM ??
----------------------------------------------------------
Example:

$conn = new COM("ADODB.Connection") or die("ADO connect failed!");

$rs = new COM("ADODB.RecordSet") or die("ADO recordset failedŁĄ");

$conn->open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb"); 

$str="This is a bug!"

$rs = $conn->Execute("insert into [Table_A](Contents)
values('".$str."');"); 
---------------------------------------------------------

When i use COM  insert the variable $str  to column [Contents] of the
[Table_A].
I found it only support insert English.
When $str is a English string it success.
But when $str is a Chinese string it abnormal.
-- 
Edit bug report at http://bugs.php.net/?id=20852&edit=1
-- 
Try a CVS snapshot:         http://bugs.php.net/fix.php?id=20852&r=trysnapshot
Fixed in CVS:               http://bugs.php.net/fix.php?id=20852&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=20852&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=20852&r=needtrace
Try newer version:          http://bugs.php.net/fix.php?id=20852&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=20852&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=20852&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=20852&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=20852&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=20852&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20852&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=20852&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=20852&r=isapi

Reply via email to