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

Floating Point Precision Loss
I'm writing a program to draw a three-dimensional cube (with a corner cut off) without using any 3D

Login logout link help
Hi all,

Im new to php and Im having trouble creating a login/logout link for my page that dis

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

How can I uploading Transactional Data from Legacy to New SAP system
Hell Gurus,

I am overwhelmed with questions on how to migrate huge volume of Sales Orders

Why do I get this error
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/a5488351/public_html/b

Inter Company -- Resources Related Billing (Services Industry)
Hello,

My company has a scenario where:
Company A bills Company C for INTER (cross

OPINIONS WANTED
This is my login page code, and I want your opinion on it please!

Code: // Login ~ CHECKS

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

Why is the logic of this simple code not working?
Hey, I'm trying to determine if a table already exists in mysql, but doing a query first with mysql_