Hello.
Please, send the output of the following statements:
show variables like '%char%';
show create table table1;
Tulong! [EMAIL PROTECTED] wrote:
Here's how the problem starts.
1. Entered Korean characters in a form.
2. Press submit and I receive that error.
SHOW VARIABLES LIKE ''%char%;
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_results utf8
character_set_server latin1
character_set_system utf8
SHOW CREATE TABLE `table1`;
CREATE TABLE `main_peeps` (
`id` int(11) unsigned NOT NULL
Mark Dacasco wrote:
SHOW VARIABLES LIKE ''%char%;
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_results utf8
character_set_server latin1
character_set_system utf8
SHOW CREATE TABLE `table1`;
CREATE TABLE `main_peeps` (
`id` int(11)
I didn't find any option for character-set-server so I add it under
mysqld as you've stated. I also found default-character-set so I also
set its value to utf8. It didn't work.
I tried adding a dash (utf-8) to it. It didn't work also.
Yes, I did restart MySQL after saving the configuration.
useful links:
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
http://dev.mysql.com/doc/mysql/en/Charset-server.html
http://dev.mysql.com/doc/mysql/en/Charset-map.html
http://dev.mysql.com/doc/mysql/en/Option_files.html
http://bugs.mysql.com/bug.php?id=3611
I've found this in my
You're right. It is not related. The same output are shown as before.
However, the links you gave me was quite useful. I re-read and
re-read them over and over until this little query solved my dilemma, sort of:
SET NAMES 'utf8';
Thanks for the help! ^_^
useful links: