Re^4: DBI::Sybase -retrieving BLOB values from ms-sql question

i've just found this online

String Data Handling   (from http://search.cpan.org/~mewp/DBD-Sybase/d
+bd-sybase.pod)

DBD::Sybase supports CHAR/VARCHAR/BINARY/VARBINARY, limited to 255 cha
+racters in length up to version 12.0x. As of 12.5 these datatypes can
+ be up to 16K in size - but supporting the larger sizes requires that
+ Open Client 12.5 or later be used. Note that the CHAR type is fixed 
+length (blank padded).

Sybase automatically converts CHAR and VARCHAR data between the charac
+ter set of the server (see the syscharset system table) and the chara
+cter set of the client, defined by the locale setting of the client. 
+The BINARY and VARBINARY types are not converted. UTF-8 is supported.

See the OpenClient International Developer's Guide in the Sybase OpenC
+lient manuals for more on character set issues.
Strings can be concatenated using the + SQL operator.
[download]

it sort of implies that the limitation is stuck at fetching a max of 255 character per blob. Am I wrong(i hope so)?

Edit: pre tags replaced with code tags

Comment on Re^4: DBI::Sybase -retrieving BLOB values from ms-sql question Download Code

Replies are listed 'Best First'.
Re^5: DBI::Sybase -retrieving BLOB values from ms-sql question by mpeppler (Vicar) on Jul 08, 2006 at 06:01 UTC
The limitation that is referred to here is for char/varchar data, not for blobs. DBD::Sybase has always supported the full blob size (2GB) either via the longReadLen attribute, or via the "set textsize" T-SQL command. Also note that the documentation that you are referring to is primarily aimed at DBD::Sybase built with the Sybase OpenClient libraries. You are using it with FreeTDS, which means that some of the behavior is different, and you should refer to the FreeTDS documentation for additional information. Michael	[reply]

Replies are listed 'Best First'.

Re^5: DBI::Sybase -retrieving BLOB values from ms-sql question
by mpeppler (Vicar) on Jul 08, 2006 at 06:01 UTC

Also note that the documentation that you are referring to is primarily aimed at DBD::Sybase built with the Sybase OpenClient libraries. You are using it with FreeTDS, which means that some of the behavior is different, and you should refer to the FreeTDS documentation for additional information.

Michael

[reply]