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

fopen() security
As i understood the usage of fopen() for it to function correctly the Dir you write to has to be rw

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

Login Script Issues
I am using a script I got from http://phpsense.com/php/php-login-script.html in order to allow peopl

Quick Question about echo value
Hey guys, I'm trying to get something to show differently in one of my scripts. I'm trying to make

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Cloud Computing?
Hello,

I was wondering if anyone could help explain this term to me. I'm starting to hear it

Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitesp

Problem with php's rename function
So, i'm having a problem with the php rename function. Basically my script 'delete_user.php' attempt

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

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