Question Load UTF-8 File with BOM in jdbc method for Teradata

Hi,

we used to load files with TPT method.
These files are in UTF-8 with BOM

We want to load them with the jdbc method. The job fail because it detect the BOM like a character to load...



Any idea or tips to succeed in thie task ?

Hi,
When choosing the "jdbc" load method, this template will use Stambia's JDBC File driver.
Java is not friend with UTF-8 BOM
What you can do is implement a Transformation script in your File metadata, which will ignore the heading BOM when reading the file.
We can share an example if you want.

Just for curiosity: why using jdbc instead of tpt?