mysql - How to insert greek text in my sql db through PhpMyAdmin -

i'd ask question that's been bothering me days now. have mysql db 1 table concisted of 38 cells. among cells 2 of them expecting greek text in them (firstname , lastname). table , each cell formatted in utf8-general-ci

cause table filled thousand of rows every month, have selected populate incerting csv file created in excel (csv file commas).

the problem won't allow greek text populate 2 cells, returning following answer:

1366 - incorrect string value: '\xcc\xc1\xcc\xc1\xd3' column 'lastname' @ row 1

does have suggestion on do????

in phpmyadmin when choose table import se option "charset file" (in greek version of phpmyadmin "Σύνολο χαρακτήρων του αρχείου") must select utf-8.

if doesnt work check csv file if greek characters fine or not must check exporting method.