One can convert the erroneous charset like this in SQL (modify this to do UPDATE):
select convert(binary convert(value using latin1) using utf8) from prosody
MattJ
on
Changes
owner MattJ
tags Milestone-0.10
Zash
on
Thanks for the report.
The prosody issue you mention is #268. We will need to apply the same solution to the migrator.
Changes
tags Status-Accepted
Zash
on
Probably really should fix this before 0.10 is released :)
prosody migrator has a problem with charsets when migrating between internal storage and SQL one. It's the same bug as this: https://groups.google.com/forum/#!topic/prosody-users/FLL9Nb060pQ but only in migrator, not prosody itself
One can convert the erroneous charset like this in SQL (modify this to do UPDATE): select convert(binary convert(value using latin1) using utf8) from prosody
Thanks for the report. The prosody issue you mention is #268. We will need to apply the same solution to the migrator.
ChangesProbably really should fix this before 0.10 is released :)
ChangesMattJZashPorted util.sql in https://hg.prosody.im/0.10/rev/605fa6bfafd1 Added charset check in https://hg.prosody.im/0.10/rev/ffb36d1ae23b If the check does not pass, it will demand the database be updated via prosodyctl. Needs testing.
ChangesTested briefly with SQLite3.