Azure的表的存储RowKey限制字符模式？ [英] Azure Table Storage RowKey restricted Character Patterns?

问题描述

有没有受限制的Azure TableStorage RowKeys内字符模式？我一直没能找到任何通过搜索大量的记载。不过，我收到的行为，在某些性能测试是指这样。

Are there restricted character patterns within Azure TableStorage RowKeys? I've not been able to find any documented via numerous searches. However, I'm getting behavior that implies such in some performance testing.

我有一些奇怪的行为与由随机字符RowKeys（测试驱动确实prevent限制字符（/ \\＃？）加上从RowKey发生堵单引号）。结果是我有一个RowKey将插入精细到表，但不能查询（结果是InvalidInput）。例如：

I've got some odd behavior with RowKeys consisting on random characters (the test driver does prevent the restricted characters (/ \ # ?) plus blocking single quotes from occurring in the RowKey). The result is I've got a RowKey that will insert fine into the table, but cannot be queried (the result is InvalidInput). For example:

RowKey: 9}5O0J=5Z,4,D,{!IKPE,~M]%54+9G0ZQ&G34!G+

试图通过这种RowKwy（平等）查询会导致错误（我们的应用程序，使用Azure存储资源管理器，云存储工作室2中）。我接过来一看在请求被通过的提琴手发送：

Attempting to query by this RowKwy (equality) will result in an error (both within our app, using Azure Storage Explorer, and Cloud Storage Studio 2). I took a look at the request being sent via Fiddler:

GET /foo()?$filter=RowKey%20eq%20'9%7D5O0J=5Z,4,D,%7B!IKPE,~M%5D%54+9G0ZQ&G34!G+' HTTP/1.1

它出现在RowKey的％54没有在过滤器逃脱。有趣的是，我得到批量请求表存储在批处理XML包括此RowKey的URI类似的行为。我也看到了类似的行为与嵌入式双引号RowKeys，虽然我还没有分离出的模式呢。

It appears the %54 in the RowKey is not escaped in the filter. Interestingly, I get similar behavior for batch requests to table storage with URIs in the batch XML that include this RowKey. I've also seen similar behavior for RowKeys with embedded double quotes, though I have not isolated that pattern yet.

有没有人共同跨越我的这种行为？我可以很容易地从RowKeys发生限制其他字符，但真的想知道的规则。

Has anyone co me across this behavior? I can easily restrict additional characters from occurring in RowKeys, but would really like to know the 'rules'.

推荐答案

下面的字符不允许在PartitionKey和RowKey领域：

The following characters are not allowed in PartitionKey and RowKey fields:

• 正斜杠（/）字符


• 反斜线（ \\ ）字符


• 数字符号（＃）字符


• 问号（？）字符

请参考以下文章了解更多信息：
<一href=\"http://msdn.microsoft.com/en-us/library/windowsazure/dd179338.aspx\">http://msdn.microsoft.com/en-us/library/windowsazure/dd179338.aspx

Please refer to the following article for further information: http://msdn.microsoft.com/en-us/library/windowsazure/dd179338.aspx

这篇关于Azure的表的存储RowKey限制字符模式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！