| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Dino Nardini <dino(at)rivendellsoftware(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg jdbc driver |
| Date: | 2004-08-09 16:53:23 |
| Message-ID: | Pine.BSO.4.56.0408091149080.22004@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brigitte ROLLAND | 2004-08-09 17:03:03 | Problems with MS Visual Basic 6.0 |
| Previous Message | Robert Fitzpatrick | 2004-08-09 16:36:57 | DELETE and UPDATE in same function with foriegn keys |