Search

URI Data Type by BradleyDonMorris

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

2
0
Sign in
to vote
Type: Suggestion
ID: 766142
Opened: 10/4/2012 11:20:51 AM
Access Restriction: Public
0
Workaround(s)
Please consider adding a URI data type such as you have with xml, geometry, geography, etc.
Details (expand)

Product Language

English

Category

SQL Engine

Proposed Solution

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

Primary Benefit

Improved Reliability

Other Benefits

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)

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
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
Sign in to post a workaround.