Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-11432

Problem with utf-8 on windows with umlaut

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium Medium
    • None
    • 3.9.2
    • Misc
    • None
    • Operating System: Windows 2003 Server
      PHP Version: (please be specific, like '4.4.3' or '5.1.5'): 4.4.4
      Database and version: Mysql
      Browser (and version): Firefox 2.0.0.6

    Description

      eZ Publish has a problem while searching for a word containing a special character, e.g. with a german umlaut. The user gets a fatal error: database transaction error.

      The problem occures in the PHP-function "strtolower". Please see:
      http://www.sitepoint.com/blogs/2006/08/10/hot-php-utf-8-tips/

      In order to fix the problem without replacing all strtolower functions (mb_strtolower) the setlocale function with parameter LC_CTYPE, 'C' will help.

      We added the setlocale function in index.php.

      Steps to reproduce

      We searched a second time with a word with german umlaut. With this search we get the transaction error and the message:

      Query error: Duplicate entry 'seifenk' for key 2. Query: INSERT INTO
      ezsearch_search_phrase ( phrase, phrase_count, result_count )
      VALUES ( 'seifenk��rbchen', 1, 0 )

      Attachments

        Activity

          People

            unknown unknown
            3eaa9b9f-e9b8-4b9e-be6e-3c56f2303459@accounts.ibexa.co Daniel Jüdel
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: