Skip to main content
Solved

Problem with swedish characters when writing to ESRI geodatabase

K
Forum|alt.badge.img

I have a workspace where I read a shape file, clip the data and write it to a ESRI geodatabase with the

 

Esri Geodatabase (ArcSDE Geodb) reader. The attributes in the shape file contains swedish caracters. The characters is right when I read the shape file in ArcGIS but when I write the data to the geodatabase the swedish characters is replaced. How can I handle that? I have try to change character encoding on the shape file writer to iso-8859-1 (which contain swedish characters).

I'm attach print screens from ArcGIS when reading the shape file (as it should look like) and from ArcGIS when reading the geodatabase.

Best answer by david_r

It's always difficult to debug these issues remotely, but I agree it is probably an encoding issue.

Two things to try:

  • On the shape file reader, try also using the "Windows Latin1 ANSI (1252)" encoding
  • Just before the writer, insert a Logger or an Inspector and look at the characters and the encoding that is reported by FME. Example:

David

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

4 replies

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • January 12, 2016

It's always difficult to debug these issues remotely, but I agree it is probably an encoding issue.

Two things to try:

  • On the shape file reader, try also using the "Windows Latin1 ANSI (1252)" encoding
  • Just before the writer, insert a Logger or an Inspector and look at the characters and the encoding that is reported by FME. Example:

David

K
Forum|alt.badge.img
  • keoe
  • Author
  • January 12, 2016

I try to use Windows Latin1 ANSI (1252) encoding. The logger I insert before the writer gives me

Attribute(encoded: windows-1252): `Lan' has value `™sterg”tlands l„n'

FME report the same encoding but i get the same attribute value as before.

david_r
Celebrity
  • david_rCelebrity
  • January 12, 2016
keoe wrote:

I try to use Windows Latin1 ANSI (1252) encoding. The logger I insert before the writer gives me

Attribute(encoded: windows-1252): `Lan' has value `™sterg”tlands l„n'

FME report the same encoding but i get the same attribute value as before.

What happens if you set the Shape file reader encoding to Unicode UTF-8?

Basically, you need to experiment with the reader encodings until it looks right in the Logger.

In most cases, it is either Latin1 or Unicode. If your dataset is really old it might be worth trying "DOS Nordic (ibm865)" as well.

K
Forum|alt.badge.img
  • keoe
  • Author
  • January 12, 2016
david_r wrote:

What happens if you set the Shape file reader encoding to Unicode UTF-8?

Basically, you need to experiment with the reader encodings until it looks right in the Logger.

In most cases, it is either Latin1 or Unicode. If your dataset is really old it might be worth trying "DOS Nordic (ibm865)" as well.

Thank you for your help! It work's fine with DOS Nordic.

Helpful Members This Week

Community Stats

31,290
Posts
118,678
Replies
38,878
Members

Latest FME

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.