Re: Operator recognition problems with Turkish locale

On Thu, 5 Oct 2006 23:19:02 +0200
Stefaan A Eeckels <[email protected]> wrote:


> The fix is to convert to upper case instead
> (/com/mckoi/database/Operator.java line 348):
> 
>     // Operators that are words, convert to upper case...
>     // Upper case to avoid the Turkish locale problem [sae]
>     op = op.toUpperCase();
>     if (op.equals("IS")) { return is_op; }
>     else if (op.equals("IS NOT")) { return isn_op; }
>     else if (op.equals("LIKE")) { return like_op; }
>     else if (op.equals("NOT LIKE")) { return nlike_op; }
>     else if (op.equals("REGEX")) { return regex_op; }
> 
>     else if (op.equals("IN")) { return in_op; }
>     else if (op.equals("NOT IN")) { return nin_op; }
> 
>     else if (op.equals("NOT")) { return not_op; }
>     else if (op.equals("AND")) { return and_op; }
>     else if (op.equals("OR")) { return or_op; }
> 

Actually, it's not that simple. There are other places where
toLowerCase is used (like the functions) which need to be modified as
well. 

I'll see if I can fix this properly (as we have a Turkish customer, it
is rather important).

Take care,

-- 
Stefaan
-- 
As complexity rises, precise statements lose meaning,
and meaningful statements lose precision. -- Lotfi Zadeh 


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]