Bug with ViewPoint 2.20/OnLine 7.20

Posted in 1997

Frido van Orden — Fri, 14 Feb 1997 23:56:13 +0100 — source: Informix-list mailing list archive (1991-1998)

Nasty bug when using ViewPoint Pro 2.20 (shipped with NE) against an OnLine DS 7.20 database: All alter/create table statements involving a CHAR or VARCHAR column are converted to NCHAR/NVARCHAR. This happens both when entering SQL directly and using the table editor. Issuing the same statements using DBAccess on the server results in the expected behaviour. OL 7.20 has NCHAR/NVARCHAR catalog tables, but obviously some miscommunication has happened at Informix leading to this very nasty bug. Only workaround known so far: don't use VPPRO for anything other than normal DML/query statements.