Stephane Bortzmeyer wrote:
> On Thu, Nov 27, 2008 at 02:34:17AM +0900,
> Craig Ringer <[EMAIL PROTECTED]> wrote
> a message of 188 lines which said:
>
>>> ERROR: character 0xc3bd of encoding "UTF8" has no equivalent in "WIN1251"
>> Which it does not; that character is "???" (HANGUL SYLLABLE SS
On Thu, Nov 27, 2008 at 02:34:17AM +0900,
Craig Ringer <[EMAIL PROTECTED]> wrote
a message of 188 lines which said:
> > ERROR: character 0xc3bd of encoding "UTF8" has no equivalent in "WIN1251"
>
> Which it does not; that character is "???" (HANGUL SYLLABLE SSYEG)
No, I don't think so. I th
Ronald Vyhmeister wrote:
>
>> 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 WI
"Ronald Vyhmeister" <[EMAIL PROTECTED]> writes:
> The DB is storing it UTF8, but it is really 8859-1... I need to force PG to
> think that it's 8859-1 in spite of what it thinks it may be...
Dump the database, change the "set client_encoding" command in the
resulting file, reload.
> 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?
>If the DB is in
On 26/11/2008 14:40, Ronald Vyhmeister wrote:
> 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 conve
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
