Re: How convert UNICODE

HelloThanks for help. Iconv is good. Now I use iconv function with libpq.

On Sun, 19 Nov 2006 10:15:53 -0500, Travis Whitton wrote 
> Assuming you're on a Unix based platform: 
> 
> psql> COPY tablename (column1) TO 'column1.csv' WITH CSV; 
> 
> bash> iconv -f UTF-8 -t iso8859_2 column1.csv > iconv-column1.csv 
> 
> psql> COPY tablename (column2) TO ' column2.csv' WITH CSV; 
> 
> bash> iconv -f UTF-8 -t iso8859_5 column2.csv > iconv-column2.csv 
> 
> repeat for each column... 
> 
> bash> paste iconv-column* > newtable.csv