On Tue, Jul 13, 1999 at 03:04:36PM -0600, aaz@leopard.com wrote:
> Hi all,
> New to informix and am porting an app that talked to MySql to Informix.
> Anyways I am in need of columns that can store more than 255 characters. In
> mySql this is a text datatype. It appears informix has it as well however
> its a binary datatype hence doing inserts with text between " simply is not
> working.
>
> 2 things:
> 1. If I want to store form submissions that have more that 255 characters
> how do I do it (what datatype)
If your submission is less than 32K - use CHAR.
If you need more you have three options:
- use more columns of type CHAR
- use more records each containing a portion of CHAR
- use a TEXT column
In the latter case you can't insert the data by putting it between quotas.
It depends what language you use.
>
> 2. Are there any informix sql functions for converting things to the text
> datatype to and from?
>
Don't remember one. But I didn't use this datatype very often so it could
be one (I have doubts about this). Anyway you can save the data from a
text column into a file or retrieve it in memory.
Best Regards,
Octav
--
Octav Chiriac Phone: (373) 2 22 99 67
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 24 00 83
Moldova, Republic of mailto:com@netinfo-moldova.com