Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think the email and url validation methods are a good reference here, eg. the email method:</p> <pre><code>email: function(value, element) { return this.optional(element) || /^((([a-z]|\d|[!#\$%&amp;'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+(\.([a-z]|\d|[!#\$%&amp;'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+)*)|((\x22)((((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(([\x01-\x08\x0b\x0c\x0e-\x1f\x7f]|\x21|[\x23-\x5b]|[\x5d-\x7e]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(\\([\x01-\x09\x0b\x0c\x0d-\x7f]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))))*(((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(\x22)))@((([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.)+(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.?$/i.test(value); }, </code></pre> <p><a href="http://projects.scottsplayground.com/email_address_validation/lib/email.js" rel="nofollow noreferrer">The script to compile that regex</a>.</p> <p>In other words, replacing your arbitrary list of "crazy moon" characters with this could help:</p> <pre><code>[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF] </code></pre> <p>Basically this avoids the character encoding issues you have elsewhere by replacing the needs-encoding characters with more general definitions. While not necessarily more readable, so far it's shorter than your full list.</p>
    singulars
    1. This table or related slice is empty.
    1. POJavaScript validation issue with international characters
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJörn Zaefferer
    1. USJörn Zaefferer
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POJavaScript validation issue with international characters
      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. VTAcceptedByOriginator
    1. COJust to clarify on why this worked. If your .js file is enconded in a character encoding all characters inside regex expressions inside it will be represented on that encoding, even if your webpage uses another encoding. In my projects I simply encode EVERYTHING that can contain international strings in UTF-8. This includes .js files. What probably happened to Jeff was that his .js files were encoded in a charset and his page was parsed with another charset, his HTTP requests/response probably encoded with the same charset as the page. This explains why it worked on the debugger.
      singulars
      1. PO
      1. USHoffmann
    2. COAnother thing, try alert("áéíóú") if it shows right your javascript file is encoded in the same encoding as your page. Yet another solution is to simply include your javascripts with: <script src="myscripts.js" charset="ISOsomething" /> where ISOsomething is the encoding of your .js file. This is a common error because most IDEs create .js files in their default encoding which is almost never UTF-8 by default.
      singulars
      1. PO
      1. USHoffmann
 

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