NYCPHP Meetup

NYPHP.org

[nycphp-talk] MSSQL, PDO & Unicode

David Hauenstein davehauenstein at gmail.com
Wed Jun 4 14:59:13 EDT 2008


Justin,

FreeTDS is a library that allows Linux to talk to mssql. Ben needs this 
to work on a production Windows environment, so FreeTDS has nothing to 
do with the solution.

-Dave

Justin Dearing wrote:
> 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
>>
>>     
> _______________________________________________
> 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
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20080604/32460189/attachment.html>


More information about the talk mailing list