Hi all,
Firstly, my apologies because I know this question has been asked and answered on a number of occasions, I'm hoping to get some current advice.
I'm having difficulty with Case Sensitive search in a Power App linked to an (on-premises) SQL Database.
Database collation is set as SQL_Latin1_General_CP1_CI_AS, Column collation is set as database default. Column in question was originally set to a data type of text, but has been changed to varchar(MAX).
I've also tried creating a view and specifically setting the columns in that view with Case Insensitive collation, and it still searches as Case Sensitive only.
Does anyone have any suggestions?
Cheers,
Ben

Report
All responses (
Answers (