Re: PHP 4.0 Bug #8361 Updated: Chinese char changed & ADODB.command,recordset can not be used

I am getting the same error: Error in php_char_to_OLECHAR() in ... when I try to instantiate a COM connection. My settings: PHP4.05 from www.php4win.de I believe the CVS source on January 30th Apache 1.3.9 Win98 Alain phanto@php.net wrote: > > ID: 8361 > Updated by: phanto > Reported By: steeven@kali.com.cn > Status: Open > Bug Type: COM related > Assigned To: phanto > Comments: > > 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 > > Previous Comments: > --------------------------------------------------------------------------- > > [2001-02-04 00:33:49] steeven@kali.com.cn > 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] phanto@php.net > could someone with a chinese charset try this please. > > --------------------------------------------------------------------------- > > [2001-01-29 17:17:27] phanto@php.net > 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] steeven@kali.com.cn > 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. > > --------------------------------------------------------------------------- > > ATTENTION! Do NOT reply to this email! > To reply, use the web interface found at > http://bugs.php.net/?id=8361&edit=2 > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net