Prev: UPPER(AES_DECRYPT(...)) bug?
Next: mssql_connect error only on command line
From: "Jon L." on 1 Apr 2008 14:00
(This isn't a solution, per se...just a suggestion.)

I don't know how they compare; I've never personally used the ODBC
functions...

But, you may give the MSSQL functions a try:
http://php.net/mssql

- Jon L.

On Mon, Mar 31, 2008 at 3:27 PM, cfs <charlie(a)strausesoftware.com> wrote:

> I'm using PHP with Apache. PHP code connects to MS SQL server using ODBC.
>
> I'm doing a query against a table that is very simple: one column of the
> real data type, one of the text data type.
>
> The text field is set to "testing 1,2,3". The real column is set to
> 10.0199995.
>
> When I use the default connect options, I get both values back fine.
>
> When I use SQL_CUR_USE_ODBC, which I very much want to use, then the text
> column data comes back as boolean(false).
>
> Does anyone know of a solution?
>
> Table:
>
> CREATE TABLE [dbo].[test1](
> [ID] [int] IDENTITY(1,1) NOT NULL,
>
> [real1] [real] NULL,
>
> [text1] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
>
> CONSTRAINT [PK_test1] PRIMARY KEY CLUSTERED
>
> (
>
> [ID] ASC
>
> )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
>
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
>
> Code:
>
> <?php
> $conn = odbc_connect(db-name, user-name,password, SQL_CUR_USE_ODBC);
> $result = odbc_exec($conn, "select * from test1");
> if (odbc_fetch_row($result)) {
> print "Values: " . odbc_result($result,"real1") . "," .
> odbc_result($result,"text1");
> }
> ?>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
From: "cfs" on 2 Apr 2008 11:49
The mssql driver uses a dll that has a limitation on varchar fields of 255
characters. And the 30 chracter column name limit. And after SQL 2005, may
not be supported at all.

So that alt has been tried, and then adandoned.

""Jon L."" <jonllmsed(a)gmail.com> wrote in message
news:5ad2dbbf0804011100l49d19e97x76f849c2e7119726(a)mail.gmail.com...
> (This isn't a solution, per se...just a suggestion.)
>
> I don't know how they compare; I've never personally used the ODBC
> functions...
>
> But, you may give the MSSQL functions a try:
> http://php.net/mssql
>
> - Jon L.
>
> On Mon, Mar 31, 2008 at 3:27 PM, cfs <charlie(a)strausesoftware.com> wrote:
>
>> I'm using PHP with Apache. PHP code connects to MS SQL server using ODBC.
>>
>> I'm doing a query against a table that is very simple: one column of the
>> real data type, one of the text data type.
>>
>> The text field is set to "testing 1,2,3". The real column is set to
>> 10.0199995.
>>
>> When I use the default connect options, I get both values back fine.
>>
>> When I use SQL_CUR_USE_ODBC, which I very much want to use, then the
>> text
>> column data comes back as boolean(false).
>>
>> Does anyone know of a solution?
>>
>> Table:
>>
>> CREATE TABLE [dbo].[test1](
>> [ID] [int] IDENTITY(1,1) NOT NULL,
>>
>> [real1] [real] NULL,
>>
>> [text1] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
>>
>> CONSTRAINT [PK_test1] PRIMARY KEY CLUSTERED
>>
>> (
>>
>> [ID] ASC
>>
>> )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
>>
>> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
>>
>> Code:
>>
>> <?php
>> $conn = odbc_connect(db-name, user-name,password, SQL_CUR_USE_ODBC);
>> $result = odbc_exec($conn, "select * from test1");
>> if (odbc_fetch_row($result)) {
>> print "Values: " . odbc_result($result,"real1") . "," .
>> odbc_result($result,"text1");
>> }
>> ?>
>>
>>
>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>


 | 
Pages: 1
Prev: UPPER(AES_DECRYPT(...)) bug?
Next: mssql_connect error only on command line