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.
Did you know?Explore Trending and Topic pages for more stories like this.
Please explain this behavior.
Thanks
No comments posted yet

Your Answer:

Login to answer
191 Like 17 Dislike
Previous forums Next forums
Other forums

ldap connection
We are using ldap to get user information from the domain controller. It was working before. Recentl

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on

Price in PR
Dear Experts,
Why we have to enter the price in the PR, and why there is no free goods indicato

Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

There was a problem with the request. (Code: 0)
Any Idea what could cause this? I get it randomly at best. But with both IE and FF. It derives from

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

simple script won't work. Please help
I'm new to php, and I am having trouble displaying a simple script in my web browser. My php code ex

limitations on array_unique()
Does any one know what/how imitations are applied to array_unique? I have an issue where no matter h

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash