Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
upload greek in mysql database
Best Answer
-
icsd11159 Member Posts: 16 Maven
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>
2
Answers
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.
Scott
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.
See here: https://stackoverflow.com/questions/5090303/how-do-i-get-greek-characters-in-my-database-using-jsp
oh nice catch, @JEdward.
Scott
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 :