LATIN2->UTF8 conversation with dblink

From: Ruzsinszky Attila <ruzsinszky(dot)attila(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: LATIN2->UTF8 conversation with dblink
Date: 2009-02-01 11:04:32
Message-ID: f637dd860902010304h6e7ea7ddw5a6e1070eb4872e1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-novice

Hi,

The situation:
We've got two machines. The source database (DB) is running on an RHEL
5.x machine
with PSQL 8.1.11. The destination DB is running on SuSE 11.0 with PSQL 8.3.x.
The mechines are relative far away each other and there is a 2Mbps WAN
line between them.

The DB is the same except the character coding. Source is LATIN2 and
the target DB is UTF8.
We wrote a trigger to copy the data from source to target with dblink.
The problem is the
different DB character coding! PGSQL complains about wrong byte order.
It is trivial.

If the trigger is interesting I can copy here, of course.

What could be the solution? Of course I can't change the default
machine char code, easily.

TIA,
Ruzsi

Ps.: I've got an other question about our trigger making dblink
"permanent" but the char coding
is the most interesting for us.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Grzegorz Jaskiewicz 2009-02-01 11:07:50 Re: Updated backslash consistency patch
Previous Message David Fetter 2009-02-01 10:58:44 Re: Updated backslash consistency patch

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-02-02 18:31:54 Re: [NOVICE] LATIN2->UTF8 conversation with dblink
Previous Message Richard Broersma 2009-02-01 03:58:56 Re: subquery question