Demo environment is Deepin (Deep Linux)

Step 1: Stop the current service

Step 2: Clear the current folder. If you are worried about data loss, create a new folder and run the initialization command

Step 3: Start the newly initialized folder

At this point, initialization is complete. During the initialization, no case-sensitive configuration is added. After the initialization is complete, the value is verified as case-insensitive after SQL query.

In the previous project, in Windows and Kirin systems, it was added to the command during initialization--case-sensitiveIs case insensitive, but today adding this configuration to the depth system results in:

This is true in the Jincang community for initialization, but it does not work in deep systems. So, do not know exactly what is initialized, there is, verify it, if not, change the parameter to initialize again, come several times, there is always one is you need!!

If the result of running the SQL query is ON, the database is case-insensitive. This is a little weird because case Sensitive is case sensitive and the configuration result is on, so I used to think this result was case sensitive, but it’s just the opposite…