OpenCart Community

Hi!

When I use these characters "àèìòù" in a description and save the product mysql write a "?" instead of the char.

I have this problem on a online server but not on localhost ( win with xammp )

any hint?

I searched and googled, no solution found

Thanks

update, yesterday I tried to modify again a product in the local website and it does not work anymore :|

I can't reproduce your problem, it works fine with 0.7.9RC6. Just make sure to use the UTF-8 UNICODE character set for your database.

yes the database is utf8 unicode

What version of OpenCart are you using? What's the URL of your website? What version of PHP and MySQL?

I think is opencart 0.78 , where can I find in the source code?

Php 5.2.5
Apache/2.2.3
mysql 5.0.45

I think is opencart 0.78 , where can I find in the source code?

You should use the latest OpenCart 0.7.9RC6 which you can find here.

I know... but I did a lot of work to use my template and to add a mod ( 2 description for product, 1 short, 1 complete ) and I need to finish it for a client.

There is any significant change regards utf8 and mysql ?  in this case I update only the files needed to solve the bug.

Thanks a lot

If you are using templates correctly, then there should be no issue, except for maybe a few feature updates in certain tpl files that you can manually merge

I think I found the problem, its the fckeditor causing the problem!

Cause I tried to enter in "Code" mode and write my text with èòàùì and it works!

There is some utf8 setting for the editor? Or I just need to upgrade it?

Thanks!