Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
4 Replies
Anonymous
Not applicable
Author

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

to follow up this problem
2323
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

Now it works for custom charset