yep, that's what happened. i would guess that you setup things properly
on the Roller side so that the app is trying to connect and use UTF-8,
but your db itself is probably defaulting to latin1 (mysql?). You
should probably have these set in your mysql config somewhere ...
default-character-set=utf8
default-collation=utf8_general_ci
and while you are at it i would also suggest that you use the InnoDB
storage engine. if you are okay with all dbs in that mysql instance
being InnoDB then you can just do this ...
default-storage-engine=innodb
and then make sure you set/uncomment the innodb settings in the config ...
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /app/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /app/mysql/data/
innodb_log_arch_dir = /app/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
HTH,
-- Allen
Jeffrey Blattman wrote:
hi,
when i try to post a weblog that contains multibyte chars, i get this:
Caused by: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation '='
did i miss something when configuring my database?
thanks.
