• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1485
  • Last Modified:

Sybase BCP - using a delimiter from the ASCII extended codes

Hi,

My user encountered problems in loading a bcp file becuase the delimiter was embedded somewhere in the data.    Now, he wants to use a special character from  the ASCII Extended Code, decimal 145 and 146 as column and row delimiters.   He said there are the only 2 that are not found in the data.   Dec-145 looks like a 'ae' attached together, dec-146 is the upper case, AE, attached together.  My problem is, I can't type that in UNIX.     My user requires a bcp file that uses only 1 char as delimiter, so something like  '|||'  will not work.  

How can I use these characters at the bcp statement?  Or can I use alt-something?  or the hex value?   If this is not do-able,  what are my options?

If you want to see what this characters look like, go to www.lookuptables.com.

BTW, our charset is 'cp850'.

Thanks.
Maria

0
maria_rossi
Asked:
maria_rossi
  • 2
1 Solution
 
Joe WoodhousePrincipal ConsultantCommented:
Hmm. I think this is actually more a UNIX problem?

You could try cutting and pasting the character from somewhere you *can* display it. Most UNIXes will allow you to insert literal non-alphanumeric characters if you do a CTRL-V first - the very next character is displayed without being interpreted.

It's a pity they only want single-character delimiters as that's the usual way to fix this.
0
 
maria_rossiAuthor Commented:
It worked!!   I found the Æ and the æ from MSWord (from symbols), then copy and pasted it into my bcp statement at UNIX.  Tested the bcp file by loading to a test table successfully.   The wonders  of copy-and-paste.   I should have thought of that.  I guess I mind was on a different track.
Thanks a lot.
Maria
0
 
Joe WoodhousePrincipal ConsultantCommented:
It's easy to think of something like this as an obscure database problem. I only knew to suggest it because once it was the only way I could fix something similar! 8->
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now