File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes create a hyperlink field in database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "create a hyperlink field in database" Watch "create a hyperlink field in database" New topic

create a hyperlink field in database

varsha rao

Joined: Mar 06, 2006
Posts: 26
i am using Ms Access as my back end and i want to create a table with a field whose type is a hyperlink.What should be the data type that i should specify in my SQL create statement in the JAVA prg. Should it be varchar or is there anything else
anybody who knows this please reply
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30076

Welcome to JavaRanch!

Yes, you would use a varchar type field. A URL is just text. It has meaning when you pull it out of the database and display it as a link.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: create a hyperlink field in database
Similar Threads
How to get dates to ActionForm in Struts
how to save as XML with some predefined extensions
Create Table in MySQL
Getter/Setter vs Private
How to Validate JTextField to Does not Accept NumberS