Interact memory usage and possible remedies to out of memory situations.
Today, I am writing about how different binary collations between databases affects Campaign sorting and result in error.
Campaign uses binary sort collation but this is not enough. I encountered a case where two databases (Oracle and Netezza) are using binary sort collation but still it results in incorrect sort order. In the case, input is taken from 1 database and this was made output to another database.