Maximum number of Chracters in RTF Area

Classic Servoy
1

Hi All,

I have text field of length 999999999. When I am setting the display type of the field to RTF Area, it will only be able to take 10,000 characters at max. But, when I am changing to Text Area it will be able to take 80,000+ characters. I know the RTF area stores the font and color information along with the text, but willing to know can I be able to increase the 10,000 limit in the RTF area. I am using MySQL Database.

Thanks,

2

Hi Infop,

You say you can’t add more characters ? You get some error message or doesn’t the field allow you to type more?
If it’s an error message do you get that from Servoy (see logs/admin pages) or do you also see that in the MySQL log?

3

Hi Robert,

Thanks for your quick response.

The RTF Field allows me to type more. No Problem at all. But, when I am navigating to other record and again come back to that record then the field contents is vanished, not showing any data. But, the MY SQL Query browser showing the data. But, the Servoy’s RTF Field does not showing the data. It is not giving any error message. Not anything in Servoy or MySql Log.

Thanks,

4

Hi Infop,

So it does store your text over the 10K limit but it doesn’t read it back.
When you add another field on the form with the same dataprovider but using the display type TEXT_AREA see if it does load all the data into that. If it does then it’s a Servoy RTF issue and you can file a case for that.

Hope this helps.

5

ROCLASI:
If it does then it’s a Servoy RTF issue and you can file a case for that.

Yes, the issue is only related to RTF-AREA only. The TEXT-AREA showing the data correctly. The Issue is also reproducible in Sybase ASA Database. I have created a case for this in the Servoy support system.

Thanks.

6

Hi Infop,

For people finding this thread it might be good to mention in what Servoy version this happend.

7

ROCLASI:
For people finding this thread it might be good to mention in what Servoy version this happend.

Yes, of course Robert.

Issue reproduced in

Servoy Version : Servoy Version: 4.1.0 - build 651
Database : MySQL 5.0.22 and Sybase ASA 10.0.1.3415

Thanks,

8

This bug will be fixed in next release.