Setting a Locale

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

  1. Show the IQ engine character set:
    select * from sa_eng_properties() where propname like '%CharSet%'
  2. 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.

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

Related concepts
How Connection Parameters Work
Locale Information
Related reference
CharSet connection parameter [CS]
Language Connection Parameter [LANG]