Changing my website to UTF-8

[omriamos]

Hello,

I have a working PhotoPost Classifieds for over a year+.
I am currently re-designing my website, and making it utf8 instead of Windows-1255 (same as ISO-8859-8) that it is right now.

So I need to upgrade PhotoPost Classifieds to use UTF-8 encoding.
This includes converting the current database, not simply "changing the meta tag" of course.


Please guide me on how can I make PhotoPost Classifieds work in UTF-8 encoding.



Thank you

[Chuck S]

Our current code can work with UTF. You would need to view your database and change the encoding on the tables to UTF8. I did attempt to do this on an upgrade but not all servers supported this so we removed it.

[omriamos]

Can you please give me the query for changing a table's encoding to UTF8 that will work with your software?
I see a lot of different encoding types, charactersets, etc..

Current data will be converted ?


Thanks

[Chuck S]

Changing MySQL default character sets to UTF-8 : DerekAllard.com

This should help

[omriamos]

Hi,

I have converted the data successfully to UTF-8 (using the "export, search-and-replace, import" method), and now the database and all the tables are configured to UTF-8 ("utf8_general_ci" Collation).

I can see from phpmyadmin that the data is fine, and works great while having my browser at Unicode UTF-8 encoding.

However, on the website itself - the data is corrupted and doesn't display well when the browser is in UTF-8 encoding.
I have cleaned the "cp_cache" table - didn't help.

Any ideas?

[Chuck S]

Hello

I dont really know what the way your conversion stuff you did does but I can tell you classiifeds 3.1 I released runs in UTF8 fine as seen here

Omegatron Classifieds - Main Index

You can download and install.

If you have corrupt data that might be a result of your conversions.

[omriamos]

Please read carefully again - the data is not corrupted.
It is only displayed wrong in classifieds.

p.s.
I'm using classifieds302.

[Chuck S]

well it would be nice to see an example

Classifieds 3.02 does not claim to support any language we did not support at the time which is english.

If you wish to truly support all languages I would suggest using 3.1 which does make that claim. I did alot of changes in 3.1 to support all major languages regardless of whether we support the language pack or not. In fact 3.1 has the ability to create your own language translations and phrases.

[omriamos]

I have fixed this by adding this line:

ppmysql_query("set names 'utf8'", $link);

To the 'pp-inc.php' file, right after the mysql_connect - before these lines:

// Let's get all our settings....
$getsets = ppmysql_query("SELECT varname,setting FROM {$pp_db_prefix}settings", $link);

It is now working fine

[Chuck S]

Yep as noted upgrading to 3.1 would help

[omriamos]

yeah, but I have a very customized template (completely designed main page) and no time to re-customize it for the new version..
Hopefully in the future..

[Chuck S]

Have a good one. You might want to think about it though.

Photopost Classifieds 3.1 Released - 3-18-2009

[Geiri]

This might help
Turning MySQL data in latin1 to utf8 utf-8 - O'Reilly ONLamp Blog

I have been having some trouble with utf-8 and Icelandic.
It seams to me that if the table contend is not writen in utf-8 in the begining the end in carbage.

[Geiri]

Originally Posted by Chuck S

Changing MySQL default character sets to UTF-8 : DerekAllard.com

This should help

Sorry Chuck I did not check out your post before I posted the link

I see it's in there

[Chuck S]

Yes I did post a LINK.