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 to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

Mail sending is slow on server
Why mail is taking time to be send on apache-linux server

Is this possible? If one file assigned to an ID...
I have a page that lists property listings assigned to a specific user (a manage page), with brief t

Multiple WHILE loops help
Hi there. I'm writing an application that is pulling and displaying results for real estate listing

RadioButtonList item spacing
I have a RadioButtonList and I can't put any spacing between the items. They are arranged verticall

Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

Please help - should be a simple fix.. driving me nuts
Everything seemed to be working fine. I have a table, it alphabetically lists a bunch of cities and

Implementing Single Sign-On using SAML 1.1, x.509, LDAP in C#.net
Hi, I got a requirement from the client i.e implementing single sing on using SAML 1.1( LDAP &