score:-2
Accepted answer
Try to convert the column that contains emoji to utf8mb4 as answered in this post. https://stackoverflow.com/a/8109948/546954
score:0
you can encode the string with base64Encodeing ,then insert the result into database
More questions
- How to handle iOS emojis in sql server database?
- How to handle spaces in database name for Sql server CREATE TABLE?
- SQL Server database - How to handle a table which COULD be linked to any number of other tables?
- How does SQL Server handle large physical database file
- How to handle archiving for seasonal database values on SQL Server
- How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
- How to connect to SQL Server database from JavaScript in the browser?
- How to fetch the row count for all tables in a SQL SERVER database
- How to change column datatype in SQL Server database without losing data?
- How can I change my default database in SQL Server without using MS SQL Server Management Studio?
- How to connect an existing SQL Server login to an existing SQL Server database user of same name
- How do I search an SQL Server database for a string?
- How do you check what version of SQL Server for a database using TSQL?
- How to force a SQL Server 2008 database to go Offline
- How to export SQL Server database to MySQL?
- How can I generate an entity–relationship (ER) diagram of a database using Microsoft SQL Server Management Studio?
- How do I obtain a list of all schemas in a Sql Server database
- How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
- How to connect to a local database in SQL Server Management Studio?
- How to insert a data table into SQL Server database table?
- What are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
- How to view the roles and permissions granted to any database user in Azure SQL server instance?
- How do I connect to a SQL Server 2008 database using JDBC?
- How to retrieve data from a SQL Server database in C#?
- Wait on the Database Engine recovery handle failed. Check the SQL server error log for potential causes
- How to insert a blob into a database using sql server management studio
- How can I find out the location of my (localdb) SQL Server 2012 database and back it up?
- How to store image in SQL Server database tables column
- How do I create a local database inside of Microsoft SQL Server 2014?
- How to set the default schema of a database in SQL Server 2005?
More questions with similar tag
- Testing date values with HSQLDB
- Force SQL Server to respond slowly in order to test client application response to timeout
- T-SQL: stored procedure to increment products views count
- SQL LIKE operator not showing any result when it should
- Count Number of Repeat Callers in a rolling 7 day peroid
- Pass SQL Login as parameter
- Building auto-increment in SQL Server on legacy data using varchar
- How to select records that ordered by DESC?
- T-SQL Window Functions with CTE, use previously computed value
- Structuring a cube with paths from a fact table to a dimension via two alternative intermediate dimensions
- SQL Function Error
- How to find the nearest time in SQL Server query?
- The connection to the host server failed. Java
- Converting text to number
- How to Convert (null) values with 0 output in PIVOT SQL
- Perform second part of query only if first part returns nothing
- How to use multiple "like" and "and"
- PK Index fragmentation on IDENTITY columns with VARBINARY(MAX) column in table
- How to build all sequential of a table field value in SQL Server
- insert multiple values with one parameter with stored procedure
- Selecting Records From 1 Table That Don't Appear In Another Table
- SQL Batch Data, Hope to find running time for each Status (minutes) based on Last Update Timestamps?
- Load Testing a Database attached to a Network storage device
- How to use Joins in IIF() function and how to use select statement inside nested IIF () in MSAccess query?
- Language difference in full text search for numeric strings
- How do I change the format of my date in SQL Server
- How to use case instead of IsNull
- SQL Group rows for every ID using left outer join
- Optimize SQL Query
- Represent Is"Something" Data in SQL-Server
Source:
stackoverflow.com