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

duplicate record notification
In my database, after insertion of records, I want to know if the record inserted is duplicate or no

PayPal Redirect Issue
When I have my paypal button set so that is redirects to http://empiremarketing.ca/order.php,it work

Procedure with variable number of columns
Hi, I have a procedure that looks like this:

PROCEDURE PROC(p_cursor OUT sys_refcurso

Checking if field is empty AND using !is_numeric
Hi lads,

Need to be able to display an error message (using isset?) that says "Cant lea

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything

Problem in back link
I have page where i have given javascript back link but when i click on it browser give a message

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

Keeping data in form
How can I keep whatever I write in the form?

code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page.

The pro

Multiple if statements
Ok so seems basic but for some reason I'm not doing it right. What I want is to be able to have 2 se