I have a ms sql varchar column that displays embedded html with text correctly in my test environment which is the Scriptcase installation for windows development. However when I deploy the app to a Red Hat server, the field displays unprintable characters. Any suggestions? Thanks.
Update, this appears to be a problem with the ms sql database field being varchar (MAX). Created a new field varchar(MAX), same problem. Changed field to varchar(4000), and it works like it should. Still a problem, have over 6,000 records with length > 4,000. But at least I understand it better.
Fixed. Had to add “VarMaxAsLong = Yes” in odbc.ini.