UTF-8 Problem

[Piotr Usewicz]

Hi...

I've got a silly problem. I'm using a MySQL 4.1 with UTF-8 charset.
phpMyAdmin with UTF-8 charset aswell. The problem is when I enter data
in phpMyAdmin or any other MySQL tool, I can't see non standard letter
in my app. But when I enter data in my app i can't see thos chars in
let's say phpMyAdmin. Notice that my app is UTF-8 aswell... Any ideas
what's wrong? (PHP 5.0.3)

TIA
Piotr Usewicz

[Ja NE]

Piotr Usewicz <pi***@layer22.com> wrote:

Hi...

I've got a silly problem. I'm using a MySQL 4.1 with UTF-8 charset.
phpMyAdmin with UTF-8 charset aswell. The problem is when I enter data
in phpMyAdmin or any other MySQL tool, I can't see non standard letter
in my app. But when I enter data in my app i can't see thos chars in
let's say phpMyAdmin. Notice that my app is UTF-8 aswell... Any ideas
what's wrong? (PHP 5.0.3)

I had simmilar problem and have solved it with just one line after
database connection:

mysql_pconnect($hostname, $username, $password)
mysql_select_db($database)

add this line:

mysql_query("SET NAMES 'utf8'");
--
Ja NE
http://fotozine.org/?omen=janimir
--

[Piotr Usewicz]

Ja NE napisa³(a):

Piotr Usewicz <pi***@layer22.com> wrote:

Hi...

I've got a silly problem. I'm using a MySQL 4.1 with UTF-8 charset.
phpMyAdmin with UTF-8 charset aswell. The problem is when I enter data
in phpMyAdmin or any other MySQL tool, I can't see non standard letter
in my app. But when I enter data in my app i can't see thos chars in
let's say phpMyAdmin. Notice that my app is UTF-8 aswell... Any ideas
what's wrong? (PHP 5.0.3)

I had simmilar problem and have solved it with just one line after
database connection:

mysql_pconnect($hostname, $username, $password)
mysql_select_db($database)

add this line:

mysql_query("SET NAMES 'utf8'");

Thanks, i'll see whether it works or not ;]