MFT Command Center and Internet Server - Configuring mySQL for case insensitivity
Article ID: KB0073167
Updated On:
| Products | Versions |
|---|---|
| TIBCO Managed File Transfer Command Center | All |
| TIBCO Managed File Transfer Internet Server | All |
Description
On Windows, mySQL is case insensitive by default, but on UNIX, mySQL is case sensitive by default. How do I configure mySQL for case insensitivity to work with MFT Command Center and Internet Server?
Issue/Introduction
MFT Command Center and Internet Server - Configuring mySQL for case insensitivity
Environment
All supported environments
Resolution
To make mySQL case insensitive, use the "utf8_general_ci" database collation and "utf8" database charset when creating the database. This should work on mySQL V8.
This collation will make the MFT SQL calls case insensitive.
Feedback
Yes
No
Powered by
