Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sybase BCP Out on Unix

Status
Not open for further replies.

Autosys

Programmer
Jun 1, 2004
90
GB
Hello!

I hope you can help. I'm not a Unix or Sybase Expert and am faced with the following problem:

I'm running the below command to BCP Data out of a table into a file called testfile.

bcp tempdb.guest.tIndexFileLog out testfile -Uusername -SDSQUERY -Ppassword -c

When running the command on Windows it works fine, however, running it on Unix, it replaces everything that is suppose to be a £ with a /342

I understand that there might be some sort of character set that needs to be set in the Sybase Environment to convert it?

Your help will be very much appreciated!
Cheers!
Stefan

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top