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

Function module "DPS_CHECK_TABLE_EXISTS" not found (after OSS 1422843 impl)
Dear All,

I implemented Note OSS 1422843.

When i execute the new report RSPO20

Array help
Hello i got this code to fetch data from database but it is not working it displays
7
Array

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

opening a window with after form submission
I know this this forum has nothing to do with JS, but i'm trying to use it with my php script.
<

Unifying logins of two different scripts
I have two different game scripts which I want to embed on my own site. The problem is I don't want

Mastering Regular Expressions, Third Edition, is available.
The Third Edition of Mastering Regular Expressions is available.

QuoteThis third edition is 5

PHP File Upload Problem
Hi, I have written a very simple file upload script but it fails for reasons I can't explain. Hope

Reditecting pages based on logic
Newbie here, apologies in advance!

I am trying to use the header function to forward one of a