Data storage spaces in varchar2

Posted on 16th Feb 2014 07:03 pm by admin

Trying to understand what's happening.
I am selecting a value from a table that is defined as char(16) and placing in a new table defined as varchar2(50).
If the data that I select contains spaces, ie "1234........0001" (where dot represents space), I am curious how this is stored by Oracle.
The reason I ask is because when I extract the varchar2 field out to a cvs file in contains a tab (chr 9) instead of all of the spaces.
Please explain this behavior.
Thanks

Your Answer:

Login to answer

Other forums

MS Exchange 2007 integration with ECC 6.0
Hello Experts,
We have ECC 6.0 and MS Exchange 2007. We need to integrate ECC 6 and MS Excha

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built r

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

Using CSS to format MySQL query
Hi,

If i want to have a news page on my site, which displays all records of a table in descen

Undefined variables
hi
----------------------------------------------------------------------------------------------

Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the sc

Exporting new records
Trying to figure out the best way to set this up.

People register my site.

Their prof

PHP Script runs on CLI but not through web browser
I am running into an issue that I just can't seem to find the answer to. I have a Windows Server 200

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks