Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008

    Unanswered: Client- Server Character conversion

    The bcp in process is getting failed from one cllient alone. Where as the bcp in success from all the clients. How can we find the default character set of the sybase client on windows machine. What should we do to make the bcp in process success from that client?

  2. #2
    Join Date
    Mar 2007


    the is a bcp option "-J" that lets you set the character set. The client character set should not matter, what is important is the sybase server's character set. If this is different then why dont you use -n (native format) when bcp out and then use the same when bcp in.

    hope this helps

  3. #3
    Join Date
    Nov 2008

    Client- Server Character conversion

    Thanks for the immediate response.

    We have already used the -J option. But we are not able to bcp in.

    we tried -c option, but it failed.
    After your mail, we tried -n option. It has shown partial success.
    Partial rows were bcp'ed in.

    FYI: we get the dat file from an external source.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts