Friday, 6 September 2013

How to import CSV with Japanese text to PostgreSQL table?

How to import CSV with Japanese text to PostgreSQL table?

I'm beginner in SQL. I would like to import a CSV file with Japanese text
to a PostgreSQL table. I created a table and tried importing the CSV but
this error exit:
ERROR: invalid byte sequence for encoding "UTF8": 0x8c
CONTEXT: COPY tTokyoDir, line 1
********** Error **********
ERROR: invalid byte sequence for encoding "UTF8": 0x8c
SQL state: 22021
Context: COPY tTokyoDir, line 1
Can anyone help?

No comments:

Post a Comment