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

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

Remote Database Access
Hey guys!!

OK, i'm used to only working with databases from the CPANEL, accessing phpMyAdmin

Display error above the login forum help!
Hi guys. just so you know im not asking for someone to do this for me I just need to be pointed in t

Problem with HTML form
Hello,

I made a HTML form with some fields and check box.
Everything works fine except whe

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

socket makes browser hang...
I have a socket server, and I am having a problem at the moment...

A browser sends a http hea

Strange array issue, never happened before.
mysql_fetch_array returns 1 array per call. Generally that's why it is inserted into a while statem

Beginners syntax and loop questions - help please!
Hi everyone,

I have some problems with php code. I'm currently in the middle of learning php,

PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html

session variable problem
Session variable is not working in Fire fox i am getting null value but it is working fine in IE.