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

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

FTP issues
Hi all,


I am currently facing some serious problems with a script and really need some ad

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

Auto-populating dropdowns and multiple forms.
Here's what I have so far:

First drop down = select a state (works)
This populates the sec

remove trailing slash from array
I have the following array which contains trailing slashes I need to remove. What is the best way to

Ajax not working on IE 6 for Windows CE
I've created a webpage which uses the classis Ajax in following format:view plaincopy to clipboardpr

Pspell with my own dictionary
Hello!
I've tested two cases using pspell functions.
1)
Code: $dictionary_link = pspell_new

Need help in Generating Combinations
Need help generating all possible combination of names in an array

Lets say i have the follow

a dificult string search
Hi I don't know a way around this. I want the user to input a password, but to make it a bit complca

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s