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

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

Chat Box in PHP
I was thinking in doing a Chat Box in PHP. For that I would use a form with two fields, Nick and Mes

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

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

I have a banner s

Problem with the Update command used with a sqldataadapter
I'm connected to a database on an SQL Server and I'm using a sqldataadapter, sqlconnection, sqldatas

Issues: PHP Forms -Clearing
I've tried looking online before actually asking for help, but I've been looking for about the past

understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";

function get_nam

Creation of Raw Exposure manually
SAP Gurus

I am creating Raw Exposure ( Hedge management ) thru T Code TEM10 with followin

array help
Does anyone know how to require 10 text fields for individual grades and output class average? (10 p