FreeTDS Development Group

["James K. Lowden" <jklowden AT speakeasy.org>]

Mrrph?  Am I missing something?  Is this *supposed* to work?

A dblib programmer has to use dbreadtext & Co. to read text fields.  Is the 
server
converting the text field to varchar(255) implicitly before the (I assume) 
ODBC driver
ever sees it?  Or is the ODBC driver expected to do some fancy footwork to 
make text
fields act like normal data types?

My users, you see, had to keep it short.  No silly-ass text fields for them, 
no sir.
Nothing by God-fearing varchars.  Keep it short or don't say it at all, that 
was my
motto.  Or else.

Ahem.

--jkl


>  On Tue, 14 Nov 2000, Brug, Herco van -Syntegra NL wrote:
>
>  > well my access tells me the proj_toel and proj_antwoord fields are or 
> type
>  > memo

(earlier...)

> this is part of the code i use
>   $id=mssql_connect("Support", "username", "");
>   $db=mssql_select_db("Support");
>   $r1=mssql_query("Select dbo.SUPPORTPROJECT.Proj_toel,
>     dbo.SUPPORTPROJECT.Proj_antwoord FROM dbo.SUPPORTPROJECT
>     Where (Proj_nr=$pn)",$id);
>