You may as well forget about using the console if you have any non-Latin scripts (Arabic, Cyrillic, Greek, Bengali, and on and on), because your system's default charset is likely to be different from the code page used by the console. Use a GUI to
test things.
But you said the data was "not rendered correctly" in your GUI. What does that mean? In general, if you see question marks then you have charset problems. That would probably mean that your database needs to be configured differently, but sometimes people do strange things in their code to try to work around those problems that just make them worse. But if you see rectangular boxes then you have a font that can't render the characters. You surely have the fonts available on your system, but you might have to call setFont() on your GUI components to use them.