#20852 [Opn->Fbk]: Why Can't insert chinese into MS-ACCESS by COM
| From: | kalowsky@php.net | Date: | Wed, 18 Dec 2002 20:12:58 +0000 |
| Subject: | #20852 [Opn->Fbk]: Why Can't insert chinese into MS-ACCESS by COM | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-27994@lists.php.net to get a copy of this message | ||
ID: 20852
Updated by: kalowsky@php.net
Reported By: pzou@163.com
-Status: Open
+Status: Feedback
Bug Type: COM related
Operating System: win2000
PHP Version: 4.2.2
New Comment:
marking as feedback as per Wez's suggestion
Previous Comments:
------------------------------------------------------------------------
[2002-12-18 14:03:48] wez@php.net
Sounds like a bogus COM problem to me:
Try this:
$conn = new COM("ADODB.Connection", null, $codepage);
where $codepage is the code page number that will be used when
converting strings to unicode.
------------------------------------------------------------------------
[2002-12-18 13:56:31] kalowsky@php.net
COM != ODBC. Re-classifying.
------------------------------------------------------------------------
[2002-12-05 21:42:08] pzou@163.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 this bug report at http://bugs.php.net/?id=20852&edit=1