Posted by J.O. Aho on 06/01/06 18:27

Frankly wrote:
>>> yes, many thoughts of questions :) are now clear. We will get back to
>>> linux in the near future.
>>> perhaps i can use my old laptop.
>>> I did try to find these answers but couldnt in a way that I can
>>> understand.
>>> I wont be inserting pictures in the database but links or statements to
>>> pictures.. would that data type be varchar?
>> Short text, up to 255 characters long can be stored in a column that uses
>> varchar().
>>
>> There are types for big size text too, think it's text.
>>
>> If you want to store images in the database, then blob is the type to use.
>
> isnt it better not to store images in the database.

Yes, you are right, it's better to store them outside the database, but the
option to store the images in the database exist.


> I am thinking about 4
> pics per apartment at about 65k. I have found about 200 buildings some of
> which are well above 25 flights and about 15 apartments per floor and of
> course I have 4 floor walk ups and have talked many into faxing me when
> apartments become available for others i was told to call every 2 weeks. <--
> DateLastCalled in managements table will be needed.
> apartments in the same line can share pictures soooo I should also have
> ApartmentNumber indexed.
> I have a pretty good print out of all the file types.
> Text is 65,535 characters. I will be using about 4 varchars at 255 for
> details.
>
> as far as what to do with the pictures I must have read that 100 time. I am
> sure i can find it again.
>
>
>>
>>> I also had a hard time with hyper links - I understand there is no
>>> hyperlink data type so would that also be varchar?
>> Yes, as it's really a text, varchar is a good option here too, as long as
>> you know your links are less than 255 characters (usually is).
>
> as i understand it just typing in the hyper link would make it just text.

No, or yes... hyperlinks are just a string

<a href="http://example.net">something</a>

regardless if you store it in a standard html page or in a database or use php
to generate the hyperlink, it will work the same way when the user sees it.

of course when you store it in the database, you only store the url and let
the php script add the html-tags.


> dont i have to do some kind of script? when the properties are shown I
> would like there to be a
> hyper link to that apartments page. I am not going to do that now. I would
> like to table structure to be ready for when I am ready.

Yes, of course you will need some kind of script here, specially when you are
generating a lot of dynamic pages that aren't really stored. You link all the
apartments to the same script page, but you have a variable that tells which
apartments data should be displayed.


//Aho

[Back to original message]