Character Limit to CASE Statements?

Mohammad Rehman shared this question 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

The same question

Best Answer

Nathan Schroeder ●

No problem!

Replies (1)

Nathan Schroeder ●

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

Reply URL

Mohammad Rehman ●

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

URL

Nathan Schroeder ●

No problem!

URL

Mohammad Rehman ●

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

Great Help!!!!!

URL

Nathan Schroeder ●

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

URL