I am having problem writing attributes with swedish characters (åäö) to a mssql table.
The characters get replaced by other strange characters instead. I am using FME Desktop 2022.0.0.2 build 22343.
The database is set up with collation Finnish_Swedish_CI_AS as it should be.
Other programs such as QGis is writing åäö to the table correctly.
Is there some kind of setting that I need to do in FME or is this a bug?
My first recommendation would be to install the SQL Server ODBC driver, which FME should use automatically, when present. I believe it's much more recent than the 2012 Native Client installed with FME (unless something's changed in 2022).
You'll need to restart FME after the installation.
That didn't help. But I tried the latest beta version and it works there so I guess it's a bug that is fixed in the latest beta.
Thanks anyway!
Hi @larsk ,
Thanks for letting us know! This behaviour is due to a bug that was fixed in FME 2022.0.1 build 22346. Installers can be found at https://www.safe.com/support/downloads/
If any users running into this issue are unable to upgrade to the build above or newer, please try one of the following workarounds:
Thanks! Upgrading to the new version solved the problem.