Stash requires a case-sensitive database, but the target database is case-insensitive.
When trying to connect to an external database supported by Stash, the following message is displayed:
Stash requires a case-sensitive database, but the target database is case-insensitive. For information about creating a database for use with Stash, please refer to the Stash documentation.
The following screen is shown
Stash requires that the database stores its data in a case-sensitive manner for its regular operation.
The instructions on how to set up the database server will depend upon which database you are connecting your instance to. Please refer to the documentation for creating your database listed on Connecting Stash to an external database accordingly. Below we highlighted the commands related to the database creation that you need to make sure they were run.
SQL Server> ALTER DATABASE stash COLLATE SQL_Latin1_General_CP1_CS_AS
mysql> CREATE DATABASE stash CHARACTER SET utf8 COLLATE utf8_bin;
Note that it is important to the proper operation of Stash that the database store its data in a case-sensitive manner. By changing the values of the NLS_COMP and/or NLS_SORT variables, it is possible to cause Oracle to perform its searches in a case-insensitive manner. We therefore strongly recommend that those variables be left at their default values.
CREATE DATABASE stash WITH ENCODING='UTF8' OWNER=stashuser CONNECTION LIMIT=-1;