Re: in need of help

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