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

"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP th

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

Sum of Values in an Array
This is probably really simple... but it's been years since I've written anything, so bare with me!<

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

constructor ?
i have written this program and made 3 constructors in the class and i want to call them in the main

generate seo frienly url from a text like wordpress
Convert: "åäö" to "aao", "space" to "-", "!?&q

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

Stumped by Third Day of Month problem
I am trying to build an algorithm that will essentially do this:
Code: [Select]$this_month = Oct

HTML Form Server Side Validation
Hi, Im new here, im currently doing a website for a friend, and I have designed using snippets from