TOPIC:

Characters issue after import a csv file 6 years 5 months ago #23731

designt
Topic Author
Offline
New Member
Posts: 10
Thank you received: 0

Hi,
I am getting language problems after importing a venues.csv (Encoded with UTF-8 Unicode).
Portuguese characters are not imported correctly.
jem_venues table has a venue field set with UTF-8 Unicode(Encoding) and utf8_general_ci for Collation.
Everything seams correct to me but when I import I get wrong characters.
I think I will get the same issue when importing events table.
Also the last row was not imported.
Any tips will be appreciated.
Thanks

Database Version 5.5.52-MariaDB
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.0.19 FPM/FastCGI
Web Server Apache
WebServer to PHP Interface fpm-fcgi
Joomla! Version Joomla! 3.6.5 Stable
JEM 2.2.0

Please Log in or Create an account to join the conversation.

Last edit: by designt.

Characters issue after import a csv file 6 years 5 months ago #23732

jojo12 Offline Administrator Posts: 3723 Thank you received: 450	sorry for answering so late, but I can't reproduce your issue, perhaps others?
	Please Log in or Create an account to join the conversation.

Characters issue after import a csv file 6 years 4 months ago #23801

designt Topic Author Offline New Member Posts: 10 Thank you received: 0	I successfully import the venues.csv using phpMyAdmin. Thanks. Database Version 5.5.52-MariaDB Database Collation utf8_general_ci Database Connection Collation utf8mb4_general_ci PHP Version 7.0.19 FPM/FastCGI Web Server Apache WebServer to PHP Interface fpm-fcgi Joomla! Version Joomla! 3.6.5 Stable JEM 2.2.0
	Please Log in or Create an account to join the conversation.