convert csv file to csv UTF8 by php

Question

I got .csv file from client but when I read it with PHP, it show some text can't read. I try to upload and open with google sheet and then export .csv again with google. it work perfect when I read it with php.

Are there any way to convert .csv to .csv UTF8 without using google ? because client will send .csv to server everyday automatic. and then my php script will read and import .csv data into database. please help

Thanks

I already try with header('Content-Type: text/html; charset=utf-8'); and iconv_set_encoding("internal_encoding", "UTF-8"); , both are doesn't work. — Ryo
– Ryo, Commented Apr 25, 2015 at 13:02
it doesn't work I try to use echo iconv( "Windows-1252", "UTF-8", $data[$c] ) follow their code. it still show unreadable text. Please help — Ryo
– Ryo, Commented Apr 25, 2015 at 14:29

hyperplural · Accepted Answer · 2018-09-04 06:46:40Z

1

I found the way, first using:

header('Content-Type: text/html; charset=utf-8');

and we need to find which encode language we use from here

http://destructor.de/charsets/index.htm

My language is Thai so i need to use windows-874. so it should be:

iconv("windows-874", "UTF-8", $data[$c]);

so just using this 2 line

header('Content-Type: text/html; charset=utf-8');
iconv("windows-874", "UTF-8", $data[$c]);

Thank Sumit :)

edited Sep 4, 2018 at 6:46

hyperplural

2356 silver badges23 bronze badges

answered Apr 25, 2015 at 14:38

Ryo

1311 silver badge14 bronze badges

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

Comments

krzy-wa · Accepted Answer · 2015-11-25 09:08:00Z

0

You can try to add "BOM" to the beginning of CSV file (ie. three bytes: EF BB BF - https://en.wikipedia.org/wiki/Byte_order_mark). In my experience CSV files with BOM are interpreted well by Excel. Maybe it will help in your case.

answered Nov 25, 2015 at 9:08

krzy-wa

4711 gold badge4 silver badges6 bronze badges

Collectives™ on Stack Overflow

convert csv file to csv UTF8 by php

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related