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
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.