Perl CGI Scripts - Sybase TEXT
Columns and Queries Troubleshooting
Sybase TEXT columns are omitted from HTML query pages.
Sybase TEXT columns are omitted from the HTML query pages because Sybase
does not support the use of bind variables with TEXT and IMAGE type
columns. Perl CGI scripts created by CGIScripter make use of bind variables
therefore these columns are omitted from each of the query HTML forms.
Solution: It should also be noted that searching through a column containing
up to 2Gb of text could cause performance issues with the database server.
When designing a web form, carefully consider whether more than 255
characters will need to be stored within the database column. Some TEXT
columns could be replaced with VARCHAR(255) columns, which would work-around
this issue. Also consider adding a VARCHAR(255) column for keywords
to your web form for searching purposes.