The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Hello,
I have a connection with MySQL database and i pass values in a table but i have greek words and in database tha results are like: ??????
Thank you all for your help , i just solve my problem by setting the appropriate connection properties in RapidMiner Studio : via Connections > Manage Database Connections > Advanced and check the
<SPAN class="str">characterEncoding</SPAN>
and write utf8 in the blank next to it .
Also must check and
<SPAN class="str">useEncoding</SPAN>
hello @icsd11159 - is that a RapidMiner screenshot? I do not recognize those icons.
Scott
This is a screenshot from my database , that writes greek perfect from hltm/php but when i use 'write database' operation they turn into ?????.I use 'execute SQL' with 'SET CHARACTER SET UTF8' but nothing is change .Do you have any idea to fix this ?
Is your RapidMiner display set to Unicode?
My results are in greek , if that's what you asking
ah ok that makes more sense. Most likely that's an encoding issue. Can you check and see if your system RapidMiner encoding is the same as your database? I can see if your system is ISO-8859-1 and your database is UTF-8, you would have a problem.
Thanks, was just checking by eliminating the first possibility.
The issue might actually the first one I suspected, the JDBC driver could need an additional connection parameter set as advanced parameters.
Set useUnicode to yes & characterEncoding to UTF-8
This should resolve it.
<SPAN class="pln">jdbc</SPAN><SPAN class="pun">:</SPAN><SPAN class="pln">mysql</SPAN><SPAN class="pun">://</SPAN><SPAN class="pln">localhost</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">3306</SPAN><SPAN class="pun">/</SPAN><SPAN class="pln">db_name</SPAN><SPAN class="pun">?</SPAN><SPAN class="pln">useUnicode</SPAN><SPAN class="pun">=</SPAN><SPAN class="pln">yes</SPAN><SPAN class="pun">&</SPAN><SPAN class="pln">characterEncoding</SPAN><SPAN class="pun">=</SPAN><SPAN class="pln">UTF-8</SPAN>
See here: https://stackoverflow.com/questions/5090303/how-do-i-get-greek-characters-in-my-database-using-jsp
oh nice catch, @JEdward.
Thank you for your reply!
I agree with you and i think that this must be the solution . But when i change the url path it gives me error
My ManageDatabaseDrivers is like :
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
