Le roy Arnaud wrote: > 1 - Modify the provider : Add Upper in the select command (i can do)
I think this will be best solution. But will upper work for some special characters? > 2 - Modify the struct of the users table for that the select is case > insentive (I don't know how to do that) it's possible ? maybe with > collate ? Is the modifying structure of right decision? What about application already running? Will be available the upgrade script? BTW what about saving usernames in upper/lower case from app. (to avoid problems with upper in FB)? The upgrade will be easy and the implementation too. Maybe we can use upper from FB but it needs to be tested with some weird chars. :) -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider