From: | "Ronald Vyhmeister" <rvyhmeister(at)gmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem with langage encoding |
Date: | 2008-11-26 14:40:19 |
Message-ID: | AAE0838E48AD4437908B5FF18F4518EF@peregrino |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've inherited a database system (including source)... It's Russian text
(which I don't speak, but I need to work on it).
On my screen it shows correctly, but in the database it shows a mess...
from trying with a web browser. It appears that the data in the database is
encoded with ISO-8859-1 (my browser and the database viewed with PGAdmin
match when my browser has ISO-8859-1 encoding).... and it shows correctly
on screen in my browser when I use the WIN1251 encoding...
The problem is that the database is UTF8, and it won't let me use the
convert_to function because it says that the characters don't exist... What
I need to do is to pull the UTF8 from the database, tell postgres that it's
8859-1, and then convert it to WIN1251... How?
Thank you for any assistance!
Ron
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2008-11-26 15:06:51 | Re: Problem with langage encoding |
Previous Message | Sam Mason | 2008-11-26 14:18:44 | Re: case when evaluating else condition anyway? |