General Comments, Management Comments, and Additional Topics will be changed from Varchar(4000) to a CLOB field (unlimited) in the June 15th, 2022 release, version 5.12.34. Preliminary testing in our environment and the built-in EOR Dump Reports in Biotics do not throw an error with these changes, but they do cut the characters off at 4,000. However, this should not be an immediate concern as there will not be any fields that contain more than 4,000 characters at this point in time. 

However, you should update any custom Crystal Reports that include the 3 EO fields according to the Update existing Crystal Reports to connect to the Biotics 5 database help topic.  This can be done before or after the release. 

Additionally, any queries used to generate shapefiles/geodatabases that includes these fields, will need to be updated to replace GENERAL_COM in the query with dbms_lob.substr(EO.GENERAL_COM,4000) as GENERAL_COM to convert the data to string format. See the Query Builder help topic for further information.