AS/400 query sorts and searches using the hexidecimal values of characters, by default. This makes sorts and searches case-sensitive. You can change this.
An AS/400 query, by default, uses "Collating Sequence" = 1, Hexidecimal. That means if you are looking, e.g., for a string = "Printer", you have to also look for "printer" and "PRINTER", if you are unsure of case.?
If you select "Collating Sequene" = 2, Query for AS/400 English, the search and sort operations are not case sensitive. "printer" will find all variations, and A and a, B and b, etc., will sort together.
Dig Deeper on RPG iSeries programming
My question is: Do I need to add collation to all the char/varchar columns of temporary tables in over 1000 stored procedures that I have in the database? Or is there some simpler way to solve the problem generally?