URI Data Type by BradleyDonMorris

Closed

as Won't Fix Help for as Won't Fix

Type:	Suggestion
ID:	766142
Opened:	10/4/2012 11:20:51 AM
Access Restriction:	Public

Workaround(s)

view

Please consider adding a URI data type such as you have with xml, geometry, geography, etc.

Details (expand)

English

SQL Engine

Add URI data type based on or very similar to .Net System.Uri.

Improved Reliability

No more having to guess how long a varchar field should be to store a URI (2083?). Oracle has it. Why don't we have it, too? (http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/DATURI/Default.aspx)

0 attachments

Posted by Microsoft on 10/9/2012 at 11:52 AM

Hello,
Thanks for your feedback. Our general approach with regards to adding types has been to provide the primitive types that are hard to implement and optimize. We have an extensibility mechanism via SQLCLR that can be used to define any complex type that you want. So we don't plan on adding a specific type for Uri. We might reevaulate the request if we hear about it a lot from customers.

--
Umachandar, SQL Programmability Team

Microsoft