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

finding key position of specified value in multi-dimensional array
Code: $openedfile = fopen($tfc_file4, "r");
$rc = 1;
while(!feof($openedfile))
{<

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

need to apply an if/else statement to Tim Thumb script
Not sure how to work this. I essentially want to call a variety of image sizes based on which style

Strange HTML Tag?
I recently noticed some odd HTML appear in some of the websites I host. Not all of them are run on a

Load Animated Image while cache is serve
I have a page that loads up using cache and took about 1 to 2 minutes before it loads to the page. <

Help Optimizing code
Good Morning,

I wrote a small import function for a website of mine and I know there has to b

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

Simple code help with redirects
I am trying to figure out a redirect script that detects if the browser is IE 7 and if it does, redi

Mysql error message
help me find out what this error message means:

"Duplicate entry '0' for key 'PRIMARY'&q

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")