Re: Mac OS Roman import?

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>, "pgsql-general(at)postgresql(dot)org mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Mac OS Roman import?
Date: 2009-10-19 22:32:51
Message-ID: C7024533.C6F15%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I find myself needing to regularly import data encoded as Mac OS Roman
> (yes, it is coming from an Macintosh OS 9 system) into a UTF-8
> PostgreSQL database. Any advice on how to do so, since Mac OS Roman
> is (reasonably enough) not one of PG's standard character encodings?

Use iconv; it's a command shipped with OS X, man iconv for more info.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-10-19 22:47:39 Re: Mac OS Roman import?
Previous Message Sam Mason 2009-10-19 22:30:04 Re: Mac OS Roman import?