Sybase bcp : can't change ENCODING TYPE, encoding default bad

One Star jfb
One Star

Sybase bcp : can't change ENCODING TYPE, encoding default bad

Hi,
When i use tSybaseBulkExec component, i have 2 problems
First one:
I would like to change Enconding Type to choice CUSTOM and to specify an another charset like iso_1, iso_15.
Unfortunately you can't change value in entry field.
The second problem
You can't change encoding type so you try to execute with charset ISO-8859-15.
When you see generated code you have this information WE8ISO8859P15 specially use to ORACLE and not SYBASE
command_tSybaseBulkExec_1.append("WE8ISO8859P15");

Talend generator must generate charset=ISO_15 when we choice ISO-8859-15
Regards
Jfb
Employee

Re: Sybase bcp : can't change ENCODING TYPE, encoding default bad

Hello,
Can you add a entry in the bugtracker please ?
Thanks for your support
Michaël
One Star jfb
One Star

Re: Sybase bcp : can't change ENCODING TYPE, encoding default bad

to follow up this problem
2323
One Star

Re: Sybase bcp : can't change ENCODING TYPE, encoding default bad

This is still an issue in 2.3. The workaround I used was to set the LANG system variable for the user to en_US (for iso_1). You are probably better off using a system cmd object anyway as you will then be able to explicitly set a language encoding type that may not be available in your user environment, as well as managing error output, forcing identity starts with -g, and all of the other bcp options not exposed in the bulkexec component.
Employee

Re: Sybase bcp : can't change ENCODING TYPE, encoding default bad

Now it works for custom charset

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch