ID: 8361
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: COM related
Description: Chinese char changed & ADODB.command,recordset can not be used
thanks! I use WindowsMe(chinese).
I don't know which platform they used to compile php.
please let me know if you finished. thanks!
steeven
Previous Comments:
---------------------------------------------------------------------------
[2001-02-04 06:34:15] [EMAIL PROTECTED]
which operating system do you use ?
if you're using windows nt/98/95 and the sources where compiled on win2k this could be
the reason. i fix this in the evening.
harald
---------------------------------------------------------------------------
[2001-02-04 00:33:49] [EMAIL PROTECTED]
I donwload 4.05dev from www.mm4.de, and run the following code:
<?php
//phpinfo();
$dbc = new COM("ADODB.Connection");
$dbc->Provider = "sqloledb";
$dbc->Open('DSN=starmate;Database=magway;UID=sa;PWD=');
$q="select title from css";
....
....
?>
Here is the result:
Warning: Error in php_char_to_OLECHAR() in d:apachehtdocsmagwayphorumtest.php on line
4
Warning: Invalid ProgID: Àà×Ö·û´®ÎÞЧ[invalid class string(by me)] in
d:apachehtdocsmagwayphorumtest.php on line 4
Fatal error: Call to undefined function: open() in d:apachehtdocsmagwayphorumtest.php
on line 6
Please tell me what you need to know for more.
---------------------------------------------------------------------------
[2001-02-02 13:07:28] [EMAIL PROTECTED]
could someone with a chinese charset try this please.
---------------------------------------------------------------------------
[2001-01-29 17:17:27] [EMAIL PROTECTED]
this should be fixed in cvs
please try a snapshot from http://snaps.php.net and give me feedback.
---------------------------------------------------------------------------
[2000-12-21 13:52:12] [EMAIL PROTECTED]
I have setup PHP to work with ADO, but they would't work:
$dbc = new COM("ADODB.Connection");
$dbc->Provider = "sqloledb";
$dbc->Open('DSN=starmate;Database=magway;UID=sa;PWD='); //OK
$q="select title from css";
//1. command object
$cm= new COM("ADODB.Command");
$cm->CommandText=$q;
$cm->ActiveConnection=$dbc; //PropPut() failed!!!
$rs=$cm->Execute(); //Invoke() failed!!!
//
//2. recordset still don't work
$rs=new COM("ADODB.Recordset");
$rs->Open($q); //Invoke() failed!!!
//only this code will work
$rs=$dbc->Execute($q);
echo $rs->fields[0]->value . "<br>";
On the other hand, all the Double byte char input/output will be cut to 1byte. ²âÊÔa
will be changed to 3 byte char.
Test with ADODB,Word, It seemed that windows report chinese as one char, but php think
it one byte.
---------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view the rest of the
comments, please view the bug report online.
Full Bug description available at: http://bugs.php.net/?id=8361
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]