[Bug 58079] New: AppDB: Potential problems with printing (non-ASCII?) characters.

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=58079

Bug ID: 58079
           Summary: AppDB: Potential problems with printing (non-ASCII?)
                    characters.
           Product: WineHQ Apps Database
           Version: unspecified
          Hardware: x86-64
               URL: https://appdb.winehq.org/objectManager.php?sClass=vers
                    ion&iId=2739
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P2
         Component: appdb-unknown
          Assignee: [e-mail]
          Reporter: [e-mail]
      Distribution: Gentoo

There might be some issues regarding character encoding, or something that
happened during a conversion of sorts, but probably not during the PHP8 upgrade
since going by archive org, this seems to have started between 2024-03-03 and
2024-05-19, which seems a bit too long ago for that.

See for example one of the maintainer names here, where an 'é' renders as '�':

https://appdb.winehq.org/objectManager.php?sClass=version&iId=2739

Not sure if there is really anything that can be done, aside from re-entering
such characters somewhere...

Thank you!

[Bug 58079] AppDB: Potential problems with printing (non-ASCII?) characters.

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=58079

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #1 from Ken Sharp  ---
Confirming. Will have a look.

[Bug 58079] AppDB: Potential problems with printing (non-ASCII?) characters.

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=58079

Jeremy Newman  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #2 from Jeremy Newman  ---
All tables should be converted to utf8mb4. Many columns are still in
latin1_swedish_ci, and others are in mb3;

For example, we need to do a process like this on the tables:

ALTER TABLE <TABLE> CONVERT TO CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci; ALTER TABLE <TABLE> CHARACTER SET utf8mb4;

Once this is done, things should work better with character sets.

[Bug 58079] AppDB: Potential problems with printing (non-ASCII?) characters.

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=58079

--- Comment #3 from Jeremy Newman  ---
All tables and columns have been converted over to utf8mb4. This doesn't fix
the existing corrupt characters, but makes it possible to clean it up
consistently going forward.

I manually fixed the é character on that users name on the link specified
above.

[Bug 58079] AppDB: Potential problems with printing (non-ASCII?) characters.

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=58079

Chiitoo  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #4 from Chiitoo  ---
Indeed, looks good so far.

I suppose this one can be called fixed.

Thank you!

[Bug 58079] AppDB: Potential problems with printing (non-ASCII?) characters.

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=58079

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #5 from Ken Sharp  ---
*** Bug 47893 has been marked as a duplicate of this bug. ***