Hi Helen, > > p.51 (end of first paragraph): > > A CONTAINING search is not case-sensitive. > > > Maybe a comment/warning on accent-sensitivity? > > I think you might be the first person involved with this text who has > day-to-day experience with data in a language with accented > characters. What is there to say?
Two short tests using iso8859_1 and utf8 reveal that CONTAINING is accent-sensitive, i.e. 'ABCDEFG' containing 'DÉF' is false, *unless* an accent-insensitive collation is used. I assume it's the same with other character sets. Cheers, Paul ------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 _______________________________________________ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs