utf8 characters are broken..
Posted by: Pedro Han
Date: June 22, 2005 09:02PM

Dear Sirs,

My system is set up as;

two systems.
fedora 3 and xp sp2
and apm versions are apache 2.0.53, php 5.0.4, mysql 4.1.12

I want to use utf8 and wrote my.cnf as;

[client]
port = 3306
socket = mysql
default-character-set=utf8

[mysqld]
port = 3306
socket = mysql
skip-locking
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
[mysql]
default-character-set=utf8

and,

mysql> show variables like "%character%";show variables like "%collation%";
+--------------------------+------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | \xampp\mysql\share\charsets/ |
+--------------------------+------------------------------+
7 rows in set (0.00 sec)

+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

And,
php
default_charset ="utf-8"

httpd.conf
DefaultLanguage ko
AddDefaultCharset UTF-8

web
utf-8

However, some Korean (not all) characters are broken at mysql database, phpmyadmin, and web.

What am I missing?



Edited 1 time(s). Last edit at 06/22/2005 09:03PM by Pedro Han.

Options: ReplyQuote


Subject
Views
Written By
Posted
utf8 characters are broken..
2966
June 22, 2005 09:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.