I am using SQL creator to initially query a Oracle dB.
I am using a few transformers and writing my results in a PostGIS db.
I however notice that the accents (french) don't survive this transformation.
Is there a way I can pass the encoding along?
I am using SQL creator to initially query a Oracle dB.
I am using a few transformers and writing my results in a PostGIS db.
I however notice that the accents (french) don't survive this transformation.
Is there a way I can pass the encoding along?
The encoding is already passed along in FME, but how it's honored can depend on several factors, including which transformers you're using and how the writer, including Postgresql client, has been configured.
I think we need some more information, in particular where in the process the extended characters (accents) gets mangled.
Have you tried setting breakpoints in your workspace to isolate the problem further?
The encoding is already passed along in FME, but how it's honored can depend on several factors, including which transformers you're using and how the writer, including Postgresql client, has been configured.
I think we need some more information, in particular where in the process the extended characters (accents) gets mangled.
Have you tried setting breakpoints in your workspace to isolate the problem further?
Thank you. I looked in further and the problem seems to happen only when writing in the postGIS dB.