accents and postgresql
| From: | Florian Blaser | Date: | Sat, 18 Aug 2001 13:19:45 +0000 |
| Subject: | accents and postgresql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-63285@lists.php.net to get a copy of this message | ||
[I already sent this message to the php-db mailing list, but since it seems
to be a low-traffic list, I thought I'd also send it to this list, thanks a
lot for your answers :-)]
Hi everybody !
I've got a quite confusing problem :
Yesterday, I upgraded my postgresql server from 7.0.3 to 7.1. I did some
pg_dumps and created the DBS on the new server. Everything went fine.
But now, I've got some problems : When accessed through php, *sometimes*
characters with accents don't come out right. I did some testing and the
results are here :
-psql doesn't have this problem, so I think it is not a postgresql related
thing.
-When the database is created with a UNICODE encoding, accentuated characters
appears as (xx). With a SQL_ANSII encoding, accentuated characters come out
as other letters.
phpPgAdmin also has this problem, as well as all the websites I have written.
Has anybody else had this problem, or does someone sees where I could watch
further, I'm quite stuck ?
Thanks a lot for your replies.
Florian Blaser