Only CB messages appearing correctly

My old messages were latin (the same as ISO right?). I've copied the tables and then changed the collation into utf8_general_ci. The same I did in uddeim configuration.

New messages work fine.

:blink:

Post edited by: tachis, at: 2010/01/18 17:29

Post edited by: tachis, at: 2010/01/18 17:29

Post edited by: tachis, at: 2010/01/18 17:30

Thats the problem. When uddeIM decodes the base64 encoded messages the message is Latin-1 and not UTF-8. The correct solution would be to decode a base64 message, convert it from Latin-1 to UTF-8 and then to encode it again.

I am sorry but uddeIM currently does not provide this migration path.

If this is the problem, I still can't understand why I can correctly see the message in the "reply" area.

Anyway: how can I do what you suggest?

Post edited by: tachis, at: 2010/01/18 17:51

The text in the reply area is displayed in an input tag, so the browser does an conversion into UTF8 implicitly. Since uddeIM does not know the charset of the stored text (in your case it has changed when you updated Joomla) it cannot be converted automatically into UTF8. The browser "guesses" the source charset which may not always be correct on all systems.

Ok. So how can I, even manually, solve the problem? Otherwise the migration from Joomla 1.0 is impossible. On a forum I've read to use this query:

---
INSERT INTO utf8table (utf8column)
SELECT CONVERT(latin1field USING utf8) FROM latin1table;
---

Can it work?

No. This statement does only work when the text is not base64 encoded and obfuscated.