Skip site navigation (1) Skip section navigation (2)

Re: Charset conversion error

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: fireworker(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Charset conversion error
Date: 2006-05-30 08:26:53
Message-ID: 20060530.172653.106039287.t-ishii@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-general
As far as I know the conversion table was not changed. Are you saying
that Win-1251 0xb9 is converted to a non-space-char in the previous
version?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Previous version converted such characters all right. And there wasn't any
> bogus ASCII spaces. But I looked at the KOI8 charset table and found out
> that there is not equivalent symbol (0xb9) in this table.
> 
> 2006/5/30, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>:
> >
> > > I think you are right. But everything was alright before I updated my
> > > database.
> >
> > Previous version converted such characters to ASCII spaces. So
> > probably you have lots of bogus spaces anyway. If you think it's ok,
> > then you could your own CONVERSION which behaves similar to previous
> > version.
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> >
> > > So there are a lot of "incorrect" values in tables. And errors appear
> > when I
> > > execute "SELECT * FROM table".
> > >
> > > 2006/5/30, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>:
> > > >
> > > > > Hi, I have an error after updating my database up to 8.1.4 version.
> > > > > "SQL Error: ERROR:  character 0xb9 of encoding "WIN1251" has no
> > > > equivalent
> > > > > in "MULE_INTERNAL"'. "
> > > > > My client program encoding is windows-1251 and database encoding is
> > > > koi8.
> > > > > What can I do to rectify the situation?
> > > >
> > > > It suggests that Windows-1251's 0xb9 cannot be converted to KOI8. You
> > > > should check your Windows-1251 data.
> > > > --
> > > > Tatsuo Ishii
> > > > SRA OSS, Inc. Japan
> > > >
> > >
> > >
> > >
> > > --
> > > Verba volent, scripta manent
> > > Dan Black
> >
> 
> 
> 
> -- 
> Verba volent, scripta manent
> Dan Black

In response to

Responses

pgsql-general by date

Next:From: Roman NeuhauserDate: 2006-05-30 08:51:41
Subject: Re: DB structure for logically similar objects in different
Previous:From: Nis JorgensenDate: 2006-05-30 07:08:12
Subject: Re: List of countries (WAS: National Number to text conversion)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group