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