Collation issue

Issue No: AP-1613
Created 9/15/2015 8:59:51 AM
Type Bug
Priority Major
Status Closed
Resolution Fixed
Fixed Version 15.3
Description [testi21Database].[test the standard collation (Latin1_General_CI_AS) on all i21 columns] failed: (Failure) [dbo].[listOfOutOfStandardUseOfCollation] was not empty: \|TABLE_NAME \|COLUMN_NAME \|COLLATION_NAME \|DATA_TYPE\| +--------------------+------------------+----------------------------+---------+ \|tblAPapeglmst \|apegl_cbk_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapeglmst \|apegl_trx_ind \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapeglmst \|apegl_vnd_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapeglmst \|apegl_ivc_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapeglmst \|apegl_alt_cbk_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPaphglmst \|aphgl_cbk_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPaphglmst \|aphgl_trx_ind \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPaphglmst \|aphgl_vnd_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPaphglmst \|aphgl_ivc_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPaphglmst \|aphgl_alt_cbk_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_vnd_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_ivc_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_status_ind \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_cbk_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_chk_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_trans_type \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_pay_ind \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_pur_ord_no \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_po_rcpt_seq \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_comment \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_recur_yn \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_currency \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_currency_cnt\|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPapivcmst \|apivc_user_id \|SQL_Latin1_General_CP1_CS_AS\|char \| \|tblAPImportBillError\|strDescription \|SQL_Latin1_General_CP1_CS_AS\|nvarchar \| \|tblAPImportBillError\|strIssue \|SQL_Latin1_General_CP1_CS_AS\|nvarchar \|