| ascii_general_ci | US ASCII | 1 | 6. | binary | binary | Binary pseudo charset | 1 | 7. | latin1 | latin1_swedish_ci | cp1252 West European | 1 | 8. | utf8 | utf8_general_ci | UTF-8 Unicode | 3 | 9. | utf8mb4 | utf8mb4_general_ci | UTF-8 Unicode | 4 | 10. +-------------- ----+ 5. | latin1_german1_ci | latin1 | 5 | | Yes | 1 | 6. | latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 | 7. | latin1_danish_ci | latin1 | 15 |

collation is utf8mb4_bin. • MySQL 5.7’s default collation is utf8mb4_general_ci. 113 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010 sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster depending

collation is utf8mb4_bin. • MySQL 5.7’s default collation is utf8mb4_general_ci. 108 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010 sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster depending

@lcwangchao • Fix the issue that query results are incorrect due to STREAM_AGG() incorrectly handling CI #49902 @wshwsh12 • Fix the issue that encoding fails when converting bytes to TIME #47346 @wshwsh12 collation is utf8mb4_bin. • MySQL 5.7’s default collation is utf8mb4_general_ci. 93 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010

collation is utf8mb4_bin. • MySQL 5.7’s default collation is utf8mb4_general_ci. • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010 sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster depending

default character set is utf8mb4, and the default �→ collation of utf8mb4 is utf8mb4_0900_ai_ci. TiDB v7.4.0 �→ adding support for this enhances compatibility with MySQL 8.0 so that �→ migrations collation is utf8mb4_bin. • MySQL 5.7’s default collation is utf8mb4_general_ci. 80 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010

The default collation of utf8mb4 in MySQL 5.7 is utf8mb4_general_ci. • The default collation of utf8mb4 in MySQL 8.0 is utf8mb4_0900_ai_ci. • Default value of foreign_key_checks: • The default value in disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010 Rollback() error { defer tx.conn.Close() return tx.Tx.Rollback() } Change to the gorm directory: cd gorm The structure of this directory is as follows: . ￿── Makefile ￿── go.mod ￿── go.sum ￿── gorm

collation is utf8mb4_bin. • MySQL 5.7’s default collation is utf8mb4_general_ci. • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010 sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster depending

collation is utf8mb4_bin. • MySQL 5.7’s default collation is utf8mb4_general_ci. • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: ONLY_FULL_GROUP_BY disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010 sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster depending

collation is utf8mb4_bin. • MySQL 5.7’s default collation is utf8mb4_general_ci. 108 • MySQL 8.0’s default collation is utf8mb4_0900_ai_ci. • Default SQL mode: • TiDB’s default SQL mode includes these modes: disk space. To download all files for years 2010-2017 using a bash script: mkdir -p bikeshare-data && cd bikeshare-data curl -L --remote-name-all https://s3.amazonaws.com/capitalbikeshare-data �→ /{2010 sample code reposi- tory: git clone https://github.com/tidb-samples/tidb-java-jdbc-quickstart.git cd tidb-java-jdbc-quickstart Step 2: Configure connection information Connect to your TiDB cluster depending