Other Characterset to UTF8 - Mailing list pgsql-admin

From Abu Mushayeed
Subject Other Characterset to UTF8
Date
Msg-id BAY108-F292D7506280864454B70A9D1610@phx.gbl
Whole thread Raw
Responses Re: Other Characterset to UTF8  (John DeSoi <desoi@pgedit.com>)
List pgsql-admin
We just upgraded our database from LAIN1 to UTF8 and some of the data
imports were failing due to character set mismatch. So, after reading the
documentation, here is what we are doing. According to the documentation it
says that the database does automatic characterset conversion. So based on
this fact, we are doing the following at the psql prompt:

1. set client_encoding = 'LATIN1';
2. COPY <table_name> FROM '<dir_path/file_name' with NULL as ''

The data gets into the database. The datbase has some inbuilt functions that
translates the data from LATIN1 to UTF8.

The question is it works but is this correct?

Thanks
Abu



pgsql-admin by date:

Previous
From: "Mr. Dan"
Date:
Subject: failing archive command
Next
From: John DeSoi
Date:
Subject: Re: Other Characterset to UTF8