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

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var

PHP5 - Verifying a secure mail is secure
I need to send an e-mail from a form to a external department and because it contains personal custo

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

checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou

DOMDocument
Hello All,

I need to take an XML document, modify some of the nodes in it and then perform a

Give me all your tricks for minimizing jar file size

Hi, I'm coming close to releasing my J2ME game... I am kicking up against the 64k size barrier w

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

SELECT * FROM users WHERE Users are not in Blocked
How do I select all users from users table where there users_id is not stored in the block table

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

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here