Re: browser shows garbage instead of UTF-8 characters

From: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: browser shows garbage instead of UTF-8 characters
Date: 2006-04-13 15:29:49
Message-ID: 200604131729.49793.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On Thursday 13 April 2006 13:12, Sadm sadm wrote:
>Hello!
>I have a PostgreSQL database with UTF-8 encoding. It stores russian
> characters. When I fetch a record from this database and output it to
> the web browser as html page, it looks like a garbage instead of
> normal russian characters. I'm using html with <meta
> http-equiv="Content-Type" content="text/html; charset=utf-8">.
>
>Please help me to find a mistake.
>Thanks in advance.

If you're using PHP, you should issue the command:

pg_set_client_encoding($db, $encoding);

I don't know which value of $encoding you should use with Cyrillic
letters, but I'm using LATIN1 which works fine with Norwegian.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2006-04-13 15:30:37 Re: the integer type
Previous Message Tony Caduto 2006-04-13 15:19:05 Re: the integer type

Browse pgsql-jdbc by date

  From Date Subject
Next Message Guy Rouillier 2006-04-13 15:46:56 Re: Date format problem with INSERT statement.
Previous Message Xavier Poinsard 2006-04-13 14:51:24 Re: Date format problem with INSERT statement.