skip to Main Content

importing csv to mysql database – how to read file with Polish characters? – Phpmyadmin

I have a csv file which it has a Polish characters too. The content of this is here: ID_WORKER;FNAME;LNAME;WORKERS_GROUP;POSITION; 1;Paweł;ĄąĆćĘꣳŃńÓ󌜏źŻż;IT;IT Specialist; 6;Dawid;ĄąĆćĘꣳŃńÓ󌜏źŻż;Technologists;Technologists; 8;Maciej;ĄąĆćĘꣳŃńÓ󌜏źŻż;Storekeepers;Storekeeper; As you see it has these characters like "Ąą Ćć Ęę Łł Ńń Óó Śś Źź Żż".…

VIEW QUESTION

How to use delimiter having multiple characters using apache commons csv

I have a input file whose delimiter is a combination of characters like #$#. But apache commons CSVParser consider only a character not multiple characters. Please find the input file: Rajeev Kumar Singh ♥#$#[email protected]#$#+91-9999999999#$#India Sachin Tendulkar#$#[email protected]#$#+91-9999999998#$#India Barak Obama#$#[email protected]#$#+1-1111111111#$#United States Donald…

VIEW QUESTION
Back To Top
Search