topic Re: Sybase bcp : can't change ENCODING TYPE, encoding default bad in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 14:32:14 GMT

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

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

Anonymous — Mon, 22 Oct 2007 18:44:10 GMT

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

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

Anonymous — Tue, 23 Oct 2007 13:14:26 GMT

to follow up this problem
2323

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

Anonymous — Mon, 16 Jun 2008 05:28:04 GMT

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.

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

Anonymous — Tue, 03 Dec 2013 03:05:56 GMT

Now it works for custom charset