Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle ODBC newline character translation

Re: Oracle ODBC newline character translation

From: Joel Garry <joel-garry_at_home.com>
Date: 25 Mar 2003 16:27:52 -0800
Message-ID: <91884734.0303251627.1ca290f5@posting.google.com>


m.weymarn_at_iname.com (Martin v. Weymarn) wrote in message news:<1c806e81.0303250142.e58eee3_at_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.

To add to what Billy said, you can figure out what that character is by using od (octal debugger) in several ways. Probably the easiest way is get on the server and spool the selected data to a file, and run od -c on the file (hopefully it comes out there - if none of these methods work, the character is being added by ODBC or Excel). Other ways are to run it on an export file, or on the actual oracle data file itself (use a backup copy). The general trick is to pipe the output into more, and then search (use the slash) for known text data near the character. You'll be searching for the text with some extra spaces between the characters, play around with a small text file first to see how it works.

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

jg

--
@home is bogus.
Never meet your heroes.
Received on Tue Mar 25 2003 - 18:27:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US