Skip site navigation (1) Skip section navigation (2)

Re: Importing data - possible UTF8 import bug?

From: "Mikel Lindsaar" <raasdnil(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Importing data - possible UTF8 import bug?
Date: 2008-07-11 02:56:47
Message-ID: 57a815bf0807101956x1164e095j7433d8e1e1bc5b7e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
> Anyone got any ideas how I can hunt down what is in this row, visually
> looking at it hasn't helped?

As a followup, I am getting this same sort of error at various points
on the file.

So I tried taking the line, and cleaning it with Iconv and turning it
into an ASCII sequence and inserting it back into the file.

I still get the same error with the same invalid character.... too weird.

I have a few lines that fail, all with different invalid character encodings:

0xe92042
0xe42050
0xa2
0xc220
0xdb20
0xe42050
0xe92042

It's at the rate of about one every 50,000 rows... so no real big
deal... but still...

-- 
http://lindsaar.net/
Rails, RSpec and Life blog....

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2008-07-11 03:32:38
Subject: Re: Importing data - possible UTF8 import bug?
Previous:From: Mikel LindsaarDate: 2008-07-11 02:02:01
Subject: Importing data - possible UTF8 import bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group