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?
Question
SQL creator and encoding (accent problems)
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?
david_r wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.