Unicode characters problem in User Profile table & frontend - Joomla! Forum - community, help and support

hello,

i having problem unicode characters. not know if existing problem joomla (was 2.5.7, upgraded 2.5.8 ). problem has existed since before upgrade.

when user adds information upon registration profile (in #__user_profiles table), part of information supplied in bulgarian (cyrillic script) inserted in unicode characters, e.g. "\u0421\u043e\u0444\u0438\u044f". if added in latin, inserted standard english script.

i don't understand quotes come -- both data supplied in cyrillic , in english has quotes around in db table. compared different joomla installation (2.5.7), , not occur there.

when retrieve data db display on frontend, displayed inserted - "\u0421\u043e\u0444\u0438\u044f", including quotes. when view user's profile backend, problem not occur - unicode converted proper cyrillic, no quotes.

i have edited user profile plugin modify existing fields , add news ones - both here , in other installations problem doesn't occur. have made sure save files (php/xml) in utf, don't think that's problem.

i have reviewed code appears relevant - both in frontend , backend. using new component display user profile in frontend (http://extensions.joomla.org/extensions/clients-a-communities/members-lists/19996 ) problem not related because before discovered component displaying information directly under author's name in article view, , still displayed unicode characters.

so, sort of stuck... please!

problem solved!

i discovered part converts cyrillic input unicode: line 278 in /plugins/user/profile/profile.php

code: select all

$tuples[] = '('.$userid.', '.$db->quote('profile.'.$k).', '.$db->quote(json_encode($v)).', '.$order++.')';

it json_encode function. don't know when function added joomla (apparently recently) new addition must taken account when data encoded displayed on frontend.

in solution, add json_decode every piece of data retrieve user profile table.