Re: informix unloads converting the data

On Dec 19, 10:47 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > Hi, > > This is on ids10.0 and aix5.3 > > We're trying to convert > some data over to another database. When unloading certain fields that > have encrypted data inserted into them ( not informix encryption ), we > noticed that the data is getting converted a bit. > > For instance, an \\F in the character string in the database, comes out as a \\\\F in the unload file. > > The delimiter doesn't matter. It is still putting some extra escape quotes in certain places. > > We can't use the HP load internal format, because the other database wouldn't know what to do with it. > > Are there any ideas as to how to prevent this, or why it happens ? > > Thank you, > > Floyd is the other database informix? If so then the load should convert the \\\\F back to \\F otherwise you may need to write your own output program, or some conversion script on the unloaded file