Cleaning NUL bytes in TEXT column

Posted in 2010

John Hardin — Tue, 16 Feb 2010 14:36:36 -0800 — source: Usenet: comp.databases.informix

All: Something is stuffing NUL bytes into a TEXT column in our database, and this is killing a legacy Kylix application (it segfaults deep in the DBExpress library). Can anybody suggest a quick and simple way to clean NUL bytes out of a TEXT column? TIA -- John Hardin KA7OHZ Senior Applications Developer, BI Specialist EPICOR Retail web: http://www.epicor.com voice: (425) 245-1800 fax: (425) 670-1810 email: <jhardin@epicor.com> 20818 44th Ave. W., Suite 270 Lynnwood, WA 98036 USA Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA ------------------------------------------------------------------------ The first time I saw a bagpipe, I thought the player was torturing an octopus. I was amazed they could scream so loudly. ------------------------------------------------------------------------

↪ replying to John Hardin

Art Kagel — Tue, 16 Feb 2010 17:45:31 -0500 — source: Usenet: comp.databases.informix

Read the data with an ESQL/C program, scrub it and update the row. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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, Feb 16, 2010 at 5:36 PM, John Hardin <jhardin@epicor.com> wrote: > All: > > Something is stuffing NUL bytes into a TEXT column in our database, and > this > is killing a legacy Kylix application (it segfaults deep in the DBExpress > library). > > Can anybody suggest a quick and simple way to clean NUL bytes out of a TEXT > column? > > TIA > > -- > John Hardin KA7OHZ > Senior Applications Developer, BI Specialist > EPICOR Retail > web: http://www.epicor.com > voice: (425) 245-1800 > fax: (425) 670-1810 > email: <jhardin@epicor.com> > 20818 44th Ave. W., Suite 270 > Lynnwood, WA 98036 USA > Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA > ------------------------------------------------------------------------ > The first time I saw a bagpipe, I thought the player was torturing an > octopus. I was amazed they could scream so loudly. > ------------------------------------------------------------------------ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

↪ replying to Art Kagel

John Hardin — Tue, 16 Feb 2010 14:51:37 -0800 — source: Usenet: comp.databases.informix

"Art Kagel" <art.kagel@gmail.com> wrote: > Read the data with an ESQL/C program, scrub it and update the row. Unfortunately we don't have a lot of C+ESQL expertise here. Everything we do is 4GL, Delphi and .NET. I was thinking of suggesting something similar in .NET to the devs but wanted to probe alternatives first. Thanks, Art. -- John Hardin KA7OHZ Senior Applications Developer, BI Specialist EPICOR Retail web: http://www.epicor.com voice: (425) 245-1800 fax: (425) 670-1810 email: <jhardin@epicor.com> 20818 44th Ave. W., Suite 270 Lynnwood, WA 98036 USA Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA ------------------------------------------------------------------------ The first time I saw a bagpipe, I thought the player was torturing an octopus. I was amazed they could scream so loudly. ------------------------------------------------------------------------