Detecting strings containing characters with more than 2 bytes

Transact-SQL
1

So, I'm trying to convert a MS SQL Server database to a MySQL database. I run into some problems and I believe that is because some of the strings in the MS SQL Server database contains unicode characters that has more than 2 bytes, example :couch_and_lamp:
(which is F09F9B8B)
So, my quick question is: is there any function (or SQL statement) that I can use to detect if a string contains at least one character with more than 2 bytes?

2

hope this helps

3

Thank you for your effort, but no, that was not at all what I was looking for.