* "Chris Boget" <chris.boget@xxxxxxxx>: > I'm using PEAR::DB to connect to a MS SQL Server 2000. > I'm attempting to run the following query: > > SELECT * FROM myTable FOR XML AUTO, ELEMENTS > > When I run the above query using the Query Analyzer, I get back > the results as expected. However, when I try to run the same query > using PEAR, I get the following error: > > [nativecode=4004 - Unicode data in a Unicode-only collation or > ntext data cannot be sent to clients using DB-Library (such as ISQL) > or ODBC version 3.7 or earlier.] > > and I'm not sure why. I've googled the error and see that alot of > other people are getting the same error (though, it doesn't seem > that they are necessarily using PEAR). From what I can tell, it is > a client error and not a server error. So my questions are 1) is > there something wrong with PEAR and 2) if so, is there a fix in > the works? Does anyone know? But that aside, has anyone else > come up against this issue and found a workaround using PEAR? You should probably post this to php-pear-general, or to the pear-dev list. If no response there, or if no solutions are forthcoming, file a bug report with PEAR::DB. PEAR::DB *is* under active maintainership, from what I can tell, and some of the more recent changes had to do with MS-SQL report, if memory serves. Good luck! -- Matthew Weier O'Phinney Zend Certified Engineer http://weierophinney.net/matthew/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
