Hash variables w/ special charcters in zzsys_variable table
Posted: Wed Aug 15, 2012 6:56 am
I am creating a report using hash variables to build the #dataTable# for the report.
Everything works fine except for one thing. When the value of a hash variable contains special characters (e.g. #country# = 'México' ) the value of the hash variable is truncated when stored in the zzsys_variable table. This is, instead of 'México', it only appears 'M' (maybe because the character: é is not recognized somewhere).
I am able to change the value and store it correctly using PHPMYADMIN, and there are other values in this table with special characters stored correctly. Only when using hash variables to pass the values from the edit form to the report procedure, is when i get the values truncated.
Is there something I can change to avoid this?
Thanks for your help.
Regards,
Fike
Everything works fine except for one thing. When the value of a hash variable contains special characters (e.g. #country# = 'México' ) the value of the hash variable is truncated when stored in the zzsys_variable table. This is, instead of 'México', it only appears 'M' (maybe because the character: é is not recognized somewhere).
I am able to change the value and store it correctly using PHPMYADMIN, and there are other values in this table with special characters stored correctly. Only when using hash variables to pass the values from the edit form to the report procedure, is when i get the values truncated.
Is there something I can change to avoid this?
Thanks for your help.
Regards,
Fike