Postgres Pro
Downloads
Home   >   mailing lists

Re: UTF8 characters - Mailing list pgsql-admin

From adey
Subject Re: UTF8 characters
Date
Msg-id 1c66bda80607250327k445186cesa5e36430929a4a22@mail.gmail.com
Whole thread Raw
In response to Re: UTF8 characters  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: UTF8 characters
List pgsql-admin
Tree view
I had the same problem when upgrading v7.4 database to v8, SQL-ASCII to UTF8 - we had to replace single backslashes with double backslashes in the v7 database to get the data to display correctly, then dump and restore in v8 / UTF8. Have we done something wrong please?

On 7/22/06, Peter Eisentraut <peter_e@gmx.net> wrote:
PostgreSQL Admin wrote:
> I had my database set to SQL_ASCII and switched to UTF8, but now I
> notice that I must add a slash for periods/dots ( \. vs . ) to insert
> into varchar.   Is this normal?

No.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

pgsql-admin by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Checking what is the current query running
Next
From: "Dilipkumar"
Date:
Subject: Re: Checking what is the current query running