Atrix, Do you mean when you are NOT using Witango? Then the UNLOAD command does what you need: it doubles the quotation character when a literal quotation character is needed.
One way to do this is to create a view, or even a temporary view of the data you want to dump into the file, then use: OUTPUT filename UNLOAD DATA FOR viewname AS ASCII OUTPUT SCREEN On Tue, 18 Mar 2003 18:14:50 -0800, Atrix Wolfe wrote: >in witango i know theres a way to encode strings for use in sql (ie, changing a ' into '' so it can be used within an insert). Im dumping some data from a table into a file and then loading it into another database. I was wondering if it was possible to do this same "sql encoding"? I'm trying too read the data back into the other database but wherever theres a ' within the data it assumes thats the end of the string so i get lots of warnings saying "excess data values ignored".
