search

ushahidi / SwiftRiver-Core

SwiftRiver Core Applications
6 stars 3 forks source link

UTF-8 Encode Drop Content #6

Closed 69mb closed 12 years ago

69mb commented 12 years ago

Ensure drops are UTF-8 encoded starting with the fetcher and ensure encoding does not change in any of the post processors.

69mb commented 12 years ago

Encoding is lost somewhere in the core causing the below:

ekala commented 12 years ago

This has been fixed. The encoding issues were because of the replication setup. For some reason, MySQL replication was using the system character set and collation - latin1 and latin1_swedish_ci. To fix the issue, set the system-wide character set to UTF in my.cnf on both master and slave.

[mysqld]
# -- Character set and collation --
default-character-set = utf8
collation-server = utf8_general_ci
character-set-server = utf8

[mysql]
default-character-set = utf8

[client]
default-character-set = utf8

Re-open if issue still recurs