On Sáb 18 Ago 2001 10:19, Florian Blaser wrote:
> 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.

psql, as well as pgaccess give me the encoded caracter instead of the 
acentuated vocal, but I don't mind, cuase psql is only for personal use. PHP 
gives me the right caracter.

> -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.

Which locale are you using (I think this has nothing to do with the problem, 
but who knows....).

> phpPgAdmin also has this problem, as well as all the websites I have
> written.

I just checked a database which is been loaded with phpPgAdmin 2.3 and I got 
the acents OK.

> Has anybody else had this problem, or does someone sees where I could watch
> further, I'm quite stuck ?

I really don't know where your problem can be. Try to set the environment 
variables correcty to your local locale. It could help.

Saludos... :-)

Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
Martín Marqués                  |        [EMAIL PROTECTED]
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to