Change the encoding of a .csv file before MySQL import

Question

I create a CSV file with an automated VB script of an Excel file. The file is encoded with latin_1. To import this file correctly into my MySQL database I need to convert the encoding of the file to UTF8.

It works if I save the file manually to UTF8, but I would like to have that automated with PHP.

The direction is XLS -> CSV -> MYSql. Everything runs on windows.

Are you have xls or csv originally?

Dmitriy Antonenko
– Dmitriy Antonenko

2016-10-02 21:15:17 +00:00
Commented Oct 2, 2016 at 21:15 — Dmitriy Antonenko
– Dmitriy Antonenko, Commented Oct 2, 2016 at 21:15

Bartosz Zasada · Accepted Answer · 2016-10-02 21:16:38Z

1

This will convert the encoding of any text file from any encoding to UTF-8. Note that it will not work with an XLS file; you'd have to convert it to CSV first:

$pathToFile = '...';
$original = file_get_contents($pathToFile);
$originalEncoding = mb_detect_encoding($original);
$converted = mb_convert_encoding($original, 'UTF-8', $originalEncoding);
file_put_contents($pathToFile, $converted);

If you don't want to overwrite your original file, specify a different first argument for file_put_contents().

answered Oct 2, 2016 at 21:16

Bartosz Zasada

3,9102 gold badges23 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Terry Over a year ago

There is an open source library know as PHPExcel that can parse XLS files without the need to convert to CSV manually.

Collectives™ on Stack Overflow

Change the encoding of a .csv file before MySQL import

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related