What is the best handling of a UNC Pathname?
What is the max length of a path name?
Which is the best type of field in SQL Server to use for a path name?
Thanks
I would store this in a VARCHAR field with the appropiate value.
HTH, Jens Suessmeyer,
|||What is the max length of the path & filename? It used to be 255 chars but I believe it has grown since then.
|||Maximum name of a UNC path is 260 unicode characters (MAX_PATH defined in windows.h I believe). Search google for MAX_PATH to see lots of people talking about this issue.
So a NVARCHAR(260) should be sufficient unless you allow the \\?\ prefix that bypasses normal MAX_PATH length. If you only have one locale you use for paths, then you can potentially use VARCHAR(260).
No comments:
Post a Comment