Rick Gigger wrote:
> I have this exact problem. I have dumped and reloaded other
> databases and set the client encoding to convert them to UTF-8 but I
> have one database with values that still cause it to fail, even if I
> specify that the client encoding is SQL_ASCII. How do I fix that?
Well
Jan Cruz wrote:
> I believe PostgreSQL treat UTF-8 and LATIN9 Differently.
Certainly, considering that they are different encodings.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the p
I believe PostgreSQL treat UTF-8 and LATIN9 Differently.
When I tried to dump a db to a UTF-8 encoding and restore it
with UTF-8 encoding (also) it encountered problems with fields
that have unicoded values thus it stop from restoring the whole dump.
So I tried using LATIN9 encoding for both dump
I have this exact problem. I have dumped and reloaded other
databases and set the client encoding to convert them to UTF-8 but I
have one database with values that still cause it to fail, even if I
specify that the client encoding is SQL_ASCII. How do I fix that?
On Feb 17, 2006, at 4:08
On fös, 2006-02-17 at 22:38 +0100, Peter Eisentraut wrote:
> [EMAIL PROTECTED] wrote:
> > How do I convert a database in the ASCII format into one of the UTF-8
> > format?
>
> ASCII is a subset of UTF-8, so you don't need to do anything. Just
> change the encoding entry in the pg_database table.
[EMAIL PROTECTED] wrote:
> How do I convert a database in the ASCII format into one of the UTF-8
> format?
ASCII is a subset of UTF-8, so you don't need to do anything. Just
change the encoding entry in the pg_database table. Of course, using
pg_dump would be the official way to convert a data
On fös, 2006-02-17 at 05:21 -0800, [EMAIL PROTECTED] wrote:
> Hi All,
>
> I have a database in PostgreSQL which is ASCII.
> Due to some internationalization issues, I need to convert the database
> to the UTF-8 format.
>
> So my question is:
> How do I convert a database in the ASCII format into
Hi All,
I have a database in PostgreSQL which is ASCII.
Due to some internationalization issues, I need to convert the database
to the UTF-8 format.
So my question is:
How do I convert a database in the ASCII format into one of the UTF-8
format?
Thanks in advance
- Kishore
