Data lengths from a mysql connection

[deleted_user]

Hi

I connect to a mysql database and all my maximum data length is 1024.
can i increase this somehow?
im under the impression that sas can handle 32,000.
i connect using the normal libname statement.

thanks

Spud

[LinusH]

You are probably trying to read a column of the text or blob types in MySQL. In SAS, use the DBMAX_TEXT= option to set the number of chars that you wish see in SAS. The default value is 1024. See:

http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a002914076.htm

and

http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a001371562.htm

/Linus

[deleted_user]

Thats fantastic....cheers