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