innodb_charset.result
来自「这个文件是windows mysql源码」· RESULT 代码 · 共 8,379 行 · 第 1/5 页
RESULT
8,379 行
F4 1FA 1FB 1A7 1AF 1AC 1AB 1F3 1A8 1DROP TABLE IF EXISTS test.t1;DROP TABLE IF EXISTS test.t1;SET NAMES cp852;CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET cp852 COLLATE cp852_bin) ENGINE=InnoDB CHARACTER SET cp852 COLLATE cp852_bin;SHOW TABLE STATUS LIKE 't1';Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Commentt1 InnoDB # # # # # # # # # # # # cp852_bin # # #SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);a_ascii a_len21 122 123 124 125 126 127 128 129 12A 12B 12C 12D 12E 12F 130 131 132 133 134 135 136 137 138 139 13A 13B 13C 13D 13E 13F 140 141 142 143 144 145 146 147 148 149 14A 14B 14C 14D 14E 14F 150 151 152 153 154 155 156 157 158 159 15A 15B 15C 15D 15E 15F 160 161 162 163 164 165 166 167 168 169 16A 16B 16C 16D 16E 16F 170 171 172 173 174 175 176 177 178 179 17A 17B 17C 17D 17E 17F 180 181 182 183 184 185 186 187 188 189 18A 18B 18C 18D 18E 18F 190 191 192 193 194 195 196 197 198 199 19A 19B 19C 19D 19E 19F 1A0 1A1 1A2 1A3 1A4 1A5 1A6 1A7 1A8 1A9 1AA 1AB 1AC 1AD 1AE 1AF 1B0 1B1 1B2 1B3 1B4 1B5 1B6 1B7 1B8 1B9 1BA 1BB 1BC 1BD 1BE 1BF 1C0 1C1 1C2 1C3 1C4 1C5 1C6 1C7 1C8 1C9 1CA 1CB 1CC 1CD 1CE 1CF 1D0 1D1 1D2 1D3 1D4 1D5 1D6 1D7 1D8 1D9 1DA 1DB 1DC 1DD 1DE 1DF 1E0 1E1 1E2 1E3 1E4 1E5 1E6 1E7 1E8 1E9 1EA 1EB 1EC 1ED 1EE 1EF 1F0 1F1 1F2 1F3 1F4 1F5 1F6 1F7 1F8 1F9 1FA 1FB 1FC 1FD 1DROP TABLE IF EXISTS test.t1;DROP TABLE IF EXISTS test.t1;SET NAMES cp852;CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET cp852 COLLATE cp852_general_ci) ENGINE=InnoDB CHARACTER SET cp852 COLLATE cp852_general_ci;SHOW TABLE STATUS LIKE 't1';Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Commentt1 InnoDB # # # # # # # # # # # # cp852_general_ci # # #SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);a_ascii a_len21 122 123 124 125 126 127 128 129 12A 12B 12C 12D 12E 12F 130 131 132 133 134 135 136 137 138 139 13A 13B 13C 13D 13E 13F 140 141 161 183 184 18E 1A0 1A4 1A5 1B5 1B6 1C6 1C7 142 162 143 163 180 186 187 18F 19F 1AC 144 164 1D0 1D1 1D2 1D4 145 165 182 189 190 1A8 1A9 1B7 1D3 1D8 146 166 147 167 148 168 149 169 18C 1A1 1D6 1D7 14A 16A 14B 16B 14C 16C 188 191 192 195 196 19D 14D 16D 14E 16E 1D5 1E3 1E4 1E5 14F 16F 18A 18B 193 194 199 1A2 1E0 1E2 150 170 151 171 152 172 1E8 1EA 1FC 1FD 153 173 197 198 1AD 1B8 1E6 1E7 1E1 154 174 19B 19C 1DD 1EE 155 175 181 185 19A 1A3 1DE 1E9 1EB 1FB 156 176 157 177 158 178 159 179 1EC 1ED 15A 17A 18D 1A6 1A7 1AB 1BD 1BE 15B 15C 15D 15E 15F 160 17B 17C 17D 17E 17F 19E 1AA 1AE 1AF 1B0 1B1 1B2 1B3 1B4 1B9 1BA 1BB 1BC 1BF 1C0 1C1 1C2 1C3 1C4 1C5 1C8 1C9 1CA 1CB 1CC 1CD 1CE 1CF 1D9 1DA 1DB 1DC 1DF 1EF 1F0 1F1 1F2 1F3 1F4 1F5 1F6 1F7 1F8 1F9 1FA 1DROP TABLE IF EXISTS test.t1;DROP TABLE IF EXISTS test.t1;SET NAMES cp866;CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET cp866 COLLATE cp866_bin) ENGINE=InnoDB CHARACTER SET cp866 COLLATE cp866_bin;SHOW TABLE STATUS LIKE 't1';Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Commentt1 InnoDB # # # # # # # # # # # # cp866_bin # # #SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);a_ascii a_len21 122 123 124 125 126 127 128 129 12A 12B 12C 12D 12E 12F 130 131 132 133 134 135 136 137 138 139 13A 13B 13C 13D 13E 13F 140 141 142 143 144 145 146 147 148 149 14A 14B 14C 14D 14E 14F 150 151 152 153 154 155 156 157 158 159 15A 15B 15C 15D 15E 15F 160 161 162 163 164 165 166 167 168 169 16A 16B 16C 16D 16E 16F 170 171 172 173 174 175 176 177 178 179 17A 17B 17C 17D 17E 17F 180 181 182 183 184 185 186 187 188 189 18A 18B 18C 18D 18E 18F 190 191 192 193 194 195 196 197 198 199 19A 19B 19C 19D 19E 19F 1A0 1A1 1A2 1A3 1A4 1A5 1A6 1A7 1A8 1A9 1AA 1AB 1AC 1AD 1AE 1AF 1B0 1B1 1B2 1B3 1B4 1B5 1B6 1B7 1B8 1B9 1BA 1BB 1BC 1BD 1BE 1BF 1C0 1C1 1C2 1C3 1C4 1C5 1C6 1C7 1C8 1C9 1CA 1CB 1CC 1CD 1CE 1CF 1D0 1D1 1D2 1D3 1D4 1D5 1D6 1D7 1D8 1D9 1DA 1DB 1DC 1DD 1DE 1DF 1E0 1E1 1E2 1E3 1E4 1E5 1E6 1E7 1E8 1E9 1EA 1EB 1EC 1ED 1EE 1EF 1F0 1F1 1F2 1F3 1F4 1F5 1F6 1F7 1F8 1F9 1FA 1FB 1FC 1FD 1DROP TABLE IF EXISTS test.t1;DROP TABLE IF EXISTS test.t1;SET NAMES cp866;CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET cp866 COLLATE cp866_general_ci) ENGINE=InnoDB CHARACTER SET cp866 COLLATE cp866_general_ci;SHOW TABLE STATUS LIKE 't1';Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Commentt1 InnoDB # # # # # # # # # # # # cp866_general_ci # # #SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);a_ascii a_len21 122 123 124 125 126 127 128 129 12A 12B 12C 12D 12E 12F 130 131 132 133 134 135 136 137 138 139 13A 13B 13C 13D 13E 13F 140 141 161 142 162 143 163 144 164 145 165 146 166 147 167 148 168 149 169 14A 16A 14B 16B 14C 16C 14D 16D 14E 16E 14F 16F 150 170 151 171 152 172 153 173 154 174 155 175 156 176 157 177 158 178 159 179 15A 17A 180 1A0 181 1A1 182 1A2 183 1A3 184 1A4 185 1A5 1F0 1F1 1F2 1F3 186 1A6 187 1A7 188 1A8 1F4 1F5 189 1A9 18A 1AA 18B 1AB 18C 1AC 18D 1AD 18E 1AE 18F 1AF 190 1E0 191 1E1 192 1E2 193 1E3 1F6 1F7 194 1E4 195 1E5 196 1E6 197 1E7 198 1E8 199 1E9 19A 1EA 19B 1EB 19C 1EC 19D 1ED 19E 1EE 19F 1EF 15B 15C 15D 15E 15F 160 17B 17C 17D 17E 17F 1B0 1B1 1B2 1F8 1F9 1FA 1FB 1FC 1FD 1B3 1B4 1B5 1B6 1B7 1B8 1B9 1BA 1BB 1BC 1BD 1BE 1BF 1C0 1C1 1C2 1C3 1C4 1C5 1C6 1C7 1C8 1C9 1CA 1CB 1CC 1CD 1CE 1CF 1D0 1D1 1D2 1D3 1D4 1D5 1D6 1D7 1D8 1D9 1DA 1DB 1DC 1DD 1DE 1DF 1DROP TABLE IF EXISTS test.t1;DROP TABLE IF EXISTS test.t1;SET NAMES cp932;CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET cp932 COLLATE cp932_bin) ENGINE=InnoDB CHARACTER SET cp932 COLLATE cp932_bin;SHOW TABLE STATUS LIKE 't1';Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Commentt1 InnoDB # # # # # # # # # # # # cp932_bin # # #SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);a_ascii a_len21 122 123 124 125 126 127 128 129 12A 12B 12C 12D 12E 12F 130 131 132 133 134 135 136 137 138 139 13A 13B 13C 13D 13E 13F 140 141 142 143 144 145 146 147 148 149 14A 14B 14C 14D 14E 14F 150 151 152 153 154 155 156 157 158 159 15A 15B 15C 15D 15E 15F 160 161 162 163 164 165 166 167 168 169 16A 16B 16C 16D 16E 16F 170 171 172 173 174 175 176 177 178 179 17A 17B 17C 17D 17E 17F 1A1 1A2 1A3 1A4 1A5 1A6 1A7 1A8 1A9 1AA 1AB 1AC 1AD 1AE 1AF 1B0 1B1 1B2 1B3 1B4 1B5 1B6 1B7 1B8 1B9 1BA 1BB 1BC 1BD 1BE 1BF 1C0 1C1 1C2 1C3 1C4 1C5 1C6 1C7 1C8 1C9 1CA 1CB 1CC 1CD 1CE 1CF 1D0 1D1 1D2 1D3 1D4 1D5 1D6 1D7 1D8 1D9 1DA 1DB 1DC 1DD 1DE 1DF 1DROP TABLE IF EXISTS test.t1;DROP TABLE IF EXISTS test.t1;SET NAMES cp932;CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET cp932 COLLATE cp932_japanese_ci) ENGINE=InnoDB CHARACTER SET cp932 COLLATE cp932_japanese_ci;SHOW TABLE STATUS LIKE 't1';Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Commentt1 InnoDB # # # # # # # # # # # # cp932_japanese_ci # # #SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);a_ascii a_len21 122 123 124 125 126 127 128 129 12A 12B 12C 12D 12E 12F 130 131 132 133 134 135 136 137 138 139 13A 13B 13C 13D 13E 13F 140 141 161 142 162 143 163 144 164 145 165 146 166 147 167 148 168 149 169 14A 16A 14B 16B 14C 16C 14D 16D 14E 16E 14F 16F 150 170 151 171 152 172 153 173 154 174 155 175 156 176 157 177 158 178 159 179 15A 17A 15B 15C 15D 15E 15F 160 17B 17C 17D 17E 17F 1A1 1A2 1A3 1A4 1A5 1A6 1A7 1A8 1A9 1AA 1AB 1AC 1AD 1AE 1AF 1B0 1B1 1B2 1B3 1B4 1B5 1B6 1B7 1B8 1B9 1BA 1BB 1BC 1BD 1BE 1BF 1C0 1C1 1C2 1C3 1C4 1C5 1C6 1C7 1C8 1C9 1CA 1CB 1CC 1CD 1CE 1CF 1D0 1D1 1D2 1D3 1D4 1D5 1D6 1D7 1D8 1D9 1DA 1DB 1DC 1DD 1DE 1DF 1DROP TABLE IF EXISTS test.t1;DROP TABLE IF EXISTS test.t1;SET NAMES dec8;CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET dec8 COLLATE dec8_bin) ENGINE=InnoDB CHARACTER SET dec8 COLLATE dec8_bin;SHOW TABLE STATUS LIKE 't1';Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Commentt1 InnoDB # # # # # # # # # # # # dec8_bin # # #SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);a_ascii a_len21 122 123 124 125 126 127 128 129 12A 12B 12C 12D 12E 12F 130 131 132 133 134 135 136 137 138 139 13A 13B 13C 13D 13E 13F 140 141 142 143 144 145 146 147 148 149 14A 14B 14C 14D 14E 14F 150 151 152 153 154 155 156 157 158 159 15A 15B 15C 15D 15E 15F 160 161 162 163 164 165 166 167 168 169 16A 16B 16C 16D 16E 16F 170 171 172 173 174 175 176 177 178 179 17A 17B 17C 17D 17E 17F 180 181 182 183 184 185 186 187 188 189 18A 18B 18C 18D 18E 18F 190 191 192 193 194 195 196 197 198 199 19A 19B 19C 19D 19E 19F 1A0 1A1 1A2 1A3 1A4 1A5 1A6 1A7 1A8 1A9 1AA 1AB 1AC 1AD 1AE 1AF 1B0 1B1 1B2 1B3 1B4 1B5 1B6 1B7 1B8 1B9 1BA 1BB 1BC 1BD 1BE 1BF 1C0 1C1 1C2 1C3 1C4 1C5 1C6 1C7 1C8 1C9 1CA 1CB 1CC 1CD 1CE 1CF 1D0 1D1 1D2 1D3 1D4 1D5 1D6 1D7 1D8 1D9 1DA 1DB 1DC 1DD 1DE 1DF 1E0 1E1 1E2 1E3 1E4 1E5 1E6 1E7 1E8 1E9 1EA 1EB 1EC 1ED 1EE 1EF 1F0 1F1 1F2 1F3 1F4 1F5 1F6 1F7 1F8 1F9 1FA 1FB 1FC 1FD 1DROP TABLE IF EXISTS test.t1;DROP TABLE IF EXISTS test.t1;SET NAMES dec8;CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET dec8 COLLATE dec8_swedish_ci) ENGINE=InnoDB CHARACTER SET dec8 COLLATE dec8_swedish_ci;SHOW TABLE STATUS LIKE 't1';Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Commentt1 InnoDB # # # # # # # # # # # # dec8_swedish_ci # # #SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);a_ascii a_len21 122 123 124 125 126 127 128 129 12A 12B 12C 12D 12E 12F 130 131 132 133 134 135 136 137 138 139 13A 13B 13C 13D 13E 13F 140 141 161 1C0 1C1 1C2 1C3 1E0 1E1 1E2 1E3 142 162 143 163 1C7 1E7 144 164 1D0 1F0 145 165 1C8 1C9 1CA 1CB 1E8 1E9 1EA 1EB 146 166 147 167 148 168 149 169 1CC 1CD 1CE 1CF 1EC 1ED 1EE 1EF 14A 16A 14B 16B 14C 16C 14D 16D 14E 16E 1D1 1F1 14F 16F 1D2 1D3 1D4 1D5 1F2 1F3 1F4 1F5 150 170 151 171 152 172 153 173 154 174 155 175 1D9 1DA 1DB 1F9 1FA 1FB 156 176 157 177 158 178 159 179 1DC 1DD 1FC 1FD 15A 17A 15B 1C5 1E5 15C 1C4 1C6 1E4 1E6 15D 1D6 1F6 15E 15F 160 17B 17C 17D 17E 17F 180 181 182 183 184 185 186 187 188 189 18A 18B 18C 18D 18E 18F 190 191 192 193 194 195 196 1
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?