Specify sorting language (collation) using i Access ODBC

Connection string

This IBM i Access ODBC driver connection string can be used for connections to AS/400.

Example using spanish (ESP) language for sorting.

Driver={IBM i Access ODBC Driver};System=mySystem;UID=myUser;PWD=myPassword;
SORTTYPE
=2;
LANGUAGEID=ESP;

Language codes: AFR, ARA, BEL, BGR, CAT, CHS, CHT, CSY, DAN, DES, DEU, ELL, ENA, ENB, ENG, ENP, ENU, ESP, EST, FAR, FIN, FRA, FRB, FRC, FRS, GAE, HEB, HRV, HUN, ISL, ITA, ITS, JPN, KOR, LAO, LVA, LTU, MKD, NLB, NLD, NON, NOR, PLK, PTB, PTG, RMS, ROM, RUS, SKY, SLO, SQI, SRB, SRL, SVE, THA, TRK, UKR, URD, VIE