character encoding using insert

Hello,


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.


Regards,

Christian

Hi,


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:

Gary

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.  


Nathan