Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-313241 - MBIL Views - Collation Issue|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-313241]
+ *Steps:* +
1. Run this query backend
select DISTINCT
TABLE_NAME, COLLATION_NAME from INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME like 'vyuMBIL%'
and COLLATION_NAME != 'Latin1_General_CI_AS'
+ *Issues:* +
View in columns were case sensitive.
!pastedImage_9_12_2023__14_55_00_291.png|height=918,width=545!
+ *Accepted:* +
To check the view if columns were case insensitive
Exception: Columns for tables that are integrated with Origin schema.
|