Re: UTF8 characters

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(at)gmx(dot)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
>