I have a website with a chat system. This chat system has a table 'messages' and one of the columns is 'messagetext' set to utf8_general_ci(MySQL). In my website, I use php to query database. The results are ok.
In my app, i use NodeJS as backend but the results are like that: " Î±ÏƒÎ´Î±ÏƒÎ´ ". There are greek words stored in this column.
I have tried iconv-lite,iconv,utf8,decode Json.
My thought, in the website it's getting the value 'Î±ÏƒÎ´Î±ÏƒÎ' from column and decoding to utf8, that's how can I see the right results. BUT in app this is not happening, the results are the value instead of the actual word.
What can I do?
CREATE TABLE messages ( id int(11) NOT NULL AUTO_INCREMENT, sender int(11) NOT NULL, reciever int(11) NOT NULL, seen varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', datetime datetime NOT NULL, messagetext text NOT NULL, userseen varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8