Defining character set in Vertica

Rupendra

Hello all, Is it possible to define character set in Vertica, just like we do in ORACLE? We are using ODBC driver to load data from ORACLE database to Vertica, and ORACLE database has non UTF-8 character set. We want to use the same character set in Vertica as well. But, looking into documentation, it seems that it is not possible to use character set other than UTF-8 with ODBC driver. Thanks, Rupendra

Daniel_Leybovic

Hi! 1. ODBC configuration: https://my.vertica.com/docs/6.1.x/HTML/index.htm#11705.htm https://my.vertica.com/docs/6.1.x/HTML/index.htm#12800.htm There are parameter - "LOCALE" in ODBC config. 2. Best Practices for Working with Locales: https://my.vertica.com/docs/6.1.x/HTML/index.htm#14068.htm 3. Set db default locale : https://my.vertica.com/docs/6.1.x/HTML/index.htm#13911.htm SELECT SET_CONFIG_PARAMETER('DefaultSessionLocale', 'en_GB'); 4. Locale Specifications : https://my.vertica.com/docs/6.1.x/HTML/index.htm#13757.htm 5. Set locale for current session : https://my.vertica.com/docs/6.1.x/HTML/index.htm#13751.htm