Storing Emoji's

Graham White

Hi all,


We have written an app that retrieves SMS’s from our provider and stores them in the our database.  This works fine except when the SMS message contains an emoji or similar which comes through in the form of \uD83D\uDE03.  Is there any way to store the actual emoji within a pervasive field and display back it so that it looks exactly how it was sent?




Graham White
Software Developer
EC Credit Control |


IMPORTANT NOTICE: This e-mail message and any attachments are confidential to EC Credit Control and subject to legal privilege (which is not waived or 

lost by mistaken delivery). If you have received this e-mail in error, please advise the sender immediately and destroy the message and any attachments.  

If you are not the intended recipient you are notified that any use, distribution, amendment, copying or any action taken or omitted to be taken in reliance of 

this message or attachments is prohibited. EC Credit Control collects personal information to provide and market our services (see our privacy policy at: – - for more information about use, disclosure and access). 

EC Credit Control’s liability in connection with transmitting, unauthorised access to, or viruses in this message and its attachments is limited to resupply of 

any affected message or attachments.


It depends on the settings of Pervasive, if you store things as UTF-8, you should be able to store this things.
If your database is set to something like windows-1252, than you better store the 'u\....' stuff and convert it later from hex to Unicode?