After upgrade from 2.18.1 to 2.22 special characters are scrambled - Mozilla

This is a discussion on After upgrade from 2.18.1 to 2.22 special characters are scrambled - Mozilla ; Hi, all special characters in old bugs entered in 2.18.1 are broken in 2.22. Special characters are German Umlaute like I can enter new bugs, containing special characters and they are displayed correctly. Is this a database issue? We ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: After upgrade from 2.18.1 to 2.22 special characters are scrambled

  1. After upgrade from 2.18.1 to 2.22 special characters are scrambled

    Hi,

    all special characters in old bugs entered in 2.18.1 are broken in
    2.22. Special characters are German Umlaute like

    I can enter new bugs, containing special characters and they are
    displayed correctly.
    Is this a database issue? We are using mySQL 4.0.23-nt

    The UTF8-parameter is switched off but if I switch it on, it has no
    effect.

    Thanks and regards
    Hans Lesmeister


  2. Re: After upgrade from 2.18.1 to 2.22 special characters are scrambled

    Hans,

    15 Jun 2006 06:11:14 -0700, Hans :
    > all special characters in old bugs entered in 2.18.1 are broken in
    > 2.22. Special characters are German Umlaute like
    >
    > I can enter new bugs, containing special characters and they are
    > displayed correctly.
    > Is this a database issue? We are using mySQL 4.0.23-nt
    >
    > The UTF8-parameter is switched off but if I switch it on, it has no
    > effect.


    did you take care that your 2.18.1 installation enforces a character
    set encoding, as specified on
    http://www.bugzilla.org/docs/2.18/ht...bugzilla.html? (If
    not, we'll optimistically assume your users' browsers behaved as if
    you enforced ISO-8859-1.)

    Best solution: convert your database contents from this character set
    encoding to UTF-8. (Export your database contents, convert the dump
    (but not attachment data), re-import. Or, modify the character set
    encoding conversion script on
    https://bugzilla.mozilla.org/show_bug.cgi?id=280633 so that it works
    for 2.22, understand the -doit parameter, and use it.)

    Quick-and-dirty solution: in Bugzilla/CGI.pm, replace the line
    "$self->charset(Param('utf8') ? 'UTF-8' : '');" by
    "$self->charset('');" where is
    the character set encoding you enforced with your 2.18.1 installation.
    You'll need to do the full conversion sooner or later anyway, though.

    Kind regards
    Marc

    --
    http://wurblzap.net/
    Bugzilla hosting and professional support

+ Reply to Thread