Add emoji to SQL Server 2017

Asked Jul 16 '20 at 05:49

Active Jul 16 '20 at 05:50

Viewed 42 times

How is the coding to insert the emoji into the SQL Server database so it doesn't become a sign ????

I have changed the chart type to NVARCHAR. The following coding that I have used in VB.Net

Private Sub btbInput_Click(sender As Object, e As EventArgs) Handles btbInput.Click
    Call Koneksi()
    Dim InputData As String = "insert into Perintah values ('" & txtPerintah.Text & "','" & txtRespon.Text & "')"
    Cmd = New SqlCommand(InputData, Conn)
    Cmd.ExecuteNonQuery()
    MsgBox("Perintah berhasil di input")
    Call KondisiAwal()
End Sub

edited Jul 16 '20 at 05:50

Dale K

25,246
15
42
71

asked Jul 16 '20 at 05:49

Sumbupulsa

4

Use a parameter, instead of concatenating a string for your insert - that will solve your problem. Also you should specify the columns you are inserting into. – Dale K Jul 16 '20 at 05:52
can you give an example? – Sumbupulsa Jul 16 '20 at 06:10
1

@Sumbupulsa, what don't you understand about the examples you found when you looked for yourself? – jmcilhinney Jul 16 '20 at 06:26

Add emoji to SQL Server 2017

0 Answers0