python - MySQL SELECT DISTINCT is case insensitive? -

i trying cleanup data imported mysql pandas dataframe.

some appears as:

variable 

others as:

variable 

when use

select distinct 

it seems mysql treats variable equivilent variable.

when import r though r sees variable , variable different. , running

as.factor 

gives me 2 factors. how can make mysql's select distinct case sensitive can detect , fix data import r analyse?

if wanna detect lower , upper cases in table use this

   select name                        //this select lower names    yourtable     name = binary lower(name)     union     select name                      //this select upper names    yourtable     name = binary upper(name)     union                       // select not lower , not upper     select name     yourtable     name != binary upper(name)    ,   name != binary lower(name) 

demo here