0

I got

ERROR: invalid byte sequence for encoding "UTF8": 0xa0"

while dumpimg csv to table, no record was inserted in the table but size of table and database got increased. How does that happen and is there any way to reduce it? Thanks.

Vivek S.
  • 19,945
  • 7
  • 68
  • 85
Arpit Sharma
  • 21
  • 1
  • 2
  • Can you post your sql script or your csv? – SWiggels Sep 25 '15 at 07:50
  • 1
    Have you seen this : -http://stackoverflow.com/questions/4867272/invalid-byte-sequence-for-encoding-utf8 ? – Vivek S. Sep 25 '15 at 08:03
  • What text encoding is in the database in? `SHOW server_encoding;`. What text encoding is the CSV in? You might have to specify the CSV encoding or change `client_encoding`. If it's iso-8859-1 or windows-1252 then 0xa0 is a nonbreaking space. – Craig Ringer Sep 25 '15 at 09:02

0 Answers0