I fixed my data, but I did it manually. It seems like there were hidden
characters, which may actually be the 0xc2 (which should not have been there.
The data must have been pasted in somehow, but when I copied the value and
pasted it back in (or ran an update statement, I tried both) the same
Michael,
I have been manually debugging and each symbol is different, though they each
give the same error code. For example, in one it was a pound sign, though when
I did an update and put in the pound sign it worked.
Another time it was the degree symbol.
I'm going to look at iconv as that so
On Mon, Jul 16, 2007 at 04:20:22PM +0300, Sim Zacks wrote:
> My 8.0.1 database is using ISO_8859_8 encoding. When I select specific
> fields I get a warning:
> WARNING: ignoring unconvertible ISO_8859_8 character 0x00c2
Did any of the data originate on Windows? Might the data be in
Windows-1255
My 8.0.1 database is using ISO_8859_8 encoding. When I select specific fields I
get a warning:
WARNING: ignoring unconvertible ISO_8859_8 character 0x00c2
I now want to upgrade my database to 8.2.4 and change the encoding to UTF-8.
When the restore is done, I get the following errors:
pg_restor
