<p>Inside an asp.net page, should I use</p>

<pre><code>&lt;html&gt;&lt;title&gt;My page's title from México&lt;/title&gt;&lt;/html&gt;
</code></pre>

<p>Or </p>

<pre><code>&lt;html&gt;&lt;title&gt;My page&amp;rsquo;s title from M&amp;eacute;xico&lt;/title&gt;&lt;/html&gt;
</code></pre>

<p>Both examples have the same output. Since asp.net encodes all my pages to utf-8, there is no need to use html entities, is that right?</p>

[{'answer_id': 9023, 'author': 'Nick Berardi', 'author_id': 17, 'author_profile': 'https://Stackoverflow.com/users/17', 'pm_score': 0, 'selected': False, 'text': '<p>Found <a href="http://blog.sqlauthority.com/2007/07/12/sql-server-validate-field-for-date-datatype-using-function-isdate/" rel="nofollow noreferrer">this in the second result</a> in Google when searching for "validate date string sql".</p>\n\n<pre><code>----Invalid date\nSELECT ISDATE(\'30/2/2007\')\nRETURNS : 0 (Zero)\n----Valid date\nSELECT ISDATE(\'12/12/20007\')\nRETURNS : 1 (ONE)\n----Invalid DataType\nSELECT ISDATE(\'SQL\')\nRETURNS : 0 (Zero)\n</code></pre>\n'}, {'answer_id': 9029, 'author': 'Marius', 'author_id': 1008, 'author_profile': 'https://Stackoverflow.com/users/1008', 'pm_score': 0, 'selected': False, 'text': '<p>Make sure SQL Server knows the order of Days, Months and Years in your string by executing</p>\n\n<pre><code>SET DATEFORMAT mdy;\n</code></pre>\n'}, {'answer_id': 9039, 'author': 'Mike Woodhouse', 'author_id': 1060, 'author_profile': 'https://Stackoverflow.com/users/1060', 'pm_score': 1, 'selected': False, 'text': "<p>My goodness, if the question was about Microsoft SQL Server then we'd have been in business!</p>\n\n<p>Sybase, sadly, is a whole 'nother database these days, since about 1997, in fact, give or take a year.</p>\n\n<p>If the input format simply has to be 'DD-MON-YYYY' and no exceptions, then I think a fair amount of validation was be achieved by slicing the input using SUBSTR(), after first doing some simple things, such as checking length.</p>\n\n<p>I thought that recent releases of Sybase (SQL Anywhere 11, for example) have regular expression support, however, although it's been a while since I've had to suffer T-SQL. Some googling leaves me in rather more doubt.</p>\n"}, {'answer_id': 941940, 'author': 'Rebthor', 'author_id': 103630, 'author_profile': 'https://Stackoverflow.com/users/103630', 'pm_score': 2, 'selected': True, 'text': "<p>I'm having a similar issue.  You might be able to do something like this:</p>\n\n<pre><code>SET arithabort arith_overflow off\nSET @the_date = CAST(@date_string AS DATETIME)\nIF @the_date is NULL\n    set @the_date = getdate()\nSET arithabort arith_overflow on\n</code></pre>\n\n<p>However, this doesn't work well in a select.  It will work well in a cursor (boo) or in logic before / after a SQL batch.</p>\n"}, {'answer_id': 941999, 'author': 'Vincent Buck', 'author_id': 90352, 'author_profile': 'https://Stackoverflow.com/users/90352', 'pm_score': 0, 'selected': False, 'text': '<p>Did you try <code>convert</code> instead of <code>cast</code>?</p>\n\n<pre><code>select convert( datetime , @date_string ) \n</code></pre>\n'}, {'answer_id': 987884, 'author': 'B0rG', 'author_id': 122093, 'author_profile': 'https://Stackoverflow.com/users/122093', 'pm_score': 1, 'selected': False, 'text': "<p>Can't you do something like this:</p>\n\n<pre><code>SELECT @the_date = CASE @date_string\n                      WHEN '[0-9][0-9]-[A-Z][A-Z][A-Z]-[0-9][0-9][0-9][0-9]'\n                      THEN CONVERT(datetime, @date_string)\n                      ELSE GETDATE()\n                   END\n</code></pre>\n\n<p>?</p>\n"}]
['https://Stackoverflow.com/questions/9022', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/296/']