Re: Re: ODBTP, a possible solution for MS-SQL and other
| From: | Robert Twitty | Date: | Tue, 22 Apr 2003 15:02:56 +0000 |
| Subject: | Re: Re: ODBTP, a possible solution for MS-SQL and other | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27258@lists.php.net to get a copy of this message | ||
This is true, but the ODBTP extension provides better support for ODBC
than the one included with PHP. Unless I am doing something wrong, I have
the following issues with this extension:
- nvarchar and ntext data is converted to single byte characcter, which
means that only US-ASCII characters will be properly converted.
- Cannot process prepared statements like {? = call AddName(?,?)}
- odbc_fetch_array does not work, and unless no one is reading the user
comments on the PHP Manual, it has been noted.
- NULL data is returned as empty strings.
- datatime data can only be read and sent in character format.
Also, I needed a solution that would work exactly the same on both Win32
and UNIX platforms when connecting to MSSQL.
-- bob
On Tue, 22 Apr 2003, Manuel Lemos wrote:
> Hello,
>
> On 04/22/2003 10:39 AM, Robert Twitty wrote:
> > I am not sure if this would work on a Win32 installation of PHP, where the
> > odbc extension is not optional. And, if I used the odbc_ prefix, would
> > this cause a conflict?
>
> OTOH, you do not need this extension under Windows because you can use
> the real ODBC drivers. It is exactly the same with ODBC interface with
> IBM DB2, SAP DB, etc... So, that is not a real problem.
>