Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In my original answer, I unthinkingly suggested using a <code>Comparator</code>, but this causes the <code>TreeSet</code> to violate the <a href="http://java.sun.com/j2se/1.4.2/docs/api/java/lang/Object.html#equals(java.lang.Object)" rel="noreferrer"><code>equals</code> contract</a> and is a bug waiting to happen:</p> <pre><code>// Don't do this: Set&lt;String&gt; setA = new TreeSet&lt;String&gt;(String.CASE_INSENSITIVE_ORDER); setA.add("hello"); setA.add("Hello"); System.out.println(setA); Set&lt;String&gt; setB = new HashSet&lt;String&gt;(); setB.add("HELLO"); // Bad code; violates symmetry requirement System.out.println(setB.equals(setA) == setA.equals(setB)); </code></pre> <hr> <p>It is better to use a dedicated type:</p> <pre><code>public final class CaselessString { private final String string; private final String normalized; private CaselessString(String string, Locale locale) { this.string = string; normalized = string.toUpperCase(locale); } @Override public String toString() { return string; } @Override public int hashCode() { return normalized.hashCode(); } @Override public boolean equals(Object obj) { if (obj instanceof CaselessString) { return ((CaselessString) obj).normalized.equals(normalized); } return false; } public static CaselessString as(String s, Locale locale) { return new CaselessString(s, locale); } public static CaselessString as(String s) { return as(s, Locale.ENGLISH); } // TODO: probably best to implement CharSequence for convenience } </code></pre> <p>This code is less likely to cause bugs:</p> <pre><code>Set&lt;CaselessString&gt; set1 = new HashSet&lt;CaselessString&gt;(); set1.add(CaselessString.as("Hello")); set1.add(CaselessString.as("HELLO")); Set&lt;CaselessString&gt; set2 = new HashSet&lt;CaselessString&gt;(); set2.add(CaselessString.as("hello")); System.out.println("1: " + set1); System.out.println("2: " + set2); System.out.println("equals: " + set1.equals(set2)); </code></pre> <p>This is, unfortunately, more verbose.</p>
    singulars
    1. This table or related slice is empty.
    1. POCollection removeAll ignoring case?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmmc
    1. USMcDowell
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCollection removeAll ignoring case?
      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. CONo need to roll your own Comparator. The String class provides one for you: http://java.sun.com/javase/6/docs/api/java/lang/String.html#CASE_INSENSITIVE_ORDER
      singulars
      1. PO
      1. USbanjollity
    2. CO@bankollity. Thanks! - that's been there since Java 1.2 and I've never noticed it. Code amended.
      singulars
      1. PO
      1. USMcDowell
    3. COWow that was extremely simple to implement although the documentation leads you to believe that the comparator is used solely for sorting. TreeSet(Comparator c) : Constructs a new, empty set, sorted according to the specified comparator. http://java.sun.com/j2se/1.4.2/docs/api/java/util/TreeSet.html#TreeSet%28java.util.Comparator%29 . I am glad it worked though, Thank you so much for your response!
      singulars
      1. PO
      1. USuser84786
 

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