| Lists: | Postg토토SQL : Postg토토SQL 메일 링리스트 : 2005-02-22 이후 PGSQL-PHP 12:27 |
|---|
| From: | Zouari Fourat <fourat(at)gmail(dot)com> |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | PostgreSQL encoding |
| Date: | 2005-02-22 12:27:37 |
| Message-ID: | 621eda8a0502220427655f3cfe@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토SQL : Postg토토SQL 메일 링리스트 : 2005-02-22 이후 PGSQL-PHP 12:27 |
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
| From: | mauro(dot)folcarelli(at)sistinf(dot)it |
|---|---|
| To: | Zouari Fourat <fourat(at)gmail(dot)com> |
| Cc: | pgsql-php(at)postgresql(dot)org, pgsql-php-owner(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL encoding |
| Date: | 2005-02-22 12:43:14 |
| Message-ID: | OFD5F0FFB0.0420B105-ONC1256FB0.004460E7-C1256FB0.0045E081@fds.internal.fds.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
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.
| From: | Zouari Fourat <fourat(at)gmail(dot)com> |
|---|---|
| To: | "mauro(dot)folcarelli(at)sistinf(dot)it" <mauro(dot)folcarelli(at)sistinf(dot)it> |
| Cc: | pgsql-php(at)postgresql(dot)org, pgsql-php-owner(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL encoding |
| Date: | 2005-02-22 13:27:55 |
| Message-ID: | 621eda8a050222052744aac754@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg젠 토토SQL : Postg젠 토토SQL 메일 링리스트 : 2005-02-22 이후 PGSQL-PHP 13:27 |
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(dot)folcarelli(at)sistinf(dot)it
<mauro(dot)folcarelli(at)sistinf(dot)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.
>
| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Zouari Fourat <fourat(at)gmail(dot)com> |
| Cc: | "mauro(dot)folcarelli(at)sistinf(dot)it" <mauro(dot)folcarelli(at)sistinf(dot)it>, pgsql-php(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL encoding |
| Date: | 2005-02-22 13:32:54 |
| Message-ID: | 421B3486.9080503@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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