Data Type Question

Posted in 2001

Topics: Stored Procedures & SPL, Data Types & Schema Design

Nicholas Anson — Tue, 30 Jan 2001 14:21:03 -0500 — source: Informix-list mailing list archive (1991-1998)

Within a stored procedure on Informix 7.3, can someone please tell me what data type I can use to hold an unlimited number of characters. Thanks ___________________________________________________ This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank You. ___________________________________________________

↪ replying to Nicholas Anson

Jonathan Leffler — Tue, 30 Jan 2001 20:59:47 GMT — source: Informix-list mailing list archive (1991-1998)

Nicholas Anson wrote: > Within a stored procedure on Informix 7.3, can someone please tell me what data > type I can use to hold an unlimited number of characters. The universe is finite; there is no way to store an unlimited number of characters in a finite universe. IDS 7.3 is considerably more finite than the universe. The maximum size variable you can manipulate in a stored procedure is CHAR(32767). You can have references to TEXT blobs, but you can't manipulate those. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"