url in mysqldatabase

Is there a possibility (a data-type) to insert an URL-adress in a
field of a mysql-database

TIA

xyzit wrote:
> Is there a possibility (a data-type) to insert an URL-adress in a
> field of a mysql-database
>
> TIA

It's just character data. VARCHAR should do quite nicely.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

In article <hq6dnVRgYv7mBU_ZnZ2dnUVZ_v2dnZ2d@comcast.com>,
jstucklex@attglobal.net says...
> xyzit wrote:
> > Is there a possibility (a data-type) to insert an URL-adress in a
> > field of a mysql-database
> >
> > TIA
>
> It's just character data. VARCHAR should do quite nicely.
>
>
But, is it "clickable" ?

>> It's just character data. VARCHAR should do quite nicely.
>>
>>
> But, is it "clickable" ?

wwwwwwwwwhhhhhhhhhaaaaaaaaaaattttttttttttttt ?

JB

"Clickable" is a GUI (graphical user interface) notion or feature, not a
database data type consideration.

Cheers!

~ Duane Phillips.

"xyzit" <xyzitabc@hotmail.com> wrote in message
news:MPG.1f3d8cba990da5a5989688@newsbin.telenet.be ...
> In article <hq6dnVRgYv7mBU_ZnZ2dnUVZ_v2dnZ2d@comcast.com>,
> jstucklex@attglobal.net says...
>> xyzit wrote:
>> > Is there a possibility (a data-type) to insert an URL-adress in a
>> > field of a mysql-database
>> >
>> > TIA
>>
>> It's just character data. VARCHAR should do quite nicely.
>>
>>
> But, is it "clickable" ?

xyzit wrote:
> In article <hq6dnVRgYv7mBU_ZnZ2dnUVZ_v2dnZ2d@comcast.com>,
> jstucklex@attglobal.net says...
>
>>xyzit wrote:
>>
>>> Is there a possibility (a data-type) to insert an URL-adress in a
>>>field of a mysql-database
>>>
>>>TIA
>>
>>It's just character data. VARCHAR should do quite nicely.
>>
>>
>
> But, is it "clickable" ?

Whether it is clickable or not has nothing to do with the database.
That is entirely up to whatever GUI is being used to display the data.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"xyzit" <xyzitabc@hotmail.com> wrote in message
news:MPG.1f3d8cba990da5a5989688@newsbin.telenet.be ...
> In article <hq6dnVRgYv7mBU_ZnZ2dnUVZ_v2dnZ2d@comcast.com>,
> jstucklex@attglobal.net says...
>> xyzit wrote:
>> > Is there a possibility (a data-type) to insert an URL-adress in a
>> > field of a mysql-database
>> >
>> > TIA
>>
>> It's just character data. VARCHAR should do quite nicely.
>>
>>
> But, is it "clickable" ?

There is no "URL" datatype, if that is what you mean. You have to put it in
a character field. Of course you could write your own constraints to check
if the string is a valid URL (although that would be not that easy).

In article <44d61a49$0$10470$ba620e4c@news.skynet.be>, anti@spam.com
says...
>
> "xyzit" <xyzitabc@hotmail.com> wrote in message
> news:MPG.1f3d8cba990da5a5989688@newsbin.telenet.be ...
> > In article <hq6dnVRgYv7mBU_ZnZ2dnUVZ_v2dnZ2d@comcast.com>,
> > jstucklex@attglobal.net says...
> >> xyzit wrote:
> >> > Is there a possibility (a data-type) to insert an URL-adress in a
> >> > field of a mysql-database
> >> >
> >> > TIA
> >>
> >> It's just character data. VARCHAR should do quite nicely.
> >>
> >>
> > But, is it "clickable" ?
>
> There is no "URL" datatype, if that is what you mean. You have to put it in
> a character field. Of course you could write your own constraints to check
> if the string is a valid URL (although that would be not that easy).
>
>
>
>
What I want is, when you type a valid url-adress in a certain field of a
databaserecord ( http://www.zot.be), and when I click (in my website )
on it that I go to that URL-adress.
Meanwhile I found it - in Firefox it is "clickable" - in IE, it is not
-there it is just "dead" text.
(I am not a professional - I just try things - sorry)

xyzit wrote:
> In article <44d61a49$0$10470$ba620e4c@news.skynet.be>, anti@spam.com
> says...
>
>>"xyzit" <xyzitabc@hotmail.com> wrote in message
>>news:MPG.1f3d8cba990da5a5989688@newsbin.telenet. be...
>>
>>>In article <hq6dnVRgYv7mBU_ZnZ2dnUVZ_v2dnZ2d@comcast.com>,
>>>jstucklex@attglobal.net says...
>>>
>>>>xyzit wrote:
>>>>
>>>>>Is there a possibility (a data-type) to insert an URL-adress in a
>>>>>field of a mysql-database
>>>>>
>>>>>TIA
>>>>
>>>>It's just character data. VARCHAR should do quite nicely.
>>>>
>>>>
>>>
>>>But, is it "clickable" ?
>>
>>There is no "URL" datatype, if that is what you mean. You have to put it in
>>a character field. Of course you could write your own constraints to check
>>if the string is a valid URL (although that would be not that easy).
>>
>>
>>
>>
>
> What I want is, when you type a valid url-adress in a certain field of a
> databaserecord ( http://www.zot.be), and when I click (in my website )
> on it that I go to that URL-adress.
> Meanwhile I found it - in Firefox it is "clickable" - in IE, it is not
> -there it is just "dead" text.
> (I am not a professional - I just try things - sorry)
>
>

That is a function of the display of the data, not the storage. The
right way to do this is to create an anchor tag for the URL.

It has nothing at all to do with the database.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"xyzit" <xyzitabc@hotmail.com> wrote in message
news:MPG.1f4458f8e76034cd989689@newsbin.telenet.be ...
> In article <44d61a49$0$10470$ba620e4c@news.skynet.be>, anti@spam.com
> says...
>>
>> "xyzit" <xyzitabc@hotmail.com> wrote in message
>> news:MPG.1f3d8cba990da5a5989688@newsbin.telenet.be ...
>> > In article <hq6dnVRgYv7mBU_ZnZ2dnUVZ_v2dnZ2d@comcast.com>,
>> > jstucklex@attglobal.net says...
>> >> xyzit wrote:
>> >> > Is there a possibility (a data-type) to insert an URL-adress in a
>> >> > field of a mysql-database
>> >> >
>> >> > TIA
>> >>
>> >> It's just character data. VARCHAR should do quite nicely.
>> >>
>> >>
>> > But, is it "clickable" ?
>>
>> There is no "URL" datatype, if that is what you mean. You have to put it
>> in
>> a character field. Of course you could write your own constraints to
>> check
>> if the string is a valid URL (although that would be not that easy).
>>
> What I want is, when you type a valid url-adress in a certain field of a
> databaserecord ( http://www.zot.be), and when I click (in my website )
> on it that I go to that URL-adress.
> Meanwhile I found it - in Firefox it is "clickable" - in IE, it is not
> -there it is just "dead" text.
> (I am not a professional - I just try things - sorry)

Oh, just store it as a valid HTML link tab. Such as:
<A HREF="http://www.lootersofloathing.com">Return To Main Menu</A>

If you display that on a web page, it would be a clickable link. In this
case the url is the http://www.lootersofloathing.com and the "Return To Main
Menu" is the text that shows up. You could just make the text the same as
the url.