On Mon, 9 Aug 2004, Dino Nardini wrote:
> Hello there, > > Is there no way to force the JDBC driver to simply pass the data as > SQL-ASCII, or ignore the encoding altogether? No because Java itself needs it correctly encoded the JDBC driver needs to make that happen. > I tried to dump and restore the database with UNICODE encoding but get > errors on restore because there is quotes/double quotes within some of the > text data. Is there an encoding that will handle both french language > characters and quotes/double quotes? > I've seen this problem with Microsoft "smart" quotes that are angled, but there should be no problem with plain ' and ". When doing the dump / restore you may need to actually convert the data from whatever encoding you were using with something like iconv. If you are just struggling with the quotes perhaps a simple search and replace would be fine. Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster