Genius! Thanks Richard,
The old locale was C and the new one English_United Kingdom.1252 I created a new index with "varchar_pattern_ops" and off it went! > the strange thing is my btree indexes on the uk roads data work fine. > > Do they use like, or explicit range-checks? > > I wasn't using like, which is why they were working. adding a new index then using the like operator didn't work. Thanks again. Will
