> Thanks for your reply.
> I think ther are no error in 7.4.3 but warning.
That means the character in question was ignored in 7.4, i.e. the
character was skipped. I'm not sure that's actually what you want.
> I used the old version 7.4.3 postgresql for 3 years with
> UTF-8 encoding web base fron
I don't see any strange thing.
There has been no mapping from UTF-8 0xc2a0 to SJIS in PostgreSQL
since the day one. That means, you should get the error on 7.4.3, as
well as on 8.3. Are you sure that you don't have the error on 7.4.3?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> SHIFT_JIS_2004 is diffe
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
>
> 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
> 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
bh yuan escribió:
> I think [some character codes may not have a conversion table] is the reasion.
> Now I occour 「〜」(0xefbd9e)、「―」(0xe28095)、「?b!W(0xe9ab99) can not be
> converted to SJIS without error message.
>
> I convert the character to another SJIS character
> by UPDATE tablexx SET fieldxx
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
Hi.
use set client_encoding=''SJIS be the same to export PGCLIENTENCODING=SJIS.
But can not export the data to csv file corecttly without errror,
just because the character which is not SJIS encoding.
Um, Please show the information on your database of 7.3.
ex)
postgres=# \l
List of
Hi.
Oh ok,
About the data in a database.
From the pre- report, you are operating by UTF-8. Therfore,
you should take it out by UTF-8 first. It is reload to new 8.3 of UTF-8.
Then, conversion does not occur there.
To the next.
when SJIS is required by the client , some character codes may not
I think i can export olddb(7.4) by encoding SJIS,
but can not import it into new db(8.3) for some unregular sjis character.
And
I create the database by encoding UTF-8 .
---
createdb -E UNICODE db
---
I think it is the same to set PGCLIENTENCODING=UTF-8
.
use set client_encoding=''SJIS be the same
Oops again..
or
--
set PGCLIENTENCODING=SJIS
pg_dump
or
copy of psql's.
--
However, an environmental setup is as follows again.
export PGCLIENTENCODING=SJIS
:-)
Regards,
Hiroshi Saito
- Original Message -
From: "Hiroshi Saito" <[EMAIL PROTECTED]>
Hi.
- Original Message --
Hi.
- Original Message -
From: "bh yuan" <[EMAIL PROTECTED]>
Thanks for your replay.
The "0xe9ab99" is not SJIS nor SHIFT_JIS_2004.
Ahh Ok, you already understood. :-)
But I shoud export data with not regular SJIS character
from old database(7.4.3) to new database(8.3),
and us
Thanks for your replay.
The "0xe9ab99" is not SJIS nor SHIFT_JIS_2004.
But I shoud export data with not regular SJIS character
from old database(7.4.3) to new database(8.3),
and use the old programe which export data as SJIS encoding .csv file.
Can I modify conf file to ignore the error?
or check
Ooops, shortage of information..sorry.
Please see,
http://winpg.jp/~saito/pg83/HASHIGODATA/
Hi.
- Original Message -
From: "bh yuan" <[EMAIL PROTECTED]>
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 prob
Hi.
- Original Message -
From: "bh yuan" <[EMAIL PROTECTED]>
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 en
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
16 matches
Mail list logo