Explains collation and case or accent sensitivity

K-855 · Knowledge knobit · Activity: Generate and review DDL · Competence: Data modelling

Collation decides which values compare equal, and so what a key means.

Can AI do this?

Not tested yet

No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.

What it looks like in practice

Expected result: Collation decides which values compare equal, and so what a key means

How it is assessed: Chooses the collation for sample key columns

Related knobits

Needed for

• K-819 Recognises a collation changing what a key means

All 33 knobits of Generate and review DDL.

Source: Data-management practice used by the stage 8 reference and review checklist