Re: lvarchar and IUS...
Posted in 1998
Topics: Server Administration, Data Types & Schema Design
In article <6kbt5l$8f3$1@server-b.cs.interbusiness.it>, "Tr@sh" <trebian@newtech.it> writes:
|> A little problem... I have a table with an lvarchar (32k) column. When I
|> insert some data into this this column (in dbaccess, from a form o from a
|> file) is all right. When i try to retrive this column, the data is truncate
|> at 2kbytes about. Somebody have the same problem?
|>
|> I work on IUS 9.13 with Sinix S.O.
Yes me, but imho it's correct!
See: http://www.informix.com/answers/oldsite/answers/pubs/html/dbdk/faq/faq.fm.html#997164
<cite on>
F:What is the maximum size of the LVARCHAR data type?
Q:When an LVARCHAR data type is stored in a database table,
it has a maximum size of 2KB. Attempts to insert more than 2KB
of text into a table are silently truncated to 2KB.
LVARCHAR is also used to pass data to DataBlade routines.
In this context, there is no limit to the size of the LVARCHAR.
<cite off>
MF
----------------------------------------------------------------------
Marcus Flehmig eMail: flehmig@informatik.uni-kl.de
University of Kaiserslautern oder: flehmig@student.uni-kl.de
----------------------------------------------------------------------