pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: lms <piechcio@inetcafe.eu.org>
To: pgsql-sql@postgresql.org
Subject: Re: How convert UNICODE
Date: Sat, 18 Nov 2006 00:00:44 +0100
Message-ID: <20061117225420.M66174@inetcafe.eu.org> (raw)
In-Reply-To: <D7EE51D7-81DF-4E64-9947-3B7A40AA636B@fastmail.fm>
References: <20061117165852.M2045@isb.com.pl>
	<D7EE51D7-81DF-4E64-9947-3B7A40AA636B@fastmail.fm>

Hi

New database must be in SQL_ASCII. In old database (UNICODE) are for example 
2 columns. Rows from first column I must convert to ISO_8859_2 and insert it 
to first column in SQL_ASCII database, and rows from second column I must 
convert to IS0_8859_5 and insert to second column in SQL_ASCII database.

On Fri, 17 Nov 2006 13:17:05 -0800, Drew wrote
> How about pg_dump the data from your old database, then load it into 
>  your new database which is using UTF8?
> 
> Drew





view thread (6+ messages)  latest in thread

Message-ID: <20061117225420.M66174@inetcafe.eu.org>
Permalink:  ../20061117225420.M66174@inetcafe.eu.org/
Also on:    postgresql.org/message-id/20061117225420.M66174@inetcafe.eu.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: piechcio@inetcafe.eu.org
  Subject: Re: How convert UNICODE
  In-Reply-To: <20061117225420.M66174@inetcafe.eu.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox