Posted by Frankly on 06/01/06 16:16

>> 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. 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.
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.



>
>
>> if only PHP can be used to remove the calories from pancakes.
>
> Yeah, just code a load of PHP scripts and you will consume all the
> calories :P
>
>
>
> //Aho

i have a feelings my hair will suffer the biggest loss.

Frank

[Back to original message]