我使用md5散列id作为键执行SQL连接。
library(dplyr)
# dbt_x already has a field called enc_id that has an md5 hashed id
dbt_x <-
dplyr::tbl(db_connection, db_tablename_x)
dbt_y <-
dplyr::tbl(db_connection, db_tablename_y) %>%
dplyr::mutate(enc_id = MD5(id))
ds_progress <-
dplyr::left_join(dbt_x, dbt_y, by = "enc_id", `copy` = TRUE)
我失败的加入会产生错误消息:
操作“=”的非法排序规则(utf8mb4_general_ci,强制)和(拉丁文1_瑞典语_ci,隐式)的非法混合[1267]
enc_id
?
dbt_y$enc_id <- enc2utf8(dbt_y$enc_id)
RMariaDB中有类似的功能吗?
