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

Creating Images from images in PHP
Okay well I am trying to make a 'dynamic' calender image with PHP.

I have images like this:

2 things: enter doesn't work in IE & empty form
i have this search form that works well except for 2 things.

1) on IE when i hit enter instea

fwrite error
Hi All,
Does anyone know what is causing the error in this code?

Code: <?
$error

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

Help with PHP and checkboxes
I am posting this for a friend of mine, i wrote a small script for her to process her form data to a

animation progress while uploading files?
Hello, i have some website form to upload few files to server. i want to put some gif animation whi

calendar dates and hours compare problem
i have a calendar in wordpress, everything works great except that i can make 2 meetings at the same

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

Insert to MySQL inside foreach
Hey.
I am parsing some html, and putting inside an html db.
I need to create a randomized inte