BUG: UTF-8 does NOT work!

[eluser]Vasu Adiga[/eluser]
Got it fixed. 3 potential causes:

1) Old version (4.x) of mysql db: Upgraded to the latest version (5.x) of mysql db.

2) The data was being inserted by a java application using jdbc/odbc connector. Changed connector to Connector/J. Reinserted all data.

3) Changed mysql db and table collation from utf8_general_ci to utf8_unicode_ci

No other changes or tweaks.

[quote author="Vasu Adiga" date="1270485196"]As you mentioned, when I use utf8 decode it throws up garbage. I used this to decode the data.

For others, I have stored hindi unicode data using java application in mysql db (4.x). See example patrika. Does mysql version have anything to do with this issue? Any help in this regard is appreciated. I use codeigniter 1.7.2 and notepad++.