NYCPHP Meetup

NYPHP.org

[nycphp-talk] MSSQL, PDO & Unicode

Justin Dearing zippy1981 at gmail.com
Wed Jun 4 14:55:34 EDT 2008


Ben,

Ah I see. The send framework has a wrapper around that you are using,
and the ODBC support is not fully functional. At least that's what I
gather from Jira:
http://framework.zend.com/issues/browse/ZF-905

That being said, since the mssql PDO driver uses FreeTDS, I'd spend
some time researching the ability to use xml columns with freetds as
everything rides on that.



On Wed, Jun 4, 2008 at 2:08 PM, Ben Sgro <ben at projectskyline.com> wrote:
> Hello Justin,
>
> A few weeks ago I build the driver for linux and got it working.
>
> My problems are w/the pdo driver it self, not being able to work correctly.
> Also that and Zend doesn't have a SQLSERVER driver (besides pdo).
>
> - Ben
>
> Justin Dearing wrote:
>>
>> On Wed, Jun 4, 2008 at 1:20 PM, Ben Sgro <ben at projectskyline.com> wrote:
>>
>>>
>>> The problem does not go away on Windows:
>>>
>>> SQLSTATE[HY000]: General error: 10007 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. [10007] (severity 5) [(null)]
>>>
>>
>> Did you try the PDO odbc driver. also do you have the latest mssql
>> server driver.
>>
>> Or you can also try:
>> http://pecl.php.net/package/PDO_DBLIB. That might have a newer FreeTDS
>> lib.
>>
>> Really though find out what the latest FreeTDS can handle before
>> trying any non odbc driver for sql server on php. After all, any open
>> source mssql server interface is probably based on freetds.
>> _______________________________________________
>> New York PHP Community Talk Mailing List
>> http://lists.nyphp.org/mailman/listinfo/talk
>>
>> NYPHPCon 2006 Presentations Online
>> http://www.nyphpcon.com
>>
>> Show Your Participation in New York PHP
>> http://www.nyphp.org/show_participation.php
>>
>>
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>



More information about the talk mailing list