I use UTF-8 and I have cpg bridged with Joomla. However, cpg when exported from db appears likes this (for Greek)
(2, 'I^"I^?I^^(o)I^^(1)I^1/4I^±I"ƒI",,I^^(1)I^^(o)I"OE', '', 0, 'NO', 'YES', 'YES', 1, 10095, 0, NULL, NULL, NULL),
(4, 'I^ I^?I"?I^µI^?I^± I"ƒI",,I^? I^¥I"€I^?I"...I"?I^³I^µI^?I^? I^ I^±I^^(1)I^?I^µI^?I^±I", - 2006', 'I^ I^?I"?I^µI^?I^± I",,I^·I", I^^I^½I"‰I"ƒI^·I", I"ƒI",,I^? I^¥I"€I^?I"...I"?I^³I^µI^?I^? I",,I^?I^½ I^£I^µI"€I",,I^I^1/4I^²I"?I^^(1)I^? I",,I^?I"...
Whereas joomla tables appear just fine:
(48, 14, 0, 'Μουσείο Φυσικής Ιστορίας Γουλανδρή', 'http://www.ekby.gr/', 'Δραστηριότητες, δημοσιεύσεις, βιβλιοθήκη, προγράμματα.', '2007-10-09 00:53:39', 21, 1, 0, '0000-00-00 00:00:00', 7, 0, 1, 'target=0'),
Do you know which tool can I use to convert cpg data so that they display OK on db level too?
Make sure that you have set up the mysql table collation correctly.