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

Reply via email to