| Description |
RUN the scripts:
SELECT TABLE_NAME, COLUMN_NAME, COLLATION_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE like '%char%'
AND NOT COLLATION_NAME = 'Latin1_General_CI_AS'
AND TABLE_NAME NOT IN ('tblGLIjemst', 'tblCMAptrxmstArchive', 'tblCMApchkmstArchive', 'tblCMApeglmstArchive', 'tblTMCOBOLWRITE', 'tblTMCOBOLREADSiteLink', 'tblTMCOBOLREADSite', 'tblTMCOBOLLeaseBilling')
AND COLUMN_NAME NOT IN ('strPassword')
AND TABLE_NAME LIKE 'tblPR%'
ISSUE:
Add tables on Payroll does not use the i21 standard SQL collation
!pastedImage_d36218_0.png! ACCEPTANCE CRITERIA:
All string type fields in all Payroll Tables should use the standard collation *Latin1_General_CI_AS*
|