asked on

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

ASKER CERTIFIED SOLUTION

Joe Woodhouse

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

maria_rossi

ASKER

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

Joe Woodhouse

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->