Categories
View Replies (7)

Resolved Cant export unicode characters

  1. dimis308
    dimis308
  2. RO CSVI
  3. Wednesday, 15 December 2021
  4.  Subscribe via email
I am using Joomla 4.0.4 and RO CSVI 8.0. I am having trouble exporting unicode characters (greek). My headers are ok but the content is ????????
The tables are utf8mb4_unicode_ci, the @@character_set_database is utf8 and the @@collation_database is utf8_genereal_ci

I try to open it with notepad++ or simple notepad but the problem persists.

Any suugestions?
0
Accepted Answer
dimis308
dimis308
Accepted Answer Pending Moderation
No, its not that. I tried debugging and sent an email to myself with the $contents before the writeOutput function athe email came with ???
So I went to the file:
administrator/components/com_csvi/models/exports.php and changed:
$this->pdo = Connection::new(
'mysql:host=' . $config->get('host') . ';dbname=' . $config->get('db'),
$config->get('user'),
$config->get('password')
);

to

$this->pdo = Connection::new(
'mysql:host=' . $config->get('host') . ';charset=utf8;dbname=' . $config->get('db'),
$config->get('user'),
$config->get('password')
);

and it works.

So you must take it into consideration somehow.

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The problem with unicode characters must be because of the program you are using to open the export file. Try opening your export file with OpenOffice/LibreOffice and see if that makes a difference.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for posting the solution. Can you tell us the MySQL version you are running? To get that, on Joomla System menu >> System information >> System information tab check Database Version. Post the version here to check
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
dimis308
dimis308
Accepted Answer Pending Moderation
Yes, it is
5.7.32-0ubuntu0.16.04.1
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Thank you for your feedback. We will include the charset fix in the upcoming release. The charset will be set to utf8mb4 as this is the same one Joomla uses.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
tomafis33
tomafis33
Accepted Answer Pending Moderation
Hi,
I have the same problem. Only with Czech characters...When will the patched version be released?
thank you for answer
Thomas
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Thomas,
This fix has been released with RO CSVI 8.1.0 version. If you are not using this version, please update to latest RO CSVI 8.8.0 version and check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!