Oracle ODBC newline character translation

From: Martin v. Weymarn <m.weymarn_at_iname.com>
Date: 25 Mar 2003 01:42:54 -0800
Message-ID: <1c806e81.0303250142.e58eee3@posting.google.com>

Hi all,

I am having a problem with the translation of newline/return characters in my returned data. Our company is using a web-based application in which users enter data that gets written to an Oracle database. I am querying that database directly through Excel using an ODBC connection.

Special characters are coming through just fine so I think I am on the right track regarding the character set. However at the end of each paragraph Excel shows a small rectangle character (don't know the code). Is there some way to filter these out, preferrable through a setting in the ODBC driver? I have not been able to find any information regarding the Translation Options setting in the driver.

I am running Oracle ODBC version 8.01.78.00 to connect to an Oracle 7.3 database running on a UNIX server. Excel version is 2000. In the registry, NLS-LANG is set to AMERICAN_AMERICA.WE8ISO8859P15.

Unfortunately I did not find any solution to this problem on the web or the newsgroups, that's why I am asking here...

Thank you for your help,
Martin. Received on Tue Mar 25 2003 - 03:42:54 CST