[CONC-299] Add support for utf8mb4_0900_ai_ci collation in Connector/C Created: 2017-12-21  Updated: 2020-08-25  Resolved: 2017-12-25

Status: Closed
Project: MariaDB Connector/C
Component/s: None
Affects Version/s: None
Fix Version/s: 3.0.3

Type: Task Priority: Major
Reporter: Valerii Kravchuk Assignee: Georg Richter
Resolution: Fixed Votes: 0
Labels: collation, utf8mb4

Attachments: PNG File Screenshot from 2019-03-08 12-01-52.png    

 Description   

Please, add support for utf8mb4_0900_ai_ci collation in Connector/C, as it is used by default by MySQL 8.0.x and currently connections just fail from MariaDB Connector/C.

 Comments   
Comment by Georg Richter [ 2017-12-21 ]

Missing utf8/gb18030 character set/collations in Connector/C (MySQL 5.7):

076 utf8mb3_tolower_ic
 
248 gb18030_chinese_ci
 
249 gb18030_bin
 
250 gb18030_unicode_520_ci

Missing utf8mb4 collations in Connector/C (MySQL 8.0):

255  utf8mb4_0900_ai_ci
 
256  utf8mb4_de_pb_0900_ai_ci 	
257 	utf8mb4_is_0900_ai_ci 	
258 	utf8mb4_lv_0900_ai_ci 	
259 	utf8mb4_ro_0900_ai_ci 	
260 	utf8mb4_sl_0900_ai_ci 	
261 	utf8mb4_pl_0900_ai_ci 	
262 	utf8mb4_et_0900_ai_ci 	
263 	utf8mb4_es_0900_ai_ci 	
264 	utf8mb4_sv_0900_ai_ci 	
265 	utf8mb4_tr_0900_ai_ci 	
266 	utf8mb4_cs_0900_ai_ci 	
267 	utf8mb4_da_0900_ai_ci 	
268 	utf8mb4_lt_0900_ai_ci 	
269 	utf8mb4_sk_0900_ai_ci 	
270 	utf8mb4_es_trad_0900_ai_ci 	
271 	utf8mb4_la_0900_ai_ci 	
273 	utf8mb4_eo_0900_ai_ci 	
274 	utf8mb4_hu_0900_ai_ci 	
275 	utf8mb4_hr_0900_ai_ci 	
277 	utf8mb4_vi_0900_ai_ci 	
278 	utf8mb4_0900_as_cs 	
279 	utf8mb4_de_pb_0900_as_cs 	
280 	utf8mb4_is_0900_as_cs 	
281 	utf8mb4_lv_0900_as_cs 	
282 	utf8mb4_ro_0900_as_cs 	
283 	utf8mb4_sl_0900_as_cs 	
284 	utf8mb4_pl_0900_as_cs 	
285 	utf8mb4_et_0900_as_cs 	
286 	utf8mb4_es_0900_as_cs 	
287 	utf8mb4_sv_0900_as_cs 	
288 	utf8mb4_tr_0900_as_cs 	
289 	utf8mb4_cs_0900_as_cs 	
290 	utf8mb4_da_0900_as_cs 	
291 	utf8mb4_lt_0900_as_cs 	
292 	utf8mb4_sk_0900_as_cs 	
293 	utf8mb4_es_trad_0900_as_cs 	
294 	utf8mb4_la_0900_as_cs 	
296 	utf8mb4_eo_0900_as_cs 	
297 	utf8mb4_hu_0900_as_cs 	
298 	utf8mb4_hr_0900_as_cs 	
300 	utf8mb4_vi_0900_as_cs 	
303 	utf8mb4_ja_0900_as_cs 	
304 	utf8mb4_ja_0900_as_cs_ks 	
305 	utf8mb4_0900_as_ci 	
306 	utf8mb4_ru_0900_ai_ci 	
307 	utf8mb4_ru_0900_as_cs

Comment by Georg Richter [ 2017-12-25 ]

Added missing utf8mb collations, utf8mb3_tolower_ci and gb18030 character set and collations.

Commit: fe129ed39f33ba2b430aac91473baee84de88b12
pushed to master (3.0.3) and merged into 10.2-server branch

Comment by y2kbug [ 2019-03-08 ]

I am using 10.4.3 (image from docker hub).
I want to use utf8mb4_ja_0900_as_cs or utf8mb4_ja_0900_as_cs_ks but they are not there.

SQL Error [1273] [HY000]: (conn:151) Unknown collation: 'utf8mb4_ja_0900_as_cs_ks'
Query is : ALTER TABLE `database`.`member` MODIFY COLUMN name varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_ja_0900_as_cs_ks DEFAULT NULL NULL

As I understand from this thread, all collations in utf8mb4 are added to MariaDB already?

Comment by Bogdan.sh [ 2019-09-27 ]

The collations utf8mb4_0900% are missing in latest 10.4.8 . Please reopen this report.

Generated at Thu Feb 08 03:04:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.