Character Limit to CASE Statements?

Mohammad Rehman shared this question 2 years ago
Answered

I have not came across any calculated field characters limitation, is anyone who know or point me to the document where it has been explain.

Appreciate your time and help in advance.

Thanks

Mohammad

Best Answer
photo

No problem!

Comments (5)

photo
2

Hi Mohammad,

This will depend slightly on your database, but in a MySQL config, the SQL clause is stored as a MEDIUMTEXT (reportfieldtemplate.SQLClause). Which has a byte limit rather than character limit:

https://stackoverflow.com/questions/13932750/tinytext-text-mediumtext-and-longtext-maximum-storage-sizes

Hopefully this helps!

Regards,

Nathan

photo
1

Nathan, you are always big help. Thanks for your time and help.

Looking at the url, it does not tell me how YellowFin stores the calculated field contents in repository and any size limit?


If in calculated field I start typing 10 pages case statement and at the end of the validation and saving it return error, before doing that wanted to know the size limit in calculated field.


Regards

Mohammad

photo
2

No problem!

photo
1

Got it, repository table name is reportfieldtemplate and column is SQLClause

Great Help!!!!!

photo
2

Yup, happy to help, let me know if you have any problems :)

photo