Spaces getting added to the data from Oracle enterprise stag
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Spaces getting added to the data from Oracle enterprise stag
Hi all,
I have a job in which I retrieve data using a sparse lookup... Everything is working fine but for the trailing spaces which get added to all the varchars.
e.g. If I retrieve a column emp_name varchar(10) with value 'John'
The oracle stage is retrieving it as 'John '
Is this expected? and if so, Is there an easy fix for this other than using a modify stage or a transformer.
Thanks for the help.
I have a job in which I retrieve data using a sparse lookup... Everything is working fine but for the trailing spaces which get added to all the varchars.
e.g. If I retrieve a column emp_name varchar(10) with value 'John'
The oracle stage is retrieving it as 'John '
Is this expected? and if so, Is there an easy fix for this other than using a modify stage or a transformer.
Thanks for the help.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
I don't think this is expected
You might want to see this on the database side and make sure that data is stored in this way in the source/lookup itself or in the schema it is defined as char and not varchar.
![Smile :)](./images/smilies/icon_smile.gif)
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Re: Spaces getting added to the data from Oracle enterprise
That confirms this is not expected as you have defined the column as VARCHAR(10) and not CHAR(10). Confirm the same on Oracle side.
Minhajuddin wrote: e.g. If I retrieve a column emp_name varchar(10) with value 'John'
The oracle stage is retrieving it as 'John '
Is this expected?
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
On your column metadata is the Unicode setting on? I have seen space issues when it is on depending on the source database settings.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Thanks for all the replies..
I don't have any spaces on the database side..
and the metadata is the same even in the database.
i.e. when I query the database from sqlplus I don't get spaces...
and the oracle client we are using is Oracle 9i. And lastly the unicode setting is not on.
I don't have any spaces on the database side..
and the metadata is the same even in the database.
i.e. when I query the database from sqlplus I don't get spaces...
and the oracle client we are using is Oracle 9i. And lastly the unicode setting is not on.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Hi Craig,
The exact version of the oracle client is 9.2.0.1.0
Did anybody have the same problem before?
The exact version of the oracle client is 9.2.0.1.0
Did anybody have the same problem before?
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>