use Encode;
decode_utf8($db_data);

##</code><code>##

#1 - USE MySQL CHAR_LENGTH TO FIND ROWS WITH MULTI-BYTE CHARACTERS:
SELECT CLUB_NAME
FROM SUME_CLUB_TMP
WHERE LENGTH( CLUB_NAME ) != CHAR_LENGTH( CLUB_NAME ) 

Result
--------------
Törstar

#2 - USE MySQL HEX and Perl bin2hex
SELECT CLUB_NAME, HEX(CLUB_NAME) FROM SUME_CLUB_TMP

Database
--------- 
törstar
74C3B67273746172 

Perl bin2hex
--------- 
74f67273746172
törstar

#3 - SEE IT IN BOTH ENCODINGS
SET CLUB_NAME latin1;
SELECT CLUB_NAME, HEX(CLUB_NAME) FROM SUME_CLUB_TMP;

A databasecall in perl - utf8
--------- 
törstar
74C3B67273746172

A databasecall in perl - latin1
--------- 
törstar
74C3B67273746172