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.