PCOOO
November 25th, 2009, 09:18 AM
Hello,
I'm trying to display an entire large textfile stored in MySql as a BLOB field with the following code:
SELECT `content1`.`id`, convert(`content1`.`data`, binary(10000000))
FROM `content` `content1`
WHERE `content1`.`id` = 100
It works in MySql but CrystalReports only shows the first x characters (about 100000).
Is there some kind of maximum length that CrystalReports can handle?
How can I fix this?
Thanks in advance!
I'm trying to display an entire large textfile stored in MySql as a BLOB field with the following code:
SELECT `content1`.`id`, convert(`content1`.`data`, binary(10000000))
FROM `content` `content1`
WHERE `content1`.`id` = 100
It works in MySql but CrystalReports only shows the first x characters (about 100000).
Is there some kind of maximum length that CrystalReports can handle?
How can I fix this?
Thanks in advance!