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

Performance impact of cookies
Hi, I was just wondering what impact there would be in terms of performance if you where to set then

IIS & NW MII on the same server
Hi,

We're weighing the possibility to run both IIS and MII (NetWeaver) on the same server

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<

Port scanner problem
Hai
recently i developed one app through which u can check the opened and closed ports under an

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi

PHP Mysql Staff Induction System
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

$variable = $variable
Hello

Sorry if this is a really simple question but I have run out of ideas. Is there a reall

PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing