I have a file txt with a lot of names of all nationality, so the problem is with some characters conversion in mysql; for example: the name "Yıldırım", when I import file, I see it like "Y1ld1r1m". For now, to fix this problem, I do some steps:
- import txt file in Access
- export it from Access to csv file
- import csv file in an older version of xampp (in the newest version I see ? character)
- export sql file of table
- import sql file in my online database
In this way the name "Yıldırım" I see like "Yildirim".
But this is very very boring to do every time.
I try a lot of character set but I see "Yıldırım" always like "Y1ld1r1m". Yesterday I try with a new version of xampp and, with some tests, I found utf-16le character set; so, if I set the column with utf-16le and import txt file with LOAD DATA INFILE, I see "Yıldırım" like "Yıldırım".
Very good!!! But my online database (with Aruba) doesn't have utf-16le!! What can I do? Someone has some idea?