SHIFT_JIS_2004 is different to SJIS.
But when I use SJIS, I occur the same problem,
so I try SHIFT_JIS_2004.
=> set client_encoding='SJIS';
SET
=> select * from tablexx;
ERROR: character 0xc2a0 of encoding "UTF8" has no equivalent in "SJIS"
too confused...
Thanks
2008/2/13, Tatsuo Ishii <[EM
Hi
By use # \l ,the 7.4.3 version database show
List of databases
Name| Owner | Encoding
---+--+---
testdbxx | userxxx | UNICODE
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(3 rows)
I think [some character codes may not have a c
>
> - Original Message -
> From: "Hiroshi Saito" <[EMAIL PROTECTED]>
>
>
> > Hi.
> >
> > - Original Message -
> > From: "bh yuan" <[EMAIL PROTECTED]>
> >
> >
> >> Thanks for your replay.
&
xport a UTF-8 encoding csv file?
Thanks
2008/2/8, Hiroshi Saito <[EMAIL PROTECTED]>:
> Ooops, shortage of information..sorry.
> Please see,
> http://winpg.jp/~saito/pg83/HASHIGODATA/
>
> > Hi.
> >
> > - Original Message -
> > From: "bh yua
hi
I used Postgresql7.4.3 with php for more than 3years.
Now I want to change my database to Postgresql8.3.
But I occur such problem
--
ERROR: character 0xe9ab99 of encoding "UTF8" has no equivalent in "SJIS"
ERROR: character 0xe9ab99 of enco
hi
I use Postgresql 7.4.19 wiht 8G memory on Redhat5 x86_64.
And I modify the postgresql.conf file,
when I set
shared_buffers = 786432# min 16, at least
max_connections*2, 8KB each
(6G)
and import data.
[ PANIC: hash table "Shared Buffer Lookup Table" corrupted ]
occur.
I set the
