I have a CSV file with data generated by myself in UTF-8 (no BOM) encoding. If i try to upload this data by script (simple reading file and mysql queries, works well), the result is not what i should expect, for example:
All files scripts etc. are UTF-8 (no BOM), wordpress tables are utf8mb4_unicode_520_ci. I ran out of ideas.
Read more here: WordPress CSV import encoding issue