Skip to main content
Question

Does MYSQL_DB Writer support UTF-16 strings?

  • July 11, 2017
  • 1 reply
  • 16 views

arekpierchala
Contributor
Forum|alt.badge.img+1

Hi,

when I try to send sting attibute with UTF-16 encoded string, MYSQL_DB writer shows the warning:

"Skipped writing of 1 features due to unmatched non-insert writer type mode when the writer was in insert (only) mode"

Is it possible that MYSQL_DB does not convert UTF-18 string into own types?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

LizAtSafe
Safer
Forum|alt.badge.img+18
  • Safer
  • July 17, 2017

Hi @arekpierchala, It appears that MYSQL_DB does support UTF-16. It looks like your issue might be because your "Writer Mode" is set to INSERT. Have you tried changing the writer mode? Here is the documentation on what each mode does: http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_ReadersWriters/mysql_db/format_parameters_w.htm

A bit more information would help the community pinpoint the specific issue if the "Writer Mode" doesn't work for you:

1) Would you be able to share a sample of your data and a copy of your workspace?

2) Are there any special characters or non-English characters in the data?

3) What version of FME are you using?