Shulou(Shulou.com)06/02 Report--

The management login system suddenly found the following warning:

I have not been in contact with the JIRA system before I have not used MYSQL installation, I still need to follow the tutorial step by step.

Follow the prompts to go to the official website for problem solving guidance links:

Https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html

PS: here are 32 likes to be translated for the web page of Google Chrome browser:

There is nothing wrong with the overall translation, even if you don't know English-666!

Change the sort of table

The following query generates a series of ALTER TABLE statements that you must then run against the database.

Executing the following statement will generate an ALTER TABLE statement. The table collation has not actually been modified, but it just gives you a list of what statements need to be executed before they will be modified. The sample figure is as follows:

| | ALTER TABLE ao_21d670_whitelist_rules CHARACTER SET utf8 COLLATE utf8_bin; |

PS: I execute the statements in the navicat For MySQL tool, so the generated ALTER TABLE results can be copied directly to the "|" at the beginning and end, and then execute the sentences in batches; repeat this operation until the query results do not appear.

As shown below:

Go back to the JIRA system to see the repair results.

This article is only for users who are new to JIRA and MySQL for reference.

The following is the specific query statement of the official website. Change the yourDB to suit your database name: change the table to sort the following query will generate a series of ALTER TABLE statements, and then you must run the statement against the database. Change yourDB to suit 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 (one varchar column for columns and one varchar column for non-columns) generates a series of ALTER TABLE statements that you must run against the database. Change yourDB to suit your database name: ````SELECT CONCAT ('ALTER TABLE `, table_name,' MODIFY`, column_name,'`, DATA_TYPE,'(', CHARACTER_MAXIMUM_LENGTH,') CHARACTER SET UTF8 COLLATE utf8_bin', (CASE WHEN 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 WHEN 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'); ```

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.