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

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

whats wrong with my code please help!!!
this is the error


Warning: mysql_close(): supplied argument is not a valid MySQL-Link res

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

Allowing ' and "
Hello everyone,

I am creating a form where users submit information to go into a database. I

VAT
how should I deal with VAT?

if I have a product that costs £5.00 and VAT @ 17.5% (£0.87

links using header()
Hi All

I'm not sure where to ask for help on this but I hope someone can offer some. I'm at

what does this mean? +=
is anyone able to explain what this code is saying?

i had it written for me awhile back and n

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur