We have an php (codeigniter) web app that sending sms's. the db we connected to is oracle. when some customer trying to send emoji throgh our webapp the emoji is not displayed well on the mobile phone. we can see the emoji in sql plus but it not displeyed well on pl sql. we assuming it related to some encoding issue but can't point to the exact problem.
in addition when we receiving incoming messages from mobile phones and the message are not passted throght php the emojis displayed perfectly
this is how it looks when the message is incoming message
