How is String 5'9" inserted into a Table

wow · #1 (**permalink**) 06-08-10, 22:23

Hi There,

You have a string 5'9". How can you insert it to a table?

create table t1 (c1 integer, c2 char(20))

insert into t1 (c1, c2) values (1, '5'9"')?

Thanks,

tonkuma · #2 (**permalink**) 06-08-10, 22:30

Code:

------------------------------ Commands Entered ------------------------------
create table t1 (c1 integer, c2 char(20));
------------------------------------------------------------------------------
DB20000I  The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
insert into t1 VALUES(1, '5''9"');
------------------------------------------------------------------------------
DB20000I  The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
SELECT * FROM t1;
------------------------------------------------------------------------------

C1          C2                  
----------- --------------------
          1 5'9"                

  1 record(s) selected.

dav1mo · #3 (**permalink**) 06-10-10, 08:08

Or the better way to do it were design the tables a bit differently and have a column called feet an another called inches. Then put the appropriate symbol in the display.
Dave

r937 · #4 (**permalink**) 06-10-10, 10:31

Quote:

Originally Posted by dav1mo

... a column called feet an another called inches.

how horribly unstandard

surely a single column called centimetres would be better

dav1mo · #5 (**permalink**) 06-10-10, 10:38

Yes, but then we Americans would have to have a conversion calculator imbeded in our browser. I think quite a few would first need a lesson to convert the feet to inches as well.
Dave

dav1mo · #6 (**permalink**) 06-10-10, 10:45

WOW,
I wanted to let you know that storing the data in my "horribly unstandard" 2 columns or in Rudy's single column, will make it much easier for you to find supsects that are within a certain height.
Dave