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

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

Program with calculate Meteorologic measurements
Hello I'm a beginner and I want to make a program with calculate Meteorologic measurements:
ba

Drawing Images in classes
I'm quite new to Object Oriented PHP. What I'm trying to do is draw some images but also have other

Why Are These Functions Causing MASSIVE Memory Problems? Please Help!
Hi,

I have a script with some options.

I use regex to replace patterns in strings, but

if statements problems
Hi. I'm trying to make a web form, but I kind of hit a dead end trying to figure out why it doesn't

IIS & NW MII on the same server
Hi,

We're weighing the possibility to run both IIS and MII (NetWeaver) on the same server

natcasesort works on one server but not on another
Hi

I have a problem that I was hoping that someone can help me with.

I'm trying to use

Count Session and Trigger Events
I am New in PHP, seeking a method to count logged users by counting the sessions or any …, is

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di