Skip to main content

Defining character set in Vertica

  • September 13, 2013
  • 1 reply
  • 7 views
Rupendra
Forum|alt.badge.img+1
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

    1 reply

    Daniel_Leybovic
    Forum|alt.badge.img+1
    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
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement