Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There is no error - you're verifying the string in the debugger, which automatically escapes strings - e.g. <code>"Hello \ Goodbye"</code> will show in the debugger as <code>"Hello \\ Goodbye"</code>.</p> <p>That said, the debugger behaves differently depending on how you view a string (and also whether it's C#/VB of course):</p> <ul> <li>Hover over a string (most common) you'll get the escaped version in a tooltip</li> <li>Watch window/Locals etc also display escaped version</li> <li>If you select the 'Text' visualiser you'll see the unescaped version - <em>which is what you should do to actually verify your string.</em></li> <li>Html visualiser does exactly what it says on the tin :)</li> </ul> <p><em>Update</em></p> <p>Okay, so I've gone a bit further and fired up VS2010, please create a test project and follow it through.</p> <pre><code>[TestMethod] public void TestMethod1() { string a = @"`1234567890-=[]\ ;',./\~!@#$%^&amp;*()_+{}|:""&lt;&gt;?|"; Console.WriteLine("Original:"); Console.WriteLine("{0}", a); string htmlEncoded = System.Web.HttpUtility.HtmlEncode(a); Console.WriteLine("Html Encoded:"); Console.WriteLine("{0}", htmlEncoded); } </code></pre> <p>(obviously I've used a verbatim string initially to avoid having to escape anything except the double quote).</p> <p>Console output of the test is:</p> <pre><code>Original: `1234567890-=[]\ ;',./\~!@#$%^&amp;*()_+{}|:"&lt;&gt;?| Html Encoded: `1234567890-=[]\ ;&amp;#39;,./\~!@#$%^&amp;amp;*()_+{}|:&amp;quot;&amp;lt;&amp;gt;?| </code></pre> <p>Equally if you breakpoint the end of the test and start mucking about with the visualisers:</p> <p>Hover (<code>a</code>):</p> <pre><code>"`1234567890-=[]\\ ;',./\\~!@#$%^&amp;*()_+{}|:\"&lt;&gt;?|" </code></pre> <p>i.e. it's C# escaped in the tooltip and surrounded by quotes.</p> <p>Hover (<code>htmlEncoded</code>):</p> <pre><code>"`1234567890-=[]\\ ;&amp;#39;,./\\~!@#$%^&amp;amp;*()_+{}|:&amp;quot;&amp;lt;&amp;gt;?|" </code></pre> <p>.. again, it's html encoded <strong>and</strong> C# escaped with quotes</p> <p>Text (<code>htmlEncoded</code>):</p> <pre><code>`1234567890-=[]\ ;&amp;#39;,./\~!@#$%^&amp;amp;*()_+{}|:&amp;quot;&amp;lt;&amp;gt;?| </code></pre> <p>.. No c# escaping</p> <p>Html (<code>htmlEncoded</code>):</p> <pre><code>`1234567890-=[]\ ;',./\~!@#$%^&amp;*()_+{}|:"&lt;&gt;?| </code></pre> <p><em>In Times New Roman script of course :)</em></p> <p>Which I believe takes us back to the original string - which also shows that the scenario you're describing can't be the case - unless you have read an escaped string as being "correct", when in fact it's not. Html doesn't require <code>\</code> to be escaped.</p>
    singulars
    1. This table or related slice is empty.
    1. POWrong encoding by response.write
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAndras Zoltan
    1. USAndras Zoltan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWrong encoding by response.write
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI used the text view of the debugger in VS2010 which gave the first result. The second result, which was wrong, was only shown in the web application
      singulars
      1. PO
      1. USJan
    2. CO@Jan - sorry, but in my opinion the only cause of this problem is down to debugger visualisation - unless some other code in your project is modifying your string and physically double-escaping backslash characters. However, since ` \ ` characters do not need escaping in html, you would see ` \\ ` in the outpu page. Ergo the double-slash was never there in html encoded string except when you looked at it - and that can only happen if the visualiser you used was one of those that escapes the strings that it shows.
      singulars
      1. PO
      1. USAndras Zoltan
    3. COthe html visualizer gave the expected result. However the result in the html did not. I guess it was something else. Maybe the JS code use to show the text.
      singulars
      1. PO
      1. USJan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload