From: Chuck H. <ch...@gl...> - 2009-04-23 16:53:22
|
On Apr 23, 2009, at 9:34 AM, Mike Schrag wrote: >> If you are determined not to do that, I think you will need a custom >> EOF plugin for MySQL. I think there is one or two on the net >> somewhere, but I have no links to them. > yeah i was going to say -- you should be able to do this completely > right with a custom plugin ... doesn't FB's plugin do insensitive > collation query syntax? public String sqlStringForCaseInsensitiveLike(String value, String column) { StringBuffer sql = new StringBuffer(); sql.append(column); sql.append(" LIKE "); sql.append(value); sql.append(" COLLATE INFORMATION_SCHEMA.CASE_INSENSITIVE"); return sql.toString(); } Did not notice anything for the equals version. Chuck -- Chuck Hill Senior Consultant / VP Development Come to WOWODC'09 in San Fran this June! http://www.wocommunity.org/wowodc09/ |