Arabic issues

Added by Omar Shaker 7 days ago


I am using 3.4.3

I have issues when using arabic, log result:

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xD9\x82\xD9\x8A\xD8\xBA...' for column 'notes' at row 1: INSERT INTO `journals` (`journalized_id`, `journalized_type`, `user_id`, `notes`, `created_on`) VALUES (28, 'Issue', 6, 'قيغايفقت', '2018-01-13 15:26:00')):
app/models/journal.rb:82:in `save'
app/models/issue.rb:1839:in `create_journal'
app/models/issue.rb:210:in `create_or_update'
app/controllers/issues_controller.rb:558:in `block in save_issue_with_child_records'
app/controllers/issues_controller.rb:546:in `save_issue_with_child_records'
app/controllers/issues_controller.rb:168:in `update'
lib/redmine/sudo_mode.rb:63:in `sudo_mode'

I did this, but still unable to solve the issue:

SELECT CONCAT('ALTER TABLE ', tbl.TABLE_SCHEMA, '.', tbl.TABLE_NAME, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') FROM information_schema.TABLES tbl WHERE tbl.TABLE_SCHEMA = 'redmine';