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

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

extract data
Code: <div class="post hentry uncustomized-post-template">

PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing

$variable = $variable
Hello

Sorry if this is a really simple question but I have run out of ideas. Is there a reall

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in

Can we convert non uni code system into unicode
Hi All,

Presently i am using non-unicode system and the sap version is 4.7.
Can i c

Form always sends to error page...
Hello,
Any help will be greatly appreciated. I am having trouble getting multiple fields to be re

Extending Exception to contain method name
I was wondering, if there's a way to extend Exception in such a way, that it would contain name of a

that old Malformed Headers problem again!!!!! HELP!!!!!!
I've read the http://www.phpfreaks.com/forums/index.php/topic,37442.0.html

I don't think my c

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