utf8

nikosb · September 18th, 2011, 01:41 PM

Hello

When creating a new ad in
Description
some greek characters shows them wrong
eg
ς = &si gmaf;

how to fix it?

thanks
Nikos

Chuck S · September 18th, 2011, 01:57 PM

You can set your language encoding in the language administration in admin. By default classifieds is packaged with english and utf-8 encoding.

If you want me to comment about a specific thing I would need alot more information.

KrUsTyX · October 17th, 2011, 03:12 PM

I have the same problems, it seems that whatever we put in language administration in admin doesnt work.

All my é and è are not showed properly.

KrUsTyX · October 17th, 2011, 03:19 PM

And its funny that all the characters are showing properly in the admin panel, but not when browsing the ads

Chuck S · October 17th, 2011, 03:54 PM

If your language encoding is set correct to display the information it should be fine. what language are you using?

KrUsTyX · October 17th, 2011, 05:22 PM

Quote:

Originally Posted by Chuck S

If your language encoding is set correct to display the information it should be fine. what language are you using?

french for me... i've used FR

Chuck S · October 17th, 2011, 05:32 PM

FR is not a valid charset encoding.

I use UTF-8

J'essaie la langue française et voyant ce que peut être fait - PhotoPost Classifieds

You would have to provide more info and what actual version of the software you have. The application we release is only in english so I can only guess without info.

KrUsTyX · October 17th, 2011, 06:04 PM

i have the latest version that i've downloaded yesterday.

I had a previous version, but i started from scratch since i stopped using the app for a year.

Try using that sentence

"Cette tour est très élevée"

Chuck S · October 17th, 2011, 07:16 PM

works fine. I am using the default classifieds code and language as downloaded from our site.

Maybe your database is not set to utf-8 collation? Maybe your language encoding is not correct.

Just a guess there since I do not have specific site info but as you can see I am using the default code and language.

KrUsTyX · October 17th, 2011, 09:08 PM

It worked

ALTER DATABASE MyDb CHARACTER SET utf8;

and for each table that was not utf8

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Thru phpmyadmin

Chuck S · October 17th, 2011, 09:50 PM

Our install script creates utf8 tables but I suppose your mysql is setup to some other encoding.
You might want to make sure you change your default mysql encoding to utf8 so that all future database things you do are utf8 so it supports multiple languages.

KrUsTyX · October 18th, 2011, 05:57 AM

Quote:

Originally Posted by Chuck S

Our install script creates utf8 tables but I suppose your mysql is setup to some other encoding.
You might want to make sure you change your default mysql encoding to utf8 so that all future database things you do are utf8 so it supports multiple languages.

the database wa created maybe 2 years ago, was it like that back then? utf8?

Chuck S · October 18th, 2011, 06:57 AM

No I am referring to present code not old code