AnsweredAssumed Answered

Is the Collation Latin1_General_CI_AS supported in version 11.

Question asked by Joseph_Corbin_7226 on Nov 24, 2016



I've reviewed the documentation and SQL_Latin1_General_CP1_CI_AS is  indicated as being the correct code page. I have noticed that in other  incidents that when you put in a different collation i.e :  Latin1_General_CI_AS

The following type of error can occur :
20150916/184325.487 - U0003590 UCUDB - DB error: 'SQLExecDirect',  'ERROR ', '42000', 'Cannot resolve the collation conflict between  "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the not  equal to operation.'

I suggest using the recommended collation.