Re: query of queries LIKE case sensitivity

2002-09-21 Thread Jochem van Dieten
Alex Hubner wrote: >>I should have been more specific. SQL is case sensitive if >>the collation >> is case sensitive, which I believe to be the case for ColdFusion >>(although not explicitly defined). >>In that light, it is not a bug to be fixed. > > Jochem, I agreee that this is not a bug, b

RE: query of queries LIKE case sensitivity

2002-09-20 Thread Alex Hubner
> I should have been more specific. SQL is case sensitive if > the collation > is case sensitive, which I believe to be the case for ColdFusion > (although not explicitly defined). > In that light, it is not a bug to be fixed. Jochem, I agreee that this is not a bug, but at least a dubious b

Re: query of queries LIKE case sensitivity

2002-09-20 Thread Jochem van Dieten
Alex Hubner wrote: >>It is not a bug to be fixed. SQL is case sensitive. > > > Not always. You can have case/accent-insensitive in most SQL sintax, > including data retrieve. LIKE operators and full-text searches can be > case-insensitive, why case-sensitive is mandatory in CF query of > query's

Re: query of queries LIKE case sensitivity

2002-09-20 Thread jon hall
Friday, September 20, 2002, 5:26:27 PM, you wrote: JvD> jon hall wrote: >> It seems that query of query's LIKE keyword in CF5 is case sensitive. >> Is there a way around this? If not, does anyone know if this is fixed >> in MX? JvD> It is not a bug to be fixed. SQL is case sensitive. I didn't sa

RE: query of queries LIKE case sensitivity

2002-09-20 Thread Alex Hubner
> It is not a bug to be fixed. SQL is case sensitive. Not always. You can have case/accent-insensitive in most SQL sintax, including data retrieve. LIKE operators and full-text searches can be case-insensitive, why case-sensitive is mandatory in CF query of query's? []'s! Alex | alex hübner

Re: query of queries LIKE case sensitivity

2002-09-20 Thread Jochem van Dieten
jon hall wrote: > It seems that query of query's LIKE keyword in CF5 is case sensitive. > Is there a way around this? If not, does anyone know if this is fixed > in MX? It is not a bug to be fixed. SQL is case sensitive. Jochem ___

RE: query of queries LIKE case sensitivity

2002-09-20 Thread Raymond Camden
The only way around it is to make a copy of the column in your original query, a upper(or lower) cased copy. Then do your compare against that. In MX, we added ucase,lcase to the syntax, so you can do case insensitive matches. =