the field in the database should be a standard varchar filed.
you can convert it to a link on the page that shows the information by adding the binding in the a tag, for example:
<a href="<?php echo($row_recordsetName['ColumnName']); ?>"><?php echo($row_recordsetName['ColumnName']); ?></a>