Passwords for MySQL

John Ralls jralls at ceridwen.us
Thu Dec 31 12:54:32 EST 2015


> On Dec 31, 2015, at 9:17 AM, aeneas <receiver at gowdygroup.net> wrote:
> 
> John, your reply has provoked another thought.
> 
> I created a MySQL database for experimentation purposes on my own computer
> even though I foresee use of MySQL on my hosting service as one big reason
> for using MySQL which carries with it a reason for using GNUcash.
> 
> When I created the schema, for GNUcash, using phpMyAdmin on my own, xampp,
> system it allows for specifying collation.  I opted for utf8_unicode_ci for
> no particular reason other than believing (?) this to be fairly benign. 
> When I go back and look at the DB created by GNUcash I notice that all of
> the tables have latin1_swedish_ci as the collation.  There was never
> anywhere for me to specify a preferred collation within GNUcash. 
> Furthermore, I also notice that the phpMyAdmin on my hosting service
> indicates that the server connection is using utf8_general_ci.  What is the
> rationale for GNUcash to use latin1_swedish_ci?  Is this universal or do I
> just need to know how to manipulate the setting?  Possibly you know, better
> than I, why this either may or may not matter.

It's the default for MySQL. GnuCash sets the character set but not the collation. I don't think that it actually matters; most of the primary keys are GUIDs and therefor in the character range A-F0-9, which will sort the same for either. If it really bugs you, change the default for the server: https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_collation_database

Regards,
John Ralls




More information about the gnucash-user mailing list