Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Language Characters


Wizbits

Recommended Posts

Posted

Hello

 

I wonder if anyone can help me.

 

My issue is how accents and other weird characters are displayed on my website www.wizbits.ca in Spanish, French or German (plus in admin).How do you fix this issue. I am using OSC 2.3.3.4 and I closely went over the changes between 2.3 clean install, taking particular care in the UTF-8 changes. The site shows okay if you display in Western European! GoDaddy hosts... MySQL Charset in PHPMyAdmin UTF-8 Unicode (utf8).

 

I did update my site from RC2.2r2 to 2.3 last year and don't remember an issues at that point although I could be wrong. Checking the Forums has not given me a definitive answer, Do I have to overwrite to correct?

 

 

 

Thanks

 

Andy

Posted

I see product description text with accented characters expanded into multiple accented characters, and I see the "Resources" box with invalid UTF-8 characters. Any others? As the pages are displayed in UTF-8, the most likely cause of the first problem is that you imported the backup of a UTF-8 database while forgetting to tell phpMyAdmin that the .sql file is UTF-8. It defaults to assuming it's Latin-1, and happily translates each byte of a multibyte UTF-8 character from Latin-1 to UTF-8 (doubling or tripling the number of bytes each time). Can you clear out the database, make sure it's UTF-8, and import the .sql again, this time being careful to tell phpMyAdmin that it's a UTF-8 backup?

 

As for the second problem, somehow those lines were done in Latin-1 or Windows-1252 and brought into the system without translating them to UTF-8. The single byte accented characters are invalid UTF-8. Do them over in UTF-8.

Posted

I had the same problem, please check your browser when you load a page it's maybe ISO 8859 instead off UTF-8. if this is your problem try to add the following code as first in /includes/application_top.php in catalog and admin dir.

<?php
header('Content-type: text/html; charset=utf-8');
?>

  • 2 weeks later...
Posted

So I fixed this...., almost!

 

My problem now lies in adding and saving a product description. Not sure what is going here.....

 

http://wizbits.ca/catalog/product_info.php?products_id=100 = Only saving "Conveniently store and transport your data on the easy-to-use Verbatim Store" instead of

 

Conveniently store and transport your data on the easy-to-use Verbatim Store ‘n’ Go USB Drive. Store everything from presentations to photos, video clips and music, all readily accessible on any computer! To protect your sensitive files utilize the built in password security feature. This new capless design has a handy write–on area for personalizing or identifying drive contents. Verbatim’s Store ‘n’ Go USB drive is enhanced for Windows ReadyBoost, allowing you to speed up your system’s performance on Vista equipped PC’s.

 

Also when comparing languages the same thing happens... why?

 

What am I missing?

 

Thanks

Andy

Posted

Where did that text come from? Did you copy and paste it from Word? If so, the apostrophes/single quotes ' are probably MS "Smart Quotes" and are not valid characters in either Latin-1/ISO-8859-1 or UTF-8. The usual result is that the text display is cut off at a Smart Quote. Never use Word (or Outlook) to edit/type in anything going into a Web page!!!!

Posted

I was using text directly from another website as a test.., seems to cut off at ' or -

Posted

Yes...... the text is Smart Quotes and is not valid in either Latin-1 or UTF-8. You will find they are bytes in the range x80 through x9F.

Posted

You are correct.., once I changed these items, everything worked okay...,

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...