Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Long date format (day / month) Latin Language, accent issue


Recommended Posts

See screen shot attached.



look for ways to correct this issue,


I am assuming this is derived from the db.


how to patch to work correctly?


note: my store is primarily in English.


my spanish pages are being served up with this in the header:


<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="es">


<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />





Can anyone point me in the right direction?


many thanks


Link to comment
Share on other sites

Are you asking how to set the character set?


in your language file in the languages folder:


define('CHARSET', 'iso-8859-1');


You may need to alter your dBase character set too.


In phpMyAdmin, use

set character set latin1



Remember, What you think I ment may not be what I thought I ment when I said it.




Auto Backup your Database, Easy way


Multi Images with Fancy Pop-ups, Easy way


Products in columns with multi buy etc etc


Disable any Category or Product, Easy way


Secure & Improve your account pages et al.

Link to comment
Share on other sites

my db is currently:


UTF-8 Unicode (utf8)

  • MySQL charset: UTF-8 Unicode (utf8)
  • MySQL connection collation "ADD THE LATIN ONE INSTEAD HERE"

so you mean change it like this:


will this have adverse efect on my db?


I think i must have the change the information_schema (25) ==> CHARACTER_SETS ==>


CHARACTER_SET_NAME varchar(64) utf8_general_ci

DEFAULT_COLLATE_NAME varchar(64) utf8_general_ci

DESCRIPTION varchar(60) utf8_general_ci


Please Clarify

Link to comment
Share on other sites

Is the "problem" that you see a ?-in-diamond "invalid character" marker on the page?


lang="Content-Type" is not correct in the <html> tag. How did it get there? I think you want lang="es" or lang="es-ES".


content="text/html; charset=utf-8" doesn't appear to be correct for the <html> tag. You want a separate <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> tag.

Link to comment
Share on other sites

That's telling osC that Latin-1 (ISO-8859-1) is in use for character encoding, while elsewhere you seem to be saying that UTF-8 is used for the page. The encodings should be consistent throughout the site, so be careful about mixing Latin-1 and UTF-8! The database, the language support files (e.g., espanol.php), and the page display encodings should all be the same.


If you took an espanol.php from elsewhere (say, version 2.2?), you can't simply change its declaration from Latin-1 to UTF-8 (or vice-versa). All the accented characters in the file will need to be changed from one encoding to the other. I'm sure there are tools to do this without having to manually edit the file. Some editors may be able to change the "save as" encoding.

Link to comment
Share on other sites


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

  • Create New...