| From: | Pedro Doria Meunier <pdoria(at)netmadeira(dot)com> |
|---|---|
| To: | Postgresql Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Posgresql to MSsql encoding problem |
| Date: | 2009-10-09 10:39:47 |
| Message-ID: | 4ACF12F3.7080808@netmadeira.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi All,
I have this PHP script that simply dumps (inserts) data from a
Postgresql server to a customer's M$SQL server.
The database in the PGSQL server is UTF-8 encoded where the M$SQL
database uses LATIN1.
Accents, as expected, turn to gibberish... :(
I cannot simply use "Set Client Encoding to LATIN1" as the "client"
itself is the script ... :)
Is there a simple way to circumvent this?
Already thankful for any info,
Best regards,
Pedro Doria Meunier
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
iEYEARECAAYFAkrPEukACgkQ2FH5GXCfxAv9LwCeIsLcr7wwcBTzvXqM/ufYysUK
yQ8AniNYuAjQAEktUt7OCS7lZl4kz92f
=qBrj
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2009-10-09 11:02:13 | Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans |
| Previous Message | Peter Eisentraut | 2009-10-09 10:38:41 | Re: Best data type to use for sales tax percent |