Øystein Grøvlen <[EMAIL PROTECTED]> writes:
> Andreas Korneliussen (JIRA) wrote:
>
>> String.toUpperCase(..) with english locale, should return a string
>> with the same number of characters, and it should therefore be valid
>> to do a check of number of characters before doing any conversions.
>
> Is it correct to always use English locale in this case? Ref the
> reference guide on SQL identifiers:
And is it correct to upcase the identifiers before comparing them in
findColumnName()?
ResultSet rs = stmt.executeQuery("select \"x\", x from t");
rs.next();
int smallX = rs.getInt("x"); // which x is this?
int bigX = rs.getInt("X"); // and this?
In derby both smallX and bigX get the value of column 1, whereas I
would expect them to get the values from column 1 and 2,
respectively. I haven't checked what the spec says.
--
Knut Anders
