problem with the encoding

Hello

I made a form with chronoforms in which the users will fill their details and i will get the results via an excel or csv file. The language i made the form is Greek. I read all the articles in the forum but i can't find the solution. A part of my form is demonstrated from the image utitled1.PNG and the results i get from my admin panel is in utitled.PNG.

The only thing i know is that the whole site and my database is in UTF-8 format.

Thus i don't backup the records to excel as well as csv form...

Hi nikosfree12,

Is the information stored correctly in the database table?

I think we've seen this before and it was something to do with the encoding of the admin pages.

Bob

Yes

The mail i receive is ok. The encoding is ok. I went to the mysql-administrator and i changed the jos_cronoforms_myformname torage engine to MyISAM, character set to UTF-8 Unicode and Collation UTF8_general_ci but the result is the same.

As i said the only thing i can read is the mail. On the other side data are coming in the right position but instead of characters i receive ??????????. One question mark for one character.

Nikos

Hi nikosfree12,

Please see this post - it may be what you need.

Bob

I embedded the code in index.php but the same result.

recently i opened my database in notepad++ and i observed that

/*!40000 ALTER TABLE `jos_chronoforms_exams` DISABLE KEYS */;
LOCK TABLES `jos_chronoforms_exams` WRITE;
INSERT INTO `logistes`.`jos_chronoforms_exams` VALUES  (9,'IZGFkM2Y1NTAyNzMz9590299e99f7e7e812003bb8fc31f7bc','2010-12-13 - 20:02:07','79.166.173.204','0','YU9264V','???????','?????????????','506','anfotino@yahoo.gr','3254452','?','??????????????? (101), ?????? ?????? (102), ???????? ????? ?/? (103), ???????? ???????????? (104)','','','','','','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_chronoforms_exams` ENABLE KEYS */;

I think that the problem is the database. The curious in my case is that when i changed the encoding inside mysql the question marks are remain.

Hi nikosfree12 ,

This has to be a character set issue. When you look at the database with PHPMyAdmin all the values look OK? And what are the character sets for the columns?

Bob

thanks for everything

there was an unexpected error in columns...The encoding was swedish

i am ready now to pay some licenses. Will be easy to provide me the cost list for the chronoforms?

Hi nikosfree12 ,

Great that you got it working :-)

Check the Subscriptions tab above for the prices. Max - the developer - deals with all of that.

Bob