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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch