Hi Tom,
On Sat, 1 Oct 2005, Tom Lane wrote: <snip>
So yeah, ILIKE looks just about completely broken for multibyte encodings. Maybe it would be best to pass both strings through lower() and then do a normal LIKE comparison? The regexp code doesn't look better, btw, just differently broken ...
So any chance to fix it before beta 3 (and also backpatch?) ? Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
