Category Name doesn't support UTF-8 unicode

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 03-26-2009, 03:23 PM
New Pligger
Pligg Version: 1.0.0
 
Join Date: May 2008
Location: iran
Posts: 24
Send a message via Yahoo to kariminejad
in pligg 1.0.0 RC3 when i create a category in farsi language , system display ?????? for mine category name
Reply With Quote
  #2 (permalink)  
Old 03-26-2009, 03:32 PM
Yankidank's Avatar
Pligg Founder/Coder/Designer
Pligg Version: SVN
Pligg Template: Wistie
 
Join Date: Dec 2005
Location: Ocala, FL
Posts: 4,934
Send a message via AIM to Yankidank
Could you give us an example for what the category name is? It would be helpful if you listed what characters aren't working.

The Twitter Module for Pligg CMS!
Register, Login, and Submit Stories with Twitter. An absolute MUST HAVE for all Pligg sites!
Reply With Quote
  #3 (permalink)  
Old 03-27-2009, 07:44 AM
New Pligger
Pligg Version: 1.0.0
 
Join Date: May 2008
Location: iran
Posts: 24
Send a message via Yahoo to kariminejad
hi eric, thanks for reply
i have two screenshot of category management page that show unicode character after updating category name

http://www.freeimagehosting.net/uploads/4e111eb416.png
http://www.freeimagehosting.net/uploads/782357c366.png

unfortunately pligg 1.0.0 rc3 doesn't support unicode languages in some other sections for example
submit_step_3 or link_summary
see another screenshot here
http://www.freeimagehosting.net/uploads/3c5ab3d396.png

note: pligg1.0.0 RC1 And RC2 don't have these problems
Reply With Quote
  #4 (permalink)  
Old 03-27-2009, 07:59 AM
New Pligger
Pligg Version: 1.0.0
 
Join Date: May 2008
Location: iran
Posts: 24
Send a message via Yahoo to kariminejad
got this error when submitting an article in submit step 3

Warning: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' in D:\xampplite\htdocs\Pligg100RC3\libs\db.php on line 241
Reply With Quote
  #5 (permalink)  
Old 03-27-2009, 09:54 AM
Pligg Developer
Pligg Version: SVN
Pligg Template: Wistie
 
Join Date: Aug 2008
Location: Russia
Posts: 58
Hi,
did you run /install/upgrade.php after you move to rc3? If so, could you please dump structure of your pligg database and post here a link to it?
Reply With Quote
  #6 (permalink)  
Old 03-27-2009, 11:38 AM
New Pligger
Pligg Version: 1.0.0
 
Join Date: May 2008
Location: iran
Posts: 24
Send a message via Yahoo to kariminejad
Hoooooooray!
found cause of problems with unicode characters

I removed three lines from libs/db.php on line 100 to 103

mysql_query( 'set names utf8' );
mysql_query ("set character_set_client='utf8'");
mysql_query ("set character_set_results='utf8'");

who added on db.php after pligg 1.0.0RC3 release, after removing these three lines, I can submit category and story in mine language to pligg site

thank you pliggers for your great cms
Reply With Quote
Reply

Tags
unicode

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Control of meta description - categories Divisive Cotton Questions and Comments 71 03-29-2011 10:03 PM
Pligg Categories Yankidank Wiki Articles 1 12-17-2008 11:10 AM
How to show category keywords as text on the site? gnalkit Questions and Comments 4 11-26-2008 06:17 AM
Large numbers of category support swissbob2 Questions and Comments 5 10-25-2007 11:31 AM
Unicode / Complex Language Support visu Questions and Comments 3 07-07-2007 02:02 AM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development