[Tickets #7805] Re: Charset trouble when saving page names in db backend

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7805
------------------------------------------------------------------------------
  Ticket             | 7805
  Updated By         | lfbm.andamentos at gmail.com
  Summary            | Charset trouble when saving page names in db backend
  Queue              | Wicked
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


lfbm.andamentos at gmail.com (2008-12-30 01:10) wrote:

I did the tests. It makes no difference the charset defined for the  
field in the db.

I saved data in both situations (when charset for the page_name field  
is latin1_swedish_ci - the default - and when it is utf8_unicode_ci).

In any case, the data (page name) will be saved correctly only when  
using the patched sql.php.

But when using the patched sql.php, then a lot things break, like the  
inability to identify already created pages (which, by consequence - I  
think - breaks the identification of a renamed page during rename  
operation).

This shows why pages are not identified as already created:

http://img377.imageshack.us/img377/504/variablesbn0.jpg

Also, permissions get troubled, because page names are displayed incorrectly:

http://img367.imageshack.us/img367/6181/permsgn5.jpg