Jump to content

MySql codepage problem


Guest

Recommended Posts

Good morning to all.

I have this problem if anyone can please help.

I have setup my shop in Greece so i have copy/paste the language/EN folder to a new one with name GR.

I have change the config.php to :

<?php

setlocale(LC_TIME, 'gr_GR');

$langName = "Ελληνικά";

$charsetIso = "UTF-8";

$strftime = "%A %e, %B %Y";

?>

and translated the pages i wanted from inside the administration panel.

Everything works 100%

I add my categories and products in Greek and everything shows in the store perfect.

THE PROBLEM

I want to add multiple categories from an Excel worksheet directly to MySql database.

My full database collation is in UTF8_general_ci.

But when i open tables with phpmyadmin, all the Greek characters are in various Ascii !

So the use of export data of any table is useless because all the Greek characters data are in Ascii.

So when i import the CSV file to Excel i cant view them as Greek.

Vise-verse i cant use the import in phpmyadmin because the data are corrupted heavily.

Does Cubecart writes the data in MySql with some other codepage?

From inside the admin all Greek characters are perfect, from inside MySql everything is in Ascii !

What is wrong ?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...