search

HDRUK / CaRROT-CDM

MIT License
7 stars 2 forks source link

VARCHAR(MAX) : MAX unknown #66

Closed calmacx closed 3 years ago

calmacx commented 3 years ago

Unknown what this means

While implementing the drug_exposure table I came across VARCHAR(MAX)

Currently this is implemented as so:

self['VARCHAR(MAX)'] = lambda x : x.fillna('').astype(str).apply(lambda x: x)

I have no idea how BCLink defines MAX, so it is currently undefined

All this information comes from https://github.com/CO-CONNECT/co-connect-tools/blob/master/coconnect/data/cdm/OMOP_CDM_v5_3_1.csv

which Tom once sent to me. It provides information about what format BCLink is expecting the data.

calmacx commented 3 years ago

not relevant now