MySQL utf-8 PASSWORD() function outputs different values

MySQL utf-8 PASSWORD() function outputs different values

I have a question regarding mysql. I've been trying to fix this for quite
some time and am out of ideas.
I have a table that conatins user information. Three of this table's
columns are Username, PW and Famille.
The Username I am interested in is '12234567' and the Famille's value is
'Testé'.
I generated the PW column like so:
UPDATE tablename SET PW = PASSWORD(CONCAT(Username,UPPER(Famille))) WHERE
Username ='1234567'
However, once I try to match the column PW with PASSWORD('1234567TESTÉ')
it doesn't work because the outputted values are different. Any help would
be greatly appreciated!
Thanks