Minggu, 23 September 2012
PostgreSQL: Invalid byte sequence for encoding UTF8
I have a comma delimited file (.csv) contains stock master data and wanto to import them into PostgreSQL table .During importing, I am facing Invalid byte sequence for encoding "UTF8" error message.
C:\>psql -Umyname -dmydb -p5490
--1. do import
mydb=# \copy myshema.stocks from C:\temp\inv.csv with delimiter as ';'csv
ERROR: Invalid byte sequence for encoding "UTF8": 0xa0
CONTEXT: copy stock, line 26120
--2. check my client encoding
mydb=# show client_encoding;
client_encoding
----------------
UTF8
(1 row)
--3. modify my client encoding
mydb=# \client_encoding LATIN1
--3a. check current client encoding
mydb=# show client_encoding;
client_encoding
----------------
LATIN1
(1 row)
--4. Re do importing
mydb=# \copy myshema.stocks from C:\temp\inv.csv with delimiter as ';'csv
--5. reset client_encoding;
That is it.
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar