[àèìòù] Character problem in product description

Quote

Post by Nightmare » Fri Jan 16, 2009 7:44 am

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
Nightmare
Newbie
Posts
9
Joined
Sat Jun 23, 2007 9:16 pm
Top

Re: [àèìòù] Character problem in product description

Quote

Post by Nightmare » Sat Jan 17, 2009 11:13 pm

update, yesterday I tried to modify again a product in the local website and it does not work anymore :|
Nightmare
Newbie
Posts
9
Joined
Sat Jun 23, 2007 9:16 pm
Top

Re: [àèìòù] Character problem in product description

Quote

Post by JNeuhoff » Sun Jan 18, 2009 2:50 am

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.

Attachments

???
screenshot-phpmyadmin.png
???
screenshot-product5.png

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7456
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: [àèìòù] Character problem in product description

Quote

Post by Nightmare » Sun Jan 18, 2009 3:29 am

yes the database is utf8 unicode
Nightmare
Newbie
Posts
9
Joined
Sat Jun 23, 2007 9:16 pm
Top

Re: [àèìòù] Character problem in product description

Quote

Post by JNeuhoff » Sun Jan 18, 2009 3:37 am

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

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7456
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: [àèìòù] Character problem in product description

Quote

Post by Nightmare » Mon Jan 19, 2009 2:17 am

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
Nightmare
Newbie
Posts
9
Joined
Sat Jun 23, 2007 9:16 pm
Top

Re: [àèìòù] Character problem in product description

Quote

Post by JNeuhoff » Mon Jan 19, 2009 3:02 am

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.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7456
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: [àèìòù] Character problem in product description

Quote

Post by Nightmare » Mon Jan 19, 2009 3:06 am

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
Nightmare
Newbie
Posts
9
Joined
Sat Jun 23, 2007 9:16 pm
Top

Re: [àèìòù] Character problem in product description

Quote

Post by Qphoria » Mon Jan 19, 2009 12:55 pm

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

Image

User avatar
Qphoria
Administrator
Posts
20056
Joined
Tue Jul 22, 2008 3:02 am
Top

Re: [àèìòù] Character problem in product description

Quote

Post by Nightmare » Fri Jan 23, 2009 8:30 am

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!
Nightmare
Newbie
Posts
9
Joined
Sat Jun 23, 2007 9:16 pm
Top
Locked
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 8 guests