Spaces in Linux is getting Interpreted as ‘@’

pts.
Tags:
Database Management Systems
Linux
SQL Server
Hi All Need some help. I use the BCP out command to transmit data from SQL Server database table and send it to flat files. The spaces (varchar datatype in table) gets transmitted as spaces only. When I use Linux command to get these files, out of 20,000 spaces , 1 space got interpreted as '@'. Can you please tell me the reason behind this peculiar behaviour and how do I prevent it?

Answer Wiki

Thanks. We'll let you know when a new response is added.

What I understand you are saying is that out of 20,000 spaces in some table you get 19,999 and one @.

Need schema and representative info to help further.

Have you tested this in Windows?

Have you confirmed that there is really no @ in your data?

WHERE COLUMNNAME LIKE ‘%@%’

Cheers,

Ben

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Bakash
    Thanks for the quick response. Correct, 19,999 are spaces and one '@'. Info: ColumnName varchar(25) Null Yes, I ve tried it out in Windows as well as Unix. Did not encounter any such behaviour. And yes its confirmed that there's no '@' in the data. Thanks Again
    0 pointsBadges:
    report
  • Howard2nd
    Space ASCII 32 - Hex 20 versus @ ASCII 64 - Hex 40 or 0010 0000 versus 0100 0000. 1st question is it in the same place in the transferred file every time? 2nd - Are the frame sizes set the same on both machines? If it is about the same place every time you have found a coincidence bug. You are getting a 1 bit transposition in a 40,000 nibble transfer. At one point in the transfer between Windows and Linux the difference in TCP/IP stacks combines with the different block sizes to transpose one bit and it must be occuring at a checksum boundary since you don't report any communication errors. Congratulations you found a bug, bad news I don't know how to prevent it. I will watch expectantly for the solution. Which version of Linux, Kernel, patches, etc.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following