character encoding using insert


similar problems have been discussed here but unfortunately their solution didn’t help.

I’m trying to insert a value containing a special character (“März”) into one of my tables.

<span) - shouldn’t I be able to do this somewhere?

Thanks a lot.

Have you tried encoding your files in win1252 instead of UTF-8?

I manage to insert special characters (åäö) in our database but we use UTF-8 in the database as well.




I too have been having encoding issues - but with formatted sql files.  One thing that worked for me was to set the following environment variable:


Could you try it with the newest 3.1.1 version as well? There has been continued improvements to UTF-8 handling and it may be fixed.