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

how make 2 column in table with data tybe long row
hi every one

I want make in my table 2 column with data tybe long raw

how thi

need help in update query
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic for

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi

my login script page is not working on remote computers
hi my login is working on my computer, but when i tried 2 computers from 2 different locations, they

Fetching META TAGS through
Hello everybody
I want to fetch meta tags of a domain.
It will be done from following code of

Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']

Validating time
Hi Guys

what do you think of the following approach to validate a 24hour time:

http://

Unable to retreve the values from Mysql Query
Hi,

Here is the php code that I have, Query is running properly in phpmyadmin and is resu

extending tidy
I have problem with type-hinting and extending tidy. This code creates error:
Code: class cMyTidy

Using mysql_real_escape_string for displayed content
On my website users can input data into a textarea and it will store it in the mysql database. But,