Ah, i didnt realize it would automaticly do that. Very cool. Thanks, Atrix
----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, March 18, 2003 6:14 PM Subject: [RBASE-L] - Re: sql encoding > 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". >
