Oninit cdi / Archive
Talk to an expert →

datatype for string

Posted in 2011

Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design, Versions, Editions & End-of-Life

eferreyra — — source: Usenet: comp.databases.informix

Hi, i need to store in a column the text from a exception or log, can be up to 2048 chars probly, im using a TEXT column and works fine from .NET provider (also JDBC, ODBC) but cant get a INSERT from Informix 4gl :( i read that cant be done ? Cant use CHAR because the space it trashes, cant use VARCHAR is too small... I cant make a LOAD statement, and cant use c funtions or external modules... Suggestions ? IDS: IBM Informix Dynamic Server Version 11.50.UC6 4GL: IBM INFORMIX-4GL Version 7.32.UC4

↪ replying to eferreyra
Obnoxio The Clown — — source: Usenet: comp.databases.informix

On 09/08/2011 14:57, eferreyra wrote: > Hi, i need to store in a column the text from a exception or log, can > be up to 2048 chars probly, im using a TEXT column and works fine > from .NET provider (also JDBC, ODBC) but cant get a INSERT from > Informix 4gl :( i read that cant be done ? > > Cant use CHAR because the space it trashes, cant use VARCHAR is too > small... > > I cant make a LOAD statement, and cant use c funtions or external > modules... > > Suggestions ? > > IDS: IBM Informix Dynamic Server Version 11.50.UC6 > 4GL: IBM INFORMIX-4GL Version 7.32.UC4 LVARCHAR(2048)? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish.

↪ replying to eferreyra
Art Kagel — — source: Usenet: comp.databases.informix

Use LVARCHAR it's like VARCHAR but can hold up to a bit under 32K bytes. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Aug 9, 2011 at 9:57 AM, eferreyra <eferreyra@gmail.com> wrote: > Hi, i need to store in a column the text from a exception or log, can > be up to 2048 chars probly, im using a TEXT column and works fine > from .NET provider (also JDBC, ODBC) but cant get a INSERT from > Informix 4gl :( i read that cant be done ? > > Cant use CHAR because the space it trashes, cant use VARCHAR is too > small... > > I cant make a LOAD statement, and cant use c funtions or external > modules... > > Suggestions ? > > IDS: IBM Informix Dynamic Server Version 11.50.UC6 > 4GL: IBM INFORMIX-4GL Version 7.32.UC4 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

Glossary