On Mon, 16 Jun 2003, Serghei Amelian wrote: > On Monday 16 June 2003 16:58, Mihai RUSU wrote: > > > Si daca e case > > sensitive, cum faci sa fie case insesitive comparatia ? > > > > select * from tabela where upper(str1) = upper(str1);
Hmm.. sunt curios de facut benchmark pe o tabela simpla de ID (int) si username (varchar(32)) intre where str1 = str2 pe mysql (deci case insesitive) si upper(str1) = upper(str2) pe pgsql :) ---------------------------- Mihai RUSU Disclaimer: Any views or opinions presented within this e-mail are solely those of the author and do not necessarily represent those of any company, unless otherwise specifically stated.
