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

comparing tables across databases sql refinement ideas required
Hi all

Via pl/sql I need to ensure that data between tables in different databases match

SOAP Issue
Hi,

I am facing some understanding problem with SOAP basic.kindly recommend some SOAP expert.

Access database inside of a validation class
Hello,

For quite some time, I have been using functions to validate form input and access the

PHP Session Issue
I'm having an issue with one section on my website dealing with sessions. Now I know that myself and

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way

Undefined Variable: PHP_SELF, pls help
Hi,

Im a newbie on PHP / MySQL programming and Im running a script to search one field on my

If statement help please.
Hello on my site I have 2 content boxes. 1 is for the main content (which is the biggest one) and th

Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.

we have to suppl

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

Need help making a blockquote and line items conditional
I have some code I bought a few years ago that allows my clients to update content on their site usi