dkubb changed the topic of #datamapper to: Datamapper v1.2.0 | Mailing List: http://is.gd/aa9D | Logs: http://is.gd/qWAL7V | DataMapper 2 Renamed to ROM, see #rom-rb for development
siel_ has joined #datamapper
siel has quit [Ping timeout: 240 seconds]
siel_ is now known as siel
rsim has joined #datamapper
aaronpk has joined #datamapper
<aaronpk>
kapowaz: small world!
<kapowaz>
aaronpk: :D
<aaronpk>
so i'm having a bizarre issue. I'm trying to store emoji in a database. When the app first launches, the first time it tries to store emoji it works fine. But the *second* time, it fails with the "Incorrect string value: '\xF0\x9F\x91\x8D' for column" error
<tpitale>
Weird …
<tpitale>
If you restart the app, does an update work again?
<aaronpk>
yeah
<aaronpk>
I thiiink I figured it out but i'm not convinced yet
<tpitale>
VERY weird
<aaronpk>
it seems like passenger was keeping a copy of the old version of the app around, so sometimes it would launch the old version
<tpitale>
Ah
<aaronpk>
(the change I just made was to make the DB connection use utf8mb4)
<aaronpk>
force killing the passenger process that launches the other processes seems to have fixed it
<aaronpk>
course now i'm having trouble getting the emoji back OUT of the database but that is probably a different story
<aaronpk>
nevermind. getting the string value error again
<aaronpk>
is it a bad idea to change my column type to BLOB to avoid this completely?
rsim has quit [Quit: Leaving.]
<tpitale>
Encoding is always tricky, so I hesitate to comment one way or another.