• Status Closed
  • Percent Complete
  • Task Type Bug Report
  • Category Database Queries
  • Assigned To No-one
  • Operating System Linux
  • Severity Low
  • Priority Very Low
  • Reported Version 1.0-rc
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Flyspray
Opened by vrobolab - 10.02.2017
Last edited by peterdd - 11.02.2017

FS#2340 - tables created with charset = latin1 during the installation

Somewhy database tables are created with “CHARSET=latin1” during the installation thus creating records with UTF8 symbols (e.g. description written in russian language) fail.

I was scared by .xml installation files so I did not touch them and fixed the issue after the installation instead:

$ mysqldump -uuser -ppassword database > database.sql;
$ cat database.sql | sed 's/CHARSET=latin1/CHARSET=utf8/g' > database_new.sql;
$ mysql -uuser -ppassword database < database_new.sql;
Closed by  peterdd
11.02.2017 08:05
Reason for closing:  Not a bug
Project Manager

Which version of MySQL do you have?
Which version of ADOdb? (vendor/adodb/adodb-php/)
Do you choosed 'mysqli' during setup?

I thought I fixed it with this in 2015:

Or when you create the database before the browser guided install:


I think that if the database is created with utf8 charset options, then the created tables and fields are automatic using utf8.

Maybe your Mysql server has latin1 as default charset and you created the flyspray database by hand (or with phpmyadmin) without adding that explicit charset option?

Sorry, my bad.

mysql> show variables like "%char%";
| Variable_name            | Value                               |
| character_set_client     | utf8                                |
| character_set_connection | utf8                                |
| character_set_database   | latin1                              |
| character_set_filesystem | binary                              |
| character_set_results    | utf8                                |
| character_set_server     | latin1                              |
| character_set_system     | utf8                                |
| character_sets_dir       | /usr/share/percona-server/charsets/ |
8 rows in set (0.00 sec)

I'm using Percona XtraDB server version 5.5, it uses latin1 by default and I have created the database without explicitly specifying the charset.


Available keyboard shortcuts


Task Details

Task Editing