Re: DBD::ADO and TEXT datatypes

From: Amonotod (amonotod_at_charter.net)
Date: 07/28/04 

To: Joaquín Pérez <joaquin.perez@lexisnexis.com.ar>
Date: Wed, 28 Jul 2004 3:12:08 +0000

> From: Joaquín Pérez
> <joaquin.perez@lexisnexis.com.ar>
> Date: 2004/07/27 Tue PM 06:42:57 GMT
>
> I have a table with a TEXT field with a size of 16. Theoretically it
> could hold up to 2 gigs or something like that.
>
> I've done the following:
>
> $dbh->{LongReadLen} = 2 ** 20 + 8;
> $dbh->{LongTrun***} = 1;
> $sth = $dbh->prepare(<insert your query here>);
> $sth->execute()

Have you tried the same thing with a different driver? Say, DBD::ODBC? See
recent previous posts by myself for a DSN-less ODBC connection
string construct (probably stolen from older posts to the list, but as
I said, see some of my recent posts...)...

Also, maybe someone might be able to give detail on using the FreeTDS libs
and DBD::Sybase to make the connection and try the statements...

> Thank you very much!
> j.

amonotod
  

--
    `\|||/         amonotod@    | sun|perl|windows
      (@@)         charter.net  | sysadmin|dba
  ooO_(_)_Ooo____________________________________
  _____|_____|_____|_____|_____|_____|_____|_____|
Quantcast