[resolved] Sybase BCP

Four Stars

[resolved] Sybase BCP

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

Accepted Solutions
Four Stars

Re: [resolved] Sybase BCP

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.

All Replies
Four Stars

Re: [resolved] Sybase BCP

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

Re: [resolved] Sybase BCP

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.