This enhancement request associates the LDP/HVR technical service request.

Background

We are implementing a LDP/HVR project at one of our key customers.  The customer is using Oracle databases with the character set TH8TISASCII.  They want to use LDP/HVR to replicate the data from their Oracle databases (TH8TISASCII) to PostgresSQL (UTF8) to offloading the work from the Oracle databases.  However, LDP/HVR cannot replicate correctly in this case, and all the Thai characters are displayed as unreadable characters on the target as shown below.  As the result, the project is pending currently, and it becomes a major roadblock for our next LDP/HVR projects that we have with the customer.  We urgently need Fivetran to support this feature enhancement ASAP.

Please also note that, in Thailand, most of the customers are using Oracle databases with the character set TH8TISASCII.  So, this feature enhancement is very important for Fivetran to expand in Thailand.

Source Oracle Character Set is TH8TISASCII:

Source Oracle Thai character:

Target PostgreSQL database Default Encoding is UTF8:

Target PostgreSQL Thai character:

Dear to whom it may concern,

Following is an example of a Thai character:

ทดสอบภาษาไทยที่ 1 วันที่ 24 เมษายน 2566 เวลา 10:34
ทดสอบภาษาไทยที่ 2 วันที่ 24 เมษายน 2566 เวลา 10:36
ทดสอบภาษาไทยที่ 3 วันที่ 03 พฤษภาคม 2566 เวลา 21:44

Best regards,

Jumphol Buntuek

Hi Jumphol,

Thank you for submitting your request. I am putting this on the backlog with the goal to add support for the TH8ASCII encoding in the next few months.

Thank you,
Mark.