Writing Greek characters to a MySql database

svyates

• February 25, 2013 00:00

• Answered

Follow

I am unable to see Greek characters in a MySql database table after populating the table using the DBOutputTable writer. I'm reading in an Excel spreadsheet, using the Reformat transformer and then using the writer. When I enable debug, between Reformat and DBOutput and view the data, I see the Greek characters. However once written to the database, I just seen ???????s. I believe I have all the appropriate options set to UTF-8, but I can't seem to get it to work. If I populate the table field directly with Greek characters, it works fine. It's just in the DBOutput where there seems to be a problem. Perhaps I'm missing one little piece somewhere.
Any help would be appreciated.

Thanks!

• 

  imriskal

  • February 26, 2013 11:55

  0

  Comment actions Permalink

  Hello, svyates,
  
  Please, try DB connection with URL similar to this:
  
  jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=UTF-8
  
  With this URL, everything works fine on my side. So I hope it helps you also. But let me know, if this is not helpful in your case.
  
  Best regards,
• 

  svyates

  • March 01, 2013 12:11

  0

  Comment actions Permalink

  Thank you, Lubos!!! It's working fine now!
  
  Cheers,
  
  Steve

Please sign in to leave a comment.