I have a table which allows for storing notes about a client. One field is ntext(8000), where the users input the history about a particular client/claim. They have CR/LF in the field, which I can handle in SQL and the application. However, when I export the data to a text file, vertical bar delimited for each field, when our Oracle DBA tries to import it, it breaks that field into multiple rows of data, breaking on the CR/LF. Now, having said all that, I know zip about Oracle and don't know how to help the Oracle DBA. I've tried ansi and unicode as an export option and that doesn't seem to matter. Lastly, we cannot setup a linked server as our version of Oracle (7.32) needs to be at 7.33, minimum, based on my attempts to setup the linked server and there are no current plans to upgrade. Any thoughts on how/what I can try to get around this?
-- You can't be late until you show up.