0

In Python & Pandas there is an easy way to convert special characters to plain latin characters like below.

import pandas as pd
from unidecode import unidecode

df = pd.Series(['Ässät', 'Kärpät', 'Łódź'])
df.apply(unidecode)

This gives me

Out[7]: 
0     Assat
1    Karpat
2      Lodz

Is there any easy way to do the same in MySQL? I have only seen fairly complicated ways so far.

Shadow
  • 33,525
  • 10
  • 51
  • 64
MattiH
  • 554
  • 5
  • 9
  • Can you include some sample use cases for MySQL that you are trying to achieve? – arshovon Jan 09 '22 at 12:27
  • 1
    Mysql's text manipulation functions are rather limited, you have to specify what characters to replace with what other characters. – Shadow Jan 09 '22 at 12:58
  • 1
    [Thist topic](https://stackoverflow.com/questions/9304485/how-to-detect-utf-8-characters-in-a-latin1-encoded-column-mysql) may provide you with some guidance. – Martin Jan 09 '22 at 13:05

0 Answers0