Oninit cdi / Archive
Talk to an expert →

Re: DATA TYPE QUESTION

Posted in 2001

Topics: Server Administration, Data Types & Schema Design

Martin A. Marques — — source: Informix-list mailing list archive (1991-1998)

El Mi' 31 Ene 2001 12:52, Nicholas Anson escribi': > Can someone please tell me what data type I can use that surpasses the 255 > character limit on informix 7.3? TEXT Saludos... :-) -- System Administration: It's a dirty job, but someone told I had to do it. ----------------------------------------------------------------- Mart'n Marqu's email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------

↪ replying to Martin A. Marques
Hal Maner — — source: Informix-list mailing list archive (1991-1998)

The 255 character limit on Informix 7.3 is for VARCHAR, not CHAR. You can store up to 32,767 characters in a CHAR column. Hal Maner M Systems International, Inc. www.msystemsintl.com "Martin A. Marques" <martin@math.unl.edu.ar> wrote in message news:959mk9$c27$1@news.xmission.com... > > El Mi' 31 Ene 2001 12:52, Nicholas Anson escribi': > > Can someone please tell me what data type I can use that surpasses the 255 > > character limit on informix 7.3? > > TEXT > > Saludos... :-) > > -- > System Administration: It's a dirty job, > but someone told I had to do it. > ----------------------------------------------------------------- > Mart'n Marqu's email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > -----------------------------------------------------------------

↪ replying to Hal Maner
Andrew Hamm — — source: Informix-list mailing list archive (1991-1998)

Hal Maner wrote in message <959obd$7al$1@paxfeed.eni.net>... >The 255 character limit on Informix 7.3 is for VARCHAR, not CHAR. You can >store up to 32,767 characters in a CHAR column. > I believe the latest engines support a long varchar type, but I'd have to RTFM - can someone (like the original poster) do that and share it with us?