Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

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

More
26 Jan 2017 11:35 #1 by Cedric
Load UTF-8 File with BOM in jdbc method for Teradata was created by Cedric
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 ?
Attachments:
More
27 Jan 2017 17:11 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Load UTF-8 File with BOM in jdbc method for Teradata
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?