> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# What if I have a problem with encodings when using Oracle via ODBC?

> This page provides guidance on what to do if you have a problem with encodings when using Oracle via ODBC

If you use Oracle as a source of ClickHouse external dictionaries via Oracle ODBC driver, you need to set the correct value for the `NLS_LANG` environment variable in `/etc/default/clickhouse`. For more information, see the [Oracle NLS\_LANG FAQ](https://www.oracle.com/technetwork/products/globalization/nls-lang-099431.html).

**Example**

```sql theme={null}
NLS_LANG=RUSSIAN_RUSSIA.UTF8
```