Sybase BCP - using a delimiter from the ASCII extended codes

Posted on 2006-03-28
Last Modified: 2011-09-20

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

BTW, our charset is 'cp850'.


Question by:maria_rossi
    LVL 24

    Accepted Solution

    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.

    Author Comment

    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.
    LVL 24

    Expert Comment

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

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Outlook Free & Paid Tools
    Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now