Zikula Community

• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 04, 2011 - 07:47 AM

  I installed the Web 2.0 theme and for some reason, some of the characters (apostrophes, hyphens, quotation marks, etc.) are appearing as small boxes with question marks in them. I have checked in MySQL and the language setting is correct (utf8_general_ci). It appears that it's only happening with certain characters... � but not ", � but not ', etc. Any idea what I can do to fix this issue?
  I'm using Zikula 1.2.7, MySQL 5.0.91-log, phpMyAdmin 2.8.0.1.
  I'm going to wait until the stable version of 1.3.0 is released before upgrading further.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 10, 2011 - 09:27 AM

  *Bump* Anyone?
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• pnFilip
  
  

  • Rank: Softmore
  • Registered: Jan 24, 2006
  • Last visit: Apr 19, 2010
  • Posts: 150

  Posted: Jul 10, 2011 - 10:10 PM

  Hi, your DB uses UTF8, does this match the browser settings (Firefox: View->Character Encoding) and your page headers?
  

  Code

  meta charset="utf-8"

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 11, 2011 - 01:58 PM

  I checked Character Encoding and it's UTF-8. I also checked the page headers and it's UTF-8
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• tfotis
  
  

  • Rank: Team Member
  • Registered: Dec 17, 2009
  • Last visit: Apr 06, 2010
  • Posts: 61

  Posted: Jul 11, 2011 - 10:03 PM

  Do these character appear correctly when using phpMyAdmin?
  Also, do your files use UTF-8 encoding?

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 12, 2011 - 07:45 AM

  I checked and the characters are appearing correctly in the individual entries in phpMyAdmin. Under the Collation column, they all say "utf8_general_ci" but at the bottom where it shows the total number of tables and database size, it says "latin1_swedish_ci".
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• tfotis
  
  

  • Rank: Team Member
  • Registered: Dec 17, 2009
  • Last visit: Apr 06, 2010
  • Posts: 61

  Posted: Jul 12, 2011 - 10:23 PM

  In phpMyAdmin, do this:
  1) Select your database
  2) Click on 'Operations' link at the top of the page
  3) change latin1_swedish_ci to utf8_general_ci
  4) press 'Go' to save the changes

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 13, 2011 - 05:31 AM

  Woo Hoo! It worked. Thanks for your help. I knew it was going to be something simple.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 13, 2011 - 07:01 AM

  Oops... spoke too soon... Changed it to utf8_general_ci and the characters in PostCalender show up properly but now they aren't showing up properly in News.
  Quotes show up as “ and ” and apostrophes show up as ’... I changed it to latin_general_ci and I'm back to where I started from but things are showing up correctly in News again. I tried changing it to latin_general_ci in the zk_postcalendar_events table but that didn't work.
  Anyone have any other suggestions?
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Jul 13, 2011 - 07:08 AM

  I don't have a solution but be care swapping encodings,
  I'm afraid that you can get corrupted data at the end :s
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 13, 2011 - 07:32 AM

  I double checked after I did it and everything's fine (relatively speaking). I'll keep looking.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• tfotis
  
  

  • Rank: Team Member
  • Registered: Dec 17, 2009
  • Last visit: Apr 06, 2010
  • Posts: 61

  Posted: Jul 13, 2011 - 07:49 PM

  My suggestion is to export your data (only data, not structure) with phpMyAdmin, then truncate the data, then change the encoding of the database to utf8_general_ci and then import your data again.
  This may do the trick.
  Just make sure that in the exported data SQL file, all is readable and there aren't any 'strange' characters.

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Jul 15, 2011 - 05:21 PM

  I was actually thinking of some sort of "Find and Replace" maneuver in phpMyAdmin. Unfortunately, I'm not entirely sure how to pull it off.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Last visit: May 21, 2010
  • Posts: 315

  Posted: Aug 05, 2011 - 11:35 AM

  Well, I freely admit when I'm an idiot... and this is one of those times. I was looking at my site in Chrome and I decided to check "Fonts and Encoding" and it wasn't set to UTF8... I changed it and the characters show up fine...
  Thanks for all your help anyway.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
•  
•  

Users on-line

• 0 users

This list is based on users active over the last 60 minutes.