Обсуждение: browser shows garbage instead of UTF-8 characters

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.


--
_______________________________________________
Get your free email from http://mymail.bsdmail.com

Sadm,

what is the encoding setting of your database driver?

What happens if you put out the retrieved Data to a console or a debug window?

Have you analyzed the garbage, what is it? Escaped Characters? Hungarian? Arabian? Chinese??

How do you "fetch a record", how do you output it to "THE" "Web browser"? What are your HTML Headers? Which HTML / XHTML do you use?

Harald




--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
PostgreSQL - supported by a community that does not put you on hold

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