postgresql - Encoding problems importing -

postgresql - Encoding problems importing -

i having problem importing csv postgres. import using utf8 encoding. returned error:

error: invalid byte sequence encoding "utf8": 0xcc 0xc1 context: re-create a_household , line 2

when open file in notepad++ says @ bottom encoded in utf-8 w/o bom. text displayed - characters appear display correctly.

the hexdump (suggested below) returns

00000060 2d 32 33 2e 39 32 35 38-37 33 39 32 2c 33 32 2e -23.92587392,32. 00000070 37 33 32 31 38 33 30 33-2c 37 35 2e 31 32 32 36 73218303,75.1226 00000080 32 39 33 31 2c 34 2c 31-2c 61 62 6f 76 65 31 79 2931,4,1,above1y 00000090 72 2c 31 37 2c 2c 58 61-6e 67 61 6e 61 2c 56 65 r,17,,xangana,ve 000000a0 6c 68 61 20 61 70 6f 73-74 6f 6c 6f 2c 53 69 6d lha apostolo,sim 000000b0 2c 47 72 69 70 65 20 4d-61 6c cc c1 72 69 61 2c ,gripe mal..ria, 000000c0 50 72 61 74 69 63 61 6e-74 65 5f 64 65 5f 6d 65 praticante_de_me 000000d0 64 69 63 69 6e 61 20 50-72 cc 5f 70 72 69 6f 2c dicina pr._prio, 000000e0 4d 65 64 69 63 61 6d 65-6e 74 6f 73 5f 64 61 5f medicamentos_da_ 000000f0 66 61 72 6d cc c1 63 69-61 2c 36 2c 4e cc a3 6f farm..cia,6,n..o 00000100 2c 2c 31 34 2c 4e cc a3-6f 2c 22 44 65 5f 62 6f ,,14,n..o,"de_bo 00000110 72 6c 61 2c 5f 63 6f 6d-5f 61 75 74 6f 72 69 7a rla,_com_autoriz 00000120 61 cc a4 cc a3 6f 22 2c-2c 2c 35 2c 41 72 65 69 a....o",,,5,arei 00000130 61 20 65 20 65 73 74 61-63 61 73 2c 43 68 61 70 e estacas,chap 00000140 61 73 5f 64 65 5f 5a 69-6e 63 6f 2c 41 72 65 69 as_de_zinco,arei 00000150 61 2c 4c 65 6e 68 61 2c-4e 61 64 61 2c 4c 61 74 a,lenha,nada,lat 00000160 72 69 6e 61 5f 6d 65 6c-68 6f 72 61 64 61 2c 50 rina_melhorada,p 00000170 61 72 61 5f 6d 65 6d 62-72 6f 73 5f 61 67 72 65 ara_membros_agre 00000180 67 61 64 6f 5f 66 61 6d-69 6c 69 61 72 2c 4c 61 gado_familiar,la 00000190 67 6f 61 2f 6c 61 67 6f-2c 50 6f cc a4 6f 5f 70 goa/lago,po..o_p 000001a0 cc bc 62 6c 69 63 6f 5f-61 62 65 72 74 6f 2c 37 ..blico_aberto,7 000001b0 2c 50 cc a9 2c 30 2c 2c-30 2c 2c 4e 75 6e 63 61 ,p..,0,,0,,nunca 000001c0 2c 32 2c 50 6f 72 5f 61-6e 6f 2c 52 61 72 61 6d ,2,por_ano,raram 000001d0 65 6e 74 65 2c 52 61 72-61 6d 65 6e 74 65 2c 4d ente,raramente,m 000001e0 cc c1 2c 32 35 2c 4e cc-a3 6f 2c 54 65 72 72 61 ..,25,n..o,terra 000001f0 5f 70 65 72 74 65 6e 63-65 6e 74 65 5f 61 5f 65 _pertencente_a_e 00000200 73 74 61 5f 61 6c 64 65-69 61 2c 4e 75 6e 63 61 sta_aldeia,nunca 00000210 2c 2c 2c 4d 61 69 73 5f-6f 75 5f 6d 65 6e 6f 73 ,,,mais_ou_menos 00000220 5f 61 5f 6d 65 73 6d 61-2c 4e cc a3 6f 2c 2c 4d _a_mesma,n..o,,m 00000230 61 69 73 5f 66 cc c1 63-69 6c 5f 64 65 5f 6f 62 ais_f..cil_de_ob 00000240 74 65 72 2c 2c 53 69 6d-2c 4e cc a3 6f 2c 2c 2c ter,,sim,n..o,,, 00000250 2c 4e cc a3 6f 2c 53 69-6d 2c 56 61 63 61 73 2c ,n..o,sim,vacas, 00000260 32 20 34 2c 2c 53 69 6d-2c 31 2c 53 69 6d 2c 6a 2 4,,sim,1,sim,j 00000270 61 6e 65 69 72 6f 20 66-65 76 65 72 65 69 72 6f aneiro fevereiro 00000280 20 6d 61 72 cc a4 6f 20-61 62 72 69 6c 20 6d 61 mar..o abril ma 00000290 69 6f 20 6a 75 6e 68 6f-20 6a 75 6c 68 6f 20 61 io junho julho 000002a0 67 6f 73 74 6f 2c 31 30-30 2c 53 61 63 6f 73 2c gosto,100,sacos, 000002b0 30 2c 4d 61 69 73 5f 64-6f 5f 71 75 65 5f 75 6d 0,mais_do_que_um 000002c0 61 5f 76 65 7a 2c 53 61-75 64 65 2c 4e cc a3 6f a_vez,saude,n..o 000002d0 2c 4e cc a3 6f 2c 2c 2d-39 39 38 2c 53 69 6d 2c ,n..o,,-998,sim, 000002e0 4d 75 69 74 6f 5f 73 61-74 69 73 66 65 69 74 6f muito_satisfeito 000002f0 2c 4d 75 69 74 6f 5f 73-61 74 69 73 66 65 69 74 ,muito_satisfeit 00000300 6f 2c 4d 75 69 74 6f 5f-73 61 74 69 73 66 65 69 o,muito_satisfei 00000310 74 6f 2c 49 6e 73 61 74-69 73 66 65 69 74 6f 2c to,insatisfeito, 00000320 22 4e 65 6d 5f 69 6e 73-61 74 69 73 66 65 69 74 "nem_insatisfeit 00000330 6f 2c 5f 6e 65 6d 5f 73-61 74 69 73 66 65 69 74 o,_nem_satisfeit 00000340 6f 22 2c 49 6e 73 61 74-69 73 66 65 69 74 6f 2c o",insatisfeito, 00000350 4d 75 69 74 6f 5f 73 61-74 69 73 66 65 69 74 6f muito_satisfeito 00000360 2c 49 6e 73 61 74 69 73-66 65 69 74 6f 2c 49 6e ,insatisfeito,in 00000370 73 61 74 69 73 66 65 69-74 6f 2c 53 61 74 69 73 satisfeito,satis 00000380 66 65 69 74 6f 2c 53 61-74 69 73 66 65 69 74 6f feito,satisfeito 00000390 2c 4e 61 5f 6d cc a9 64-69 61 2c 4d 65 6c 68 6f ,na_m..dia,melho 000003a0 72 5f 61 67 6f 72 61 2c-22 44 69 66 69 63 69 6c r_agora,"dificil 000003b0 20 64 65 20 64 69 7a 65-72 2c 20 70 6f 69 73 20 de dizer, pois 000003c0 6e 61 6f 20 73 65 69 20-6f 20 71 75 65 20 6f 20 nao sei o que o 000003d0 61 6e 6f 20 6d 65 20 72-65 73 65 72 76 61 22 2c ano me reserva", 000003e0 2c 75 75 69 64 3a 66 63-32 34 66 62 38 39 2d 35 ,uuid:fc24fb89-5 000003f0 34 63 30 2d 34 39 66 34-2d 61 31 36 31 2d 35 64 4c0-49f4-a161-5d 00000400 64 34 63 63 39 62 37 39-65 39 0d 0a d4cc9b79e9..

...

any help much appreciated.

becky

postgresql utf-8