search

FHIR / sql-on-fhir

SQL on FHIR Proposal
78 stars 9 forks source link

FHIR String Data Type Conversion #8

Open pkjordan opened 6 years ago

pkjordan commented 6 years ago

Need to consider the use of NVARCHAR, rather than plain VARCHAR. For example, both the US and International Editions of the SNOMED CT clinical coding system contain terms that can only rendered correctly in Unicode.

rbrush commented 6 years ago

Good point...all text should be represented as unicode.

I'll plan on replacing all VARCHAR references with NVARCHAR to make this explicit, and databases can use that or an equivalent for those that don't directly support it.

rbrush commented 6 years ago

Took a pass at this in the above commit. We can add further clarification if that would help as well.