RE: Best data type to store XML data

Posted in 2004

Colin Bull — Thu, 18 Nov 2004 11:32:17 -0000 — source: Usenet: comp.databases.informix

Ken Hu asked > > > I've a lot of xml datas need to stored in informix database. > I'm wonderring which data type is the best shot for this kind of data. > > varchar ? char ? or text ? If you are not going to do anything with the data, I would suggest zipping it and storing in a blob field. Colin Bull _______________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. _______________________________________________________________________ sending to informix-list