Re: accents and postgresql

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 | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------