[Updated] Emojies not storing in Mysql database error

Discuss
, ,
#1

Hi gys i m working on mysql database using the concept of @Taifun but there is a problem relating the emojies
Whenever i tried to save emojies it shows an errror 400 (screenshot is added) I searched the google and found some ways like using a command to set characters to “utf8mb4 collate utfmb4_bin” (its not full query just hint to that query )
Even after using this queries i m unable to store emojies along with text.
My data type is text where i want to store emojies along with text
If anyone knows then share your idea

Personal suggestion:
@Taifun
I think it can be made easy by changing in PHP script., Last night I found a PHP code on stackoverflow that can be used to store emojies in mysql database but unfortunately lost it after that
I’ll try my best to mention that here.

Topic Update:
I find another solution but not able to impliment it please check out this link and try to develop a way to impliment it
Link : How to store Emoji Character in MySQL Database - Stack Overflow

The screenshot of error is here

Screenshot_20200410-083055
Screenshot_20200410-083055720×1440 179 KB

#2

When you upload/store text use web>encod text block and when text got and set label use decode text to solve your issue. See block in below screenshot.

IMG_20200410_102859
IMG_20200410_102859726×394 59.2 KB

#3

It’s good idea but i want to save data as such
So that i can monitor it in everyway like from my phpMyAdmin and from app too
There are otherways to do like using charset collations i tried but failed to achieve.

#4

I think no extra data require its very small size data for text need .

#5

No no i think u didn’t got my point
I m saying that i dont want to save data in encoded form i want to save it in its actual form

#6

Where do you want to save data ?

#7

just change CHARACTER SET of column

ALTER TABLE Tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin

#8

Yes i tried it this query executed successfully but when i tried to save emoji it fails again showing error 400
Even after altering the tables with your mentioned query

#9

In mysql database

#10

Create 1 admin app to get all data on app whose you want and there use decode text to you able to see all data in normal text

1 Like
#11

Thanku for your suggestions these are my secondary choices because emoji data is possible in mysql therefore i want to get the original way of doing this

#12

Where and how did you do the Alter table command? Did you do the set_charset conando that is in item 4 of the solution in Stack Overflow?

1 Like
#13

Yeah i tried that one too
But not working for me
If u dont mind i wll send you the aia in pm so that u can create a new table and try by yourself. May be there was a mistake in my methodology.
In my case query execueted successfully through my app but charracters are not being get add yet.

#14

in data type choose BLOB

#15

Its a binary data type can u explain the difference between these data types text and blob?

#16

what about doing a search?
Taifun

1 Like
#17

@Taifun I am already searching on this topic and now got his point​:blush:
And waiting for your reply please help me if i can solve this problem with some other way like altering the tables becz there are ways to alter tables to made text cloumns to save emojies too
But so far i failed in achieving this goal. And i think u r the only one here who can
I’ll provide my aia if u need, to fix.

#18

I never tried to store emojis in a MySQL table, so I’m unfortunately not the one…
you got some good suggestions… let me suggest you to try these…
Taifun

1 Like
#19

@Taifun ok m waiting for your suggestions
And why not try this time if u not have tried previously :roll_eyes::blush:

#20

Try :
https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4