Re: Character Set Issues with MySQL 5.0.17?  A

[Robert Cluett]

Thank you for the response Alexander, Here are you answers in-line:

Question: Which language are the posts written in?
Answer: PHP 5.0

Question: How does SHOW CREATE TABLE look like for this with text columns?
Answer: `blog_article` text character set latin1 NOT NULL,

Question: Which language is the web application written in?
Answer: PHP 5.0

Question: Does ALL original characters get replaced with ÂÂÂ,?
Answer: No, it's typically spaces and tabs that generate the à characters.

Here is the output of the show variables like '%character%';

mysql> show variables like '%character%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
7 rows in set (0.01 sec)

Here is the my.cnf file:

[mysqld]
log-bin
server-id=1
character-set-server=utf8
default-collation=utf8_unicode_ci
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
query_cache_type = 1
query_cache_size = 26214400
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=2
[mysql]
default-character-set=utf8

Here is the output from the the query: SELECT blog_article, HEX(blog_article) FROM blog_articles WHERE id = 5

Blogs are an excellent place to share ideas and obtain feedback from your collea
gues.  Anyone who reads your blog has the opportunity to comment on your mater
ial.  Comments are intended to initiate dialogue and to encourage positive an
d negative feedback.  Keep your comments professional and take any matters not

... note the   where spaces should be.

I've tried every conveivable combination here and haven't been able to get it to work but it is as you said only effecting 'text' type columns. Any ideas would be appreciated. Thank you.



Edited 1 time(s). Last edit at 06/27/2006 11:41AM by Robert Cluett.