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

Sending UDP Raw socket
I truly need help on this. I am trying to write a test program that simulate a network environment

Last character removed
I have created a string from an array. I have inserted commas from my form values. I am trying to re

Forgot password won't work
My forgot password thing is not working properly. It is giving me this errorMailbox unavailable. The

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

Developing Ajax-enabled ASP.Net applications for the iPhone
I would like to develop Ajax web applications using Visual Studio that are optimized for the iPhone.

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

count only commas outside parenteses
I have a sql table containing
id - query - query name
the first page contains a drop down men

PHP mail() returns true but doesn't work
First off I apologize if this is a newbie question, and I generally don't like asking questions that

Disabling SAP menu
How do I disable SAP menu for all the users and just restrict them to User Menu in SAP ECC 6.0?

Whats wrong with my query?
I am trying to get this query to show the appropriate ticked vehicle roof height, unless no boxs are