Comments - Identifier Case-sensitivity

1 week, 3 days ago Johannes Kingma

In order to have case sensitivety on NTFS you will have to enable it on the filesystem before setting the parameter

Exec this ps script as administrator to enable case sensitivety on the mariadb data folder:

Get-ChildItem -Directory -recurse |Foreach {fsutil file setcasesensitiveinfo $_.fullname}

You might want to make a backup of all databases first and do this on a fresh data folder and import the backup.

Btw tables and schemas names are case sensitive but column names are not!

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.