PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Classifieds How do I...? (http://www.photopost.com/forum/classifieds-how-do-i/)
-   -   utf8 (http://www.photopost.com/forum/classifieds-how-do-i/146519-utf8.html)

nikosb September 18th, 2011 01:41 PM

utf8
 
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 (Post 1292408)
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 (Post 1292425)
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


All times are GMT -5. The time now is 11:51 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97