: Friday, July 10, 2020 2:16:43 AM
To: CAS Community
Subject: [cas-user] Re: JDBC attribute SQL query
Hi Parker,
What about changing the collation of your DB/TABLE/COLUMN to a case insensitive
(CI) one?
MYSQL seems to do that easily:
ALTER TABLE user_table MODIFY COLUMN username VARCHAR
Hi Parker,
What about changing the collation of your DB/TABLE/COLUMN to a case
insensitive (CI) one?
MYSQL seems to do that easily:
ALTER TABLE user_table MODIFY COLUMN username VARCHAR(…) CHARACTER SET UTF8
COLLATE UTF8_GENERAL_CI
MSSQL would be something like:
ALTER TABLE dbo.user_table
