Convert text from UTF8 to ASCII

Hoi,

I store content of an .txt file in a text column in the database.

server_encoding is UTF8.

If the .txt file is in ASCII this is correctly stored in the database.

If the .txt file is in UTF8 this is NOT correctly stored in the database.

Examples:

In Dutch the term for patient is 'patiënt'.

It is stored as 'patiënt'.

The first line of the .txt file is 'AAAAAAAAAAAA'.

It is stored as 'AAAAAAAAAAAA'.

How can I convert patiënt into patiënt?

Or more precise: How can I convert the text column to the correct format, before insert or when selecting?

Met vriendelijke groet,

Paul Dam

Informatieanalist

Amyyon
Bijsterhuizen 11.58

6546 AS Nijmegen

050 - 311 5686

www.amyyon.nl <http://www.amyyon.nl/>