[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Handle foreign character web input

On 6/28/2019 4:25 PM, Tobiah wrote:
> A guy comes in and enters his last name as R?nngren.
> So what did the browser really give me; is it encoded
> in some way, like latin-1?? Does it depend on whether
> the name was cut and pasted from a Word doc. etc?
> Should I handle these internally as unicode?? Right
> now my database tables are latin-1 and things seem
> to usually work, but not always.

Unless you want to restrict your app to people with or converible to 
latin-1 (western Europe) names, you should use utf-8 or let the database
encode for you.

> Also, what do people do when searching for a record.
> Is there some way to get 'Ronngren' to match the other
> possible foreign spellings?

I have seen a program that converts all latin-1 chars to ascii for matching.

Terry Jan Reedy