CLIPPED on vars like nchar columns does'nt work?

Posted in 2004

Włodek — 20 Dec 2004 13:48:31 -0800 — source: Usenet: comp.databases.informix

Clipped on variables like nchar columns in RDS 7.32.UC2 SCO seems to not work. database xxx main defina v like systables.tabname let v= "x" display ">", v clipped, "<" end main Output: >x < Regards, W.

↪ replying to Włodek

Jonathan Leffler — Tue, 21 Dec 2004 06:40:46 GMT — source: Usenet: comp.databases.informix

Włodek wrote: > Clipped on variables like nchar columns in > RDS 7.32.UC2 SCO seems to not work. > > database xxx > main > defina > v like systables.tabname > > let v= "x" > display ">", v clipped, "<" > > end main > > Output: > >>x < systables.tabname is not an NCHAR column. It might well be a VARCHAR(128,18) for a variety of ancient reasons, in which case, the data is blank padded to 18 characters. However, none of that explains why CLIPPED isn't working - just why the unclipped value might have 17 trailing blanks. Contact IBM Informix Tech Support. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/