import pymysql

conn = pymysql.connect(host='85.215.144.168', user='asesoft', password='Pantera1', database='pastelerias', charset='utf8mb4')
with conn.cursor() as cur:
    for coll in ['utf8mb4_spanish_ci', 'utf8mb4_unicode_ci', 'utf8mb4_general_ci', 'utf8mb4_unicode_520_ci']:
        try:
            cur.execute(f"SET NAMES utf8mb4 COLLATE {coll};")
            cur.execute("SELECT 'TURRÓN' LIKE '%TURRON%', 'TURRON' LIKE '%TURRÓN%', 'PEÑA' LIKE '%PENA%', 'PENA' LIKE '%PEÑA%';")
            r = cur.fetchone()
            print(f'{coll:25}: TURRÓN/TURRON={r[0]}/{r[1]}, PEÑA/PENA={r[2]}/{r[3]}')
        except Exception as e:
            print(f'{coll:25}: ERROR {e}')
conn.close()