Skip to main content
Solved

Problem with SQL Server and special characters

L

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?

Best answer by debbiatsafe

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:

  1. Disabling Bulk Inserts on the SQL Server writer
  2. Updating Microsoft OLE DB Driver for SQL Server to at least version 18.4 and ensure Use Unicode UTF-8 for worldwide language support is enabled on the Windows System Locale setting
View original
1 Attachments
Did this help you find an answer to your question?

4 replies

david_r
Evangelist
  • david_rEvangelist
  • June 8, 2022

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).

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

You'll need to restart FME after the installation.

L
  • larsk
  • Author
  • June 8, 2022

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!

debbiatsafe
Safer
Forum|alt.badge.img+20
  • debbiatsafeSafer
  • Safer
  • Best Answer
  • June 8, 2022

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:

  1. Disabling Bulk Inserts on the SQL Server writer
  2. Updating Microsoft OLE DB Driver for SQL Server to at least version 18.4 and ensure Use Unicode UTF-8 for worldwide language support is enabled on the Windows System Locale setting
L
  • larsk
  • Author
  • June 9, 2022

Thanks! Upgrading to the new version solved the problem.

Reply


Most helpful members this week

Community Stats

30,846
Posts
116,937
Replies
38,670
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.