topic [resolved] Sybase BCP in Talend Studio

[resolved] Sybase BCP

plarion — Mon, 15 Jun 2015 21:20:00 GMT

Hello,
Has anyone tried TOS Sybase BCP functionality ? I'm facing character set conversion problem.

Re: [resolved] Sybase BCP

plarion — Mon, 15 Jun 2015 22:38:54 GMT

Just to add more information:
I'm getting following error:
++++++++++++++
Server Message: dev1 - Msg 4847, Level 16, State 1:
BCP insert operation is disabled when data size is changing between client and server character sets. Please use BCP's -Y option to invoke client-side conversion.
++++++++++++++
I'm able to load the same file using bcp command.

Re: [resolved] Sybase BCP

plarion — Thu, 18 Jun 2015 19:33:42 GMT

I was able to resolve BCP issue.
Here are few observations (for Windows client):

For BCP out operation, use "Row Seperator" as "\r\n" ==> i.e CRLF
For BCP in operation, use "Row Terminator" as "\\n" ==> Please note extra backslash
For BCP in operation, use "Encoding" as ""
I hope it will help.