Received: from copycat.mozcom.com (copycat.mozcom.com [202.47.132.9])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f231i9x07378
	for <pgsql-interfaces@postgresql.org>;
	Fri, 2 Mar 2001 20:44:09 -0500 (EST)
	(envelope-from richip@mozcom.com)
Received: from mozcom.com (zigw4.zicorp.com [207.229.18.254] (may be forged))
	by copycat.mozcom.com (8.11.2/8.11.2) with ESMTP id f231i4H20359
	for <pgsql-interfaces@postgresql.org>;
	Sat, 3 Mar 2001 09:44:05 +0800 (HKT)
Message-ID: <3AA04BB2.5050602@mozcom.com>
Date: Fri, 02 Mar 2001 18:41:06 -0700
From: Richi Plana <richip@mozcom.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 0.8) Gecko/20010215
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: perl5 interface and UTF-8 character encoding
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200103/28
X-Sequence-Number: 1189

Hi,

I have a plaintext file which contains a list of words encoded in UTF-8. 
I plan to use the perl5 interface to read in the list of words and store 
them in PostgreSQL. What should I watch out for when I'm writing my 
script. I'm afraid that perl will read each component/byte of a 
multi-byte character separately and store them as a UTF-8 encoded 
multi-byte character.

Code snippets appreciated.


Yours truly,
Richi Plana