Unable to read Unicode characters from Teradata data source

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 09 Jun 2020
Tags: JDBC data sources

Download document

You can translate the document:

Goal

This document describes how to configure the database URI for a JDBC data source in order to read in and view Unicode characters in Virtual DataPort.

Content

When creating a JDBC data source in Virtual DataPort using Teradata, it is necessary to add a charset parameter to the database URI if you want to view data in Virtual DataPort that contains Unicode characters. The following is an example of how to add the parameter in the Database URI:

jdbc:teradata://<host_name>/DATABASE=<database_name>,DBS_PORT=<port>,CHARSET=UTF8

Without the CHARSET=UTF8 parameter added to the end of the url, certain characters such as Arabic, Cyrillic or Japanese characters will show up as empty string values in VDP.

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training