[Updated] Emojies not storing in Mysql database error

not working if you dont mind do i provide you aia? so that u can also try by yourself may be i m making a mistake somewhere.

I am currently busy with this project.

hopelesssss :face_with_head_bandage: nothing is working for me

btw your project is looking owsm

I think @Kodular also uses Mysql (just personal idea) if yes then we can send emojies to its database during our post creations in community
Mean somehow they made it possible. Then please share the concept how it is working.

i don’t know much about data types but in my database i am using BLOB and is working fine for me


just see my database

Ok tell me one thing
It is storing data in blob form which is not readable but in your screenshot at the bottom one of your text is readable how u made it to be readable by just clicking on the bloob data or something other

Updated:
Oooh its notepad
Then what about reading original data on phpMyAdmin???

just import your data

or clicking the particular cell data will get downloaded


working in my database.
Show error screenshot

1 Like

ok i’ll send you aia in pm so please try by yourself and crack the way

Why don’t replace the emojis with a code, like <GRIN> for “:grin:” and save it like that.
Then when retrieving the info from the database, replace all those codes with the corresponding emoji.
Similar to what Discourse does when we are posting here.

2 Likes

it sounds owsm please can u elaborate it a bit more

(I don’t know if this works, you have to try it).

1 Like

I haven’t used MySQL on Kodular but I hope this helps: How to store Emoji Character in MySQL Database - Stack Overflow

Ok thanku m gonna try it and then let u know

Thanks I have tried these queries but these not worked for me