SET_SESSION_PARAMETER¶

There are two sets of code pages used in windows, ANSI and OEM. ANSI is what is commonly used now, but some data still uses the OEM code pages. When migrating data, this command is used to determine whether the OEM data will be translated to ANSI during the migration. For example, migrating passwords with special characters may call for different code pages. Sending true will convert the OEM data to ANSI, sending false will not. Both OEM_TO_ANSI and OEM_TRANSLATION_STATE do essentially the same thing, however since MSSQL has the functionality built in, OEM_TO_ANSI will use MSSQL’s built in translation and thus only works with SQLFlex. OEM_TRANSLATION_STATE is internal and built into the driver so it works for all drivers. Note that if using custom entries with SET_CUSTOM_OEM_TO_ANSI then OEM_TRANSLATION_STATE must be used. Also, if there are already custom entries set then turning OEM_TRANSLATION_STATE on will automatically enable those custom translations.