pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL encoding
4+ messages / 3 participants
[nested] [flat]
* PostgreSQL encoding
@ 2005-02-22 12:27 Zouari Fourat <fourat@gmail.com>
2005-02-22 12:43 ` Re: PostgreSQL encoding mauro.folcarelli@sistinf.it
0 siblings, 1 reply; 4+ messages in thread
From: Zouari Fourat @ 2005-02-22 12:27 UTC (permalink / raw)
To: pgsql-php
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 'é,à,ç,è') and on my php application the
accet characters doesnt work, how to resolve that
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL encoding
2005-02-22 12:27 PostgreSQL encoding Zouari Fourat <fourat@gmail.com>
@ 2005-02-22 12:43 ` mauro.folcarelli@sistinf.it
2005-02-22 13:27 ` Re: PostgreSQL encoding Zouari Fourat <fourat@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: mauro.folcarelli@sistinf.it @ 2005-02-22 12:43 UTC (permalink / raw)
To: Zouari Fourat <fourat@gmail.com>; +Cc: pgsql-php; pgsql-php-owner@postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL encoding
2005-02-22 12:27 PostgreSQL encoding Zouari Fourat <fourat@gmail.com>
2005-02-22 12:43 ` Re: PostgreSQL encoding mauro.folcarelli@sistinf.it
@ 2005-02-22 13:27 ` Zouari Fourat <fourat@gmail.com>
2005-02-22 13:32 ` Re: PostgreSQL encoding Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 1 reply; 4+ messages in thread
From: Zouari Fourat @ 2005-02-22 13:27 UTC (permalink / raw)
To: mauro.folcarelli@sistinf.it <mauro.folcarelli@sistinf.it>; +Cc: pgsql-php; pgsql-php-owner@postgresql.org
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
<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:
>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html"; charset="utf-8">
>
> that's all.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL encoding
2005-02-22 12:27 PostgreSQL encoding Zouari Fourat <fourat@gmail.com>
2005-02-22 12:43 ` Re: PostgreSQL encoding mauro.folcarelli@sistinf.it
2005-02-22 13:27 ` Re: PostgreSQL encoding Zouari Fourat <fourat@gmail.com>
@ 2005-02-22 13:32 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 0 replies; 4+ messages in thread
From: Christopher Kings-Lynne @ 2005-02-22 13:32 UTC (permalink / raw)
To: Zouari Fourat <fourat@gmail.com>; +Cc: mauro.folcarelli@sistinf.it <mauro.folcarelli@sistinf.it>; pgsql-php
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-02-22 13:32 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-22 12:27 PostgreSQL encoding Zouari Fourat <fourat@gmail.com>
2005-02-22 12:43 ` mauro.folcarelli@sistinf.it
2005-02-22 13:27 ` Zouari Fourat <fourat@gmail.com>
2005-02-22 13:32 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox