Re: [Maria-developers] On constructing ref access from mis-matched charset comparisons

Hi Sergey, On 02/24/2017 04:23 AM, Sergey Petrunia wrote: > Hi Alexander, > > I've got a question about mis-matched charset comparisons and ref access > method. > > == Short form == > I know that VARCHAR comparisons over mis-matching charsets cannot be used for > constructing index lookups

Re: [Maria-developers] On constructing ref access from mis-matched charset comparisons

Hi, Sergey! On Feb 24, Sergey Petrunia wrote: > == Long form == > > === Example dataset === > > create table t0 ( > a varchar(32) character set utf8 collate utf8_general_ci > ); > > create table t1 ( > a varchar(32) character set latin1 collate latin1_swedish_ci, > col1 varchar(32), >

[Maria-developers] On constructing ref access from mis-matched charset comparisons

Hi Alexander, I've got a question about mis-matched charset comparisons and ref access method. == Short form == I know that VARCHAR comparisons over mis-matching charsets cannot be used for constructing index lookups into the index over the "narrower" character set column. But is this a real