After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 616100 - Incorrect character set used in MySQL backend
Incorrect character set used in MySQL backend
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.3.x
Other Windows
: Normal normal
: ---
Assigned To: Phil Longstaff
Chris Shoemaker
Depends on:
Blocks:
 
 
Reported: 2010-04-18 14:50 UTC by Søren Løvborg
Modified: 2018-06-29 22:38 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Søren Løvborg 2010-04-18 14:50:34 UTC
(This may be related to #559772, but I'm not sure; the bug description is too vague.)

First of all, a big "thank you" to all GnuCash developers. I am especially hyped about the new SQL backend, which opens up a whole new range of possibilites with GnuCash.

My problem has to do with how non-ASCII characters are stored in a MySQL backend. It seems like a familiar problem, namely that application (GnuCash) uses UTF-8 internally, while the MySQL connection character set is set to Latin-1.

If this is the case, one solution is to execute
 SET NAMES "utf8";
after connecting to the MySQL backend. I believe the mysql_set_character_set() function may be used to the same effect.

Note that this will cause encoding problems for people who upgrade from previous versions of GnuCash.
Comment 1 Geert Janssens 2010-10-04 17:07:12 UTC
@Phill: You have committed r19200 regarding this bug. That commit first appeared in GnuCash 2.3.13. Is there a reason this bug is still open ?
Comment 2 Christian Stimming 2010-10-25 07:12:55 UTC
In other words, is this still a problem in 2.3.15?
Comment 3 Søren Løvborg 2010-10-25 14:19:58 UTC
I can confirm that the bug is fixed in GnuCash 2.3.15.
Comment 4 Geert Janssens 2010-10-25 15:03:40 UTC
Thanks for your feedback. I'll close the report then.
Comment 5 John Ralls 2018-06-29 22:38:00 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=616100. Please update any external references or bookmarks.