How does SQL handle letters like ä,ö,ü


I tried to add some letters like ä,ö,ü Into the table but the program ignores the letter.

What happens for example if a customer ist called “Max München”?
Logically, if the database stores the customer data as “Max Mnchen” you couldn’t find the data ever again, so how do SQL and databases handle these kind of letters?