[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    [PHP-DB] Accents and postgresql
From:       Florian Blaser <mjjblaser () vtx ! ch>
Date:       2001-08-18 12:32:30
[Download RAW message or body]

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net

[prev in list] [next in list] [prev in thread] [next in thread]