Peter, > Linux distributions have been shipping with non-C locale settings for a > long, long time, so that complaint would be invalid.
In US distributions it's a recent thing. The switch to non-C locales is a recent thing; RH Enterprise 3.0, and SuSE 9.0. But I expect in Europe you've been using non-C locales for a while. I'd like to have an explanation of this somewhere else newbies are liable to read it, *before* their first production "LIKE" query doesn't use an index. Where would be appropriate? And, for English speakers, what exactly is wrong with using 'C' locale instead of the environment one? -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]