How to write greek characters on MSsyl database?

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

peter.schwarz
Posts: 3
Joined: Thu Mar 14, 2019 3:45 pm

How to write greek characters on MSsyl database?

Postby peter.schwarz » Mon May 27, 2019 11:36 am

Hi,

I'm working with data which includes greek characters. I input it from a mssyl database and write it back on the same database using DBOutput writer. Using debug I can see that Clover detects the greek characters (Metadata charset is UTF-8), but after the data is written back to the database greek characters are like '???'. What do I need to change to also write using greek characters?

thanks in advance
Peter

cholastal
Posts: 134
Joined: Tue Sep 01, 2015 1:22 pm

Re: How to write greek characters on MSsyl database?

Postby cholastal » Mon Jun 03, 2019 3:12 pm

Hi Peter,

I'm actually not sure if you're using MySQL or MSSQL but that shouldn't really matter in this case. All sorts of components in CloverDX can use different charsets. So, please check if your DBOutputTable have UTF-8 set as well. Another option is that the database table is configured to use different encoding than UTF-8 and you will need to change it (if that's an option) or to create a new table with the correct encoding.

Let me know about the outcome.

Best regards.

---
Lukas Cholasta
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com