PostgreSQL encoding

Hello,
am new to pgsql and i have some problem with encoding and charsets,
i can view my data over pgadmin3 without any problem (i have some
frensh data with accents '=E9,=E0,=E7,=E8') and on my php application the
accet characters doesnt work, how to resolve that

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: PostgreSQL encoding

This is a multipart message in MIME format.
--=_alternative 0045E028C1256FB0_=
Content-Type: text/plain; charset="US-ASCII"

I solved my problems with charsets in this way:

1. Before composing the HTML page send the header, in this way:

header("Content-type: text/html; charset=utf-8");

2. Put in HTML page the following:



that's all.

--=_alternative 0045E028C1256FB0_=
Content-Type: text/html; charset="US-ASCII"



I solved my problems with charsets in
this way:



1. Before composing the HTML page send
the header, in this way:



header("Content-type: text/html;
charset=utf-8");



2. Put in HTML page the following:



<META HTTP-EQUIV="Content-Type"
CONTENT="text/html"; charset="utf-8">



that's all.

 
--=_alternative 0045E028C1256FB0_=--

Re: PostgreSQL encoding

there's no 'standard' way to do that ?
and if i got arabic content or chinese one, i should change headers again ?


On Tue, 22 Feb 2005 13:43:14 +0100, mauro.folcarelli@sistinf.it
wrote:
>
> I solved my problems with charsets in this way:
>
> 1. Before composing the HTML page send the header, in this way:
>
> header("Content-type: text/html; charset=utf-8");
>
> 2. Put in HTML page the following:
>
>
>
> that's all.
>

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: PostgreSQL encoding

> there's no 'standard' way to do that ?

That is the standard way to do it...

> and if i got arabic content or chinese one, i should change headers again ?

Yes, because the encoding is different. However, arabic usually uses
Unicode as well.

Chris

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)