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.
Did you know?Explore Trending and Topic pages for more stories like this.
Please explain this behavior.
Thanks
No comments posted yet

Your Answer:

Login to answer
191 Like 17 Dislike
Previous forums Next forums
Other forums

The page should be expire when cilck back button
hi,
i'm new to php world.
i create user registration page.
when i submit it,data goes to my

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it

How to convert this array to string
I am having problems converting this array to a string
using print_r($val[1]); I get:
Code: [

Blogging s/w
heya frndz!!! i want to start a blog.... m looking for a s/w like oscommerce which is thr for e-comm

ImageCreate()
When I create an image and add text to it I want my text to be replaced with a PNG image, because th

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

PHP loop
Okay so I have several "articles" stored in a mysql database and am attempting to echo tho

Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.


validating url
im trying to validate url's sent to me by a form
the url's im collecting are for placing banners

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash