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
4 REPLIES
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