Hi Experts,
I want to insert Emojis and special characters with text . Is there any way to insert in Database?
Thanks
Discussion posts and replies are publicly visible
nvarchar should get you covered.
The collation of the field needs to be "utf8mb4_general_ci". This can also be set for the whole table in table options.
Hi Stefan ,
I tried this but it is not working . I want to save in DB like:example: ertyuiopasdfghjklvbnm
Hello. You could try this string as in your example:
ertyuiopasdfghjklvbnm\uD83D\uDE09\uD83D\uDE09\uD83D\uDE17\uD83D\uDE03\uD83D\uDE03It will store the encoded values of emojis and after retrieval from database and rendering on the web page it will be displayed as typical icon
ertyuiopasdfghjklvbnm\uD83D\uDE09\uD83D\uDE09\uD83D\uDE17\uD83D\uDE03\uD83D\uDE03
Best, Anton.
Please explain what you mean with "it is not working".
I can copy the string you posted and store it in my database.