Member Avatar for tinuke

Hi there,am tinuke a software developer.
I use ASP well,but i just started learning PHP/MYSQL.
Is there a way to create a hyperlink data type like we have in MS ACCESS? I need to upoad an address to the database as a link.Pls help :sad:

  • 3 Contributors
  • 2 Replies
  • 324 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by MeSampath
Member Avatar for tomstone

Hi Tinuke, Did you ever get a mySQL datatype for a hyperlink (as in MSAccess? I have the same problem and can't find the answer anywhere!
Tom

Member Avatar for MeSampath

Hi,

few thoughts;

You may try with "longtext" or "text" datatypes in MySQL.

When you choose "hyperlink" in MsAccess, it is treated as String datatype with the length of "536870910". (you may find this, by using oledb connection and load the schema (i have tried in .net dataset))

Thank you,

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.