Forum Discussion

Jake_pm's avatar
Jake_pm
New Contributor II
3 years ago
Solved

Mongo DB Update Snap - Expression for Query

The following query works in MongoDB Atlas to update a record:
db.mytable.update
(
{
_id : ObjectId(‘1234’)
},
{
$set :
{
“org_name” : “new org name”
}
}
)

How do we configure this for use with the Mongo DB -Update snap?
any one have an example?

1 Reply

  • jaybodra's avatar
    jaybodra
    New Contributor III
    8 years ago

    Did you try to set properties for the mysql account with
    useUnicode=yes
    characterEncoding=utf8
    It works for our Aurora instance.

    • nsmith's avatar
      nsmith
      New Contributor III
      7 years ago

      THANK YOU jaybodra!!! Turns out our workaround broke in MySQL 5.7, and we stumbled upon our own question which now has your solution that worked. A bunch of employees with special characters in their names will be very grateful!