utf8 not working for me

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
PlutoPlanet
Posts: 10
Joined: Tue 28 Aug 2007 08:08

Post by PlutoPlanet » Tue 11 Sep 2007 18:44

You mean I (PHP) did not store the string correctly to database? But reading the string from MySQL via PHP works as expected (see my first post).
Or does "SET NAMES utf8" change everything globally?
ok, I'll try

PlutoPlanet
Posts: 10
Joined: Tue 28 Aug 2007 08:08

Post by PlutoPlanet » Tue 11 Sep 2007 19:16

GOD BLESS YOU! FINALLY IT WORKED!!!

SET NAMES utf8; ...does this take effect database or system-wide?

...you won't believe what I tried to do to get this work...

THANK YOU AGAIN![/img]

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 12 Sep 2007 06:54

It is good to see that this problem has been solved.

The SET NAMES command setups encoding for the current connection only. You can read more in this topic of MySQL Reference Manual.

Post Reply