🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How To Write Not Read Character Into Database (square character)

User: "grayhyuk"
New Altair Community Member
Updated by Jocelyn
Hello im literally new using Rapidminer
i dont know how to write square character like above to my mysql database
it always says database error occured incorrection string value
Im attach dataset and rmp process
Please your kindness
Thx for your help
Below example set when i just show in rapidminer


Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "BalazsBaranyRM"
    New Altair Community Member
    Accepted Answer
    Hi,

    your input seems to have an invalid encoding, with unreadable characters. Databases are usually quite strict on only accepting correctly encoded input.
    Look again at your import process. Where are the data coming from? Is it possible that you're importing them with a wrong encoding setting? Are you using Unicode, UTF-8, or a locale-specific encoding?

    If you can't fix the input and need the characters as they are, you could use "Encode URL" (when writing) and "Decode URL" (when reading from the database) to create a representation of your text that the database accepts. This is how it would look like inside the database:

    NEW+YEAR+SALE+%EF%BF%BD%EF%BF%BD%EF%BF%BD+TAKE+OVER

    Best regards,
    Balázs