Setting a Locale

You can use the default locale on your operating system, or explicitly set a locale for use by the SAP Sybase IQ components on your machine.

Show the IQ engine character set:
```
select * from sa_eng_properties() where propname like '%CharSet%'
```
Set either or both of the IQLANG and IQCHARSET environment variables:
```
IQCHARSET=charset;IQLANG=language_code
```
where charset is a valid character set label and language_code is a language code from the list of language label values.

SAP Sybase IQ loads the localization information when it executes the INSERT...LOCATION statement.

List of Language Label Values
Valid language label values and their equivalent ISO 639 language codes. Set the two-letter ISO_639 language code in the IQ_LANG environment variable.
Setting the Locale for an INSERT...LOCATION Statement
When the database uses a non-default locale for your platform, you must set an environment variable on the local client for SAP Sybase IQ to load the correct information for language, collation sequence, character set, and date/time format.