Case sensitive sorting (collation) using i Access ODBC
Connection string
This IBM i Access ODBC driver connection string can be used for connections to AS/400.
Driver={IBM i Access ODBC Driver};System=mySystem;UID=myUser;PWD=myPassword;
SORTTYPE=2;LANGUAGEID=ESP;SORTWEIGHT=1;
Default SORTWEIGHT value is 0 meaning case insensitive sorting.