Issue with MySql and the Greek characters using mysql for excel -


i used mysql excel in order import data excel mysql db.

when used "select" command in mysql workbench realised greek characters appeared question marks "?"

then saved excel file .csv , opened notepad++ in order encode utf8.

then used following command , again problem greek chars made worse.

load data local infile 'c:/working.csv'  table tablexxx character set utf8 fields terminated ';' enclosed '"' lines terminated '\r\n'; 

can please me out. dead end here!!!

try greek character set

character set cp869; 

but should work utf-8 maybe need change settings in notepad++ or in mysql workbench , other programs desire use.


Comments

Popular posts from this blog

java - Ebean enhancement ignores a model -

ubuntu - How to disable Kernel Module Signing in linux -

SQL php on different pages to Insert (mysqli) -