Problems with charset

[Joaquim]

Hi,

I've read everything I could find. I've tried everything I was advised to. But I still can't get the character set right. I believe I only have to change one file and I've done that. I must get the letters like á, ã ú and so on, to show properly. I'd like to know if there is someone who has solved this problem.

 

Thank you very much

[Xpajun]

Hi Joaquim,

 

I'm going to assume that you are using 2.3.1 for your store. 2.3.1 utilises utf-8 for character coding within it's files this is set in includes/languages/your_language.php.

 

 

The problem you are encountering is possibly caused by your database having a incorrect collation - for some reason web hosts seem to have a default collation of latin_swedish rather than utf-8

 

changing the database involves exporting the database opening in in your plain text editor and changing all instances of:

 

DEFAULT CHARSET=latin1

 

to:

 

DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

 

And saving

 

Now go back to your database and delete it

 

Create a new database with the same name as you just deleted but make sure it has utf8_unicode_ci collation

 

Import your updated database

[Joaquim]

Hi Joaquim,

 

I'm going to assume that you are using 2.3.1 for your store. 2.3.1 utilises utf-8 for character coding within it's files this is set in includes/languages/your_language.php.

 

 

The problem you are encountering is possibly caused by your database having a incorrect collation - for some reason web hosts seem to have a default collation of latin_swedish rather than utf-8

 

changing the database involves exporting the database opening in in your plain text editor and changing all instances of:

 

DEFAULT CHARSET=latin1

 

to:

 

DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

 

And saving

 

Now go back to your database and delete it

 

Create a new database with the same name as you just deleted but make sure it has utf8_unicode_ci collation

 

Import your updated database

 

 

Hi,

I'm not reading portuguese characteres from the database (yet). It's only the translation of the site to portuguese. You can check it out here www.troca.com.pt. I'm still in the phase of seting up the store.

 

Thanks