By joel_guesclin on

Further to a previous post on the subject, I have the following remark concerning the display of "funny characters" (in this particular case the left and right apostrophes). Having just upgraded an English language site to 4.7.4 - successfully apparently - I find that a title with these characters in it (which is the title of an article in a book) does not always display correctly.
In order to simplify testing issues, I've switched the theme to the vanilla "Bluemarine" theme, and here is what I observe.

  • standard "node" view (ie list of nodes on front page): ok
  • title when displaying complete node: ok
  • link to previous article in book: not ok
  • title of node within list of book titles: not ok
  • title displayed in Views module List view: not ok

I'm not sure what conclusions to draw from this - but it worries me, because it makes me wonder what I will find when I convert an non-English site like French, or worse, Bengali. Is it a bug in the software, or a problem in the conversion? Any answers would be welcome!

⋅ Categories: Drupal 4.7.x

Comments

cog.rusty’s picture

cog.rusty commented

I haven't heard of any differences between 4.7.4 and previous versions regarding character handling. It must have to do with backup/upload.

Have you checked your previous and current database tables in phpMyAdmin to see if some have different default character set and/or collation settings?

sl27257’s picture

sl27257
Location Stockholm
commented

If you are upgrading from 4.6 to 4.7 all tables with characters need to be updated. I am in the middle of upgrading two sites from the 4.6 branch to the 4.7 branch and figured out that all of my own written modules needs to be converted to UTF-8 tables. If not I get funny characters. If you are only downloading modules they ***should*** take care of this when you run the update script...

http://drupal.org/node/22218#utf8_sql

http://yourdrupalsite.org//update.php

--
Thomas

--
Thomas

joel_guesclin’s picture

joel_guesclin commented

I am indeed upgrading from 4.6 - and the upgrade process does seem to have successfully converted all the tables to UTF-8.
The odd thing is that sometimes it looks ok, sometimes not. When the node is displayed in complete, the title appears fine, but when it appears in a list (for example the title displayed in its parent book), then it is not ok