Skip site navigation (1) Skip section navigation (2)

Re: encoding problem

From: "Zouari Fourat" <fourat(at)gmail(dot)com>
To: nikolay(at)samokhvalov(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: encoding problem
Date: 2006-03-05 11:07:44
Message-ID: 621eda8a0603050307y6a797e37n7a382ab0232fd3f3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Ok thank you for the docs, i've read them and didtn get it working too :(

here's my conf :
---------------------------------------------------------------
#client_encoding = sql_ascii    # actually, defaults to database encoding
# These settings are initialized by initdb -- they may be changed
lc_messages = 'fr_FR.UTF-8'             # locale for system error
message strings
lc_monetary = 'fr_FR.UTF-8'             # locale for monetary formatting
lc_numeric = 'fr_FR.UTF-8'              # locale for number formatting
lc_time = 'fr_FR.UTF-8'                 # locale for time formatting
---------------------------------------------------------------

i get this error (using adodb from php) :

---------------------------------------------------------------
postgres7 error: [-1: ERREUR:  Séquence d'octets invalide pour le
codage «UNICODE» : 0xe96869] in EXECUTE("INSERT INTO hotqueues
(tcontent) VALUES('Méhiya c mon nom')")
---------------------------------------------------------------

when copy-pasting that INSERT query into phppgadmin or psql console,
the query is executed with no error.


On 3/5/06, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> wrote:
> you should just read these manual pages:
>
> http://www.postgresql.org/docs/8.1/interactive/creating-cluster.html
> http://www.postgresql.org/docs/8.1/interactive/charset.html#LOCALE
> http://www.postgresql.org/docs/8.1/interactive/multibyte.html
>
> On 3/5/06, Zouari Fourat <fourat(at)gmail(dot)com> wrote:
> > Hello,
> > Am having some problems with accentuated content as é à ç è ...
> > (frensh caracters)
> > When inserting from psql command line or phppgadmin some accentuated
> > caracters it works :(
> > I have some php scripts which interact with the database and throw
> > errors when trying to insert the same accentuated content that i
> > successfully inserted on phppgadmin and psql console clients.
> > What should i do ?
> > Thank you for helping me
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
> >
>
>
> --
> Best regards,
> Nikolay
>

In response to

Responses

pgsql-novice by date

Next:From: John DeSoiDate: 2006-03-05 15:08:34
Subject: Re: encoding problem
Previous:From: Nikolay SamokhvalovDate: 2006-03-05 08:00:13
Subject: Re: encoding problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group