> 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? > > I think you get no trouble with the upper-clause if you use it for both side of the "=".
select * from users where UPPER(username) = UPPER('toto') I hope :-) FB handles special characters equal on each side. Niels ___________________________________________________________ Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de ------------------------------------------------------------------------- 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