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]
