help to better help you:

Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!

Characters issue after import a csv file

Characters issue after import a csv file

7 years 10 months ago - 7 years 10 months ago
#23731
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_unicode_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
Last edit: 7 years 10 months ago by designt.

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

Re: Characters issue after import a csv file

7 years 10 months ago
#23732
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.

Re: Characters issue after import a csv file

7 years 9 months ago
#23801
I successfully import the venues.csv using phpMyAdmin.
Thanks.
Database Version 5.5.52-MariaDB
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_unicode_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.

Time to create page: 0.425 seconds