How to perform a bulk update of the data length semantics attribute
murph2mSep 21 2012 — edited Sep 26 2012Hi,
We are migrating from a single byte characterset database to a multibyte characterset database (AL32UTF8) and will be setting the forms application server to the new character set and recompiling all the forms (10G). However the majority of items within the forms have a 'Data Length Semantics' property of 'Null' or sometimes 'BYTE' and for items with a 'Data Type' property of 'Char' they need to have the 'Data Length Semantics' property updated to 'CHAR' but this runs into the 1000's of items that potentially need updating. I've tried converting a form to an fmt and searching but no luck. Is there anyway that anyone knows of to bulk update this property for all forms at once?
Also I am not sure of the relevance/impact of updating the 'Data Length Semantics' property for non 'Char' items ie 'Number', 'Date' etc
Any advice much appreciated.
Thanks