AuDigitalHealth / sctau-sample-scripts

Sample relational database load scripts and SQL queries for processing SNOMED CT-AU RF2 release files.
Other
13 stars 4 forks source link

char set and collation #3

Open JroachAu opened 1 year ago

JroachAu commented 1 year ago

Hi, Throughout these scripts its specified in code that char / collation refer to utf8 (i.e. utf8mb3). Newer MySql versions use utf8mb4, with mb3 planned for deprecation. Some parts of the script create tables/indexes etc without specifying 'utf8' and therefore are created to the default schema of utf8mb4.

I'll get around to raising my changes as a pull request if you'd like.