darwin-eu / darwin-eu/CodelistGenerator
summariseCodeUse()
- Dominant language
- R
- Stars
- 18
- Forks
- 9
- PR merge metrics
- No merged PRs in 30d
Description
Error in summariseCodeUse() - conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in UNION ALL operator.
**To Reproduce**
codes <- getCandidateCodes(cdm = cdm,
keywords = c("asthma", "eczema"),
exclude = "occupation",
domains = c("Condition", "Procedure", "Drug"),
standardConcept = "Standard",
searchInSynonyms = TRUE,
searchNonStandard = FALSE,
includeDescendants = TRUE,
includeAncestor = FALSE)
event_count <- summariseCodeUse(list("cd" = codes$concept_id),
cdm = cdm)
**Screenshots**
ODBC failed with error 42000 from [Microsoft][ODBC SQL Server Driver][SQL Server].
x Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in UNION ALL operator.
Contributor guide
Assessment
This issue has not been assessed yet.