Management landing system suddenly found the following warning:
I haven't touched the Jira system before. mysql installation is also required to control the tutorial step-by-step operation.
Follow the prompts to access the official website Problem Resolution Guide Link:
Https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html
PS: Here to Google Chrome web page translation 32 likes:
Overall translation is no problem, do not know English can also--666!
Change Table Sort
The following query generates a series of ALTER TABLE statements, and then you must run the statement against the database.
The ALTER TABLE statement is generated by executing the following statement, and the table collation is not actually modified, except to give you a list of what statements need to be executed before they are modified. The sample image is as follows:
| ALTER TABLE ao_21d670_whitelist_rules CHARACTER SET utf8 COLLATE utf8_bin; |
PS: I execute the statement in the Navicat for MySQL tool, so the resulting alter table result can be copied directly to the again, bulk delete "|" At the beginning of the end. Repeat the sentence until the query results do not appear.
Such as:
Re-enter the Jira system to view the repair results.
This article is only for contact Jira and MySQL user reference.
The following is the official website query specific statements. Change Yourdb to fit your database name: ' ALTER DATABASE Yourdb CHARACTER SET UTF8 COLLATE utf8_bin ' change table sort the following query generates a series of ALTER table statements, Then you must run the statement against the database. Change the YOURDB to fit your database name: "' SELECT CONCAT (' ALTER TABLE ', table_name, ' CHARACTER SET utf8 COLLATE utf8_bin; ') From INFORMATION_SCHEMA. TABLES as T, Information_schema ' collation_character_set_applicability ' as cwhere c.collation_name = T.table_ Collationand T.table_schema = ' Yourdb ' and (c.character_set_name! = ' UTF8 ' OR c.collation_name! = ' Utf8_bin '); The following query (a varchar column for a column, a varchar column for a non-column) will generate a series of ALTER TABLE statements, and then you must run the statements against the database. Change the YOURDB to fit your database name: ' ' SELECT CONCAT (' ALTER TABLE ', table_name, ' MODIFY ', column_name, ' ', Data_type, ' (', characte R_maximum_length, ') CHARACTER SET UTF8 COLLATE utf8_bin ', (case is is_nullable = ' NO ' Then ' not NULL ' ELSE ' END), '; ') from INFORMATION_SCHEMA. COLUMNS WHERE table_schema = ' Yourdb ' and data_type = ' varchar ' and (character_set_name! = ' UTF8 ' OR collation_name ! = ' Utf8_bin '); "" SELECT CONCAT (' ALTER TABLE ', table_name, ' MODIFY ', column_name, ', data_type, ' CHARACTER SET UTF8 COLLATE utf8_bin ', (case I s_nullable = ' NO ' Then ' not NULL ' ELSE ' END), '; ') From INFORMATION_SCHEMA. COLUMNS WHERE table_schema = ' Yourdb ' and data_type! = ' varchar ' and (character_set_name! = ' UTF8 ' OR Collation_nam E! = ' Utf8_bin ');
Windows Jira for MySQL default sort alarm processing.