Hello everybody,
First I'm sorry for my terrible English. I'm coding a project with firebird 2.5 databse. When I inserted a Unicode string, with following code:
Code:
 
Private Sub cmdXacNhan_Click(sender As Object, e As EventArgs) Handles cmdXacNhan.Click
        Dim ChuoiKetNoi As String = "User=SYSDBA;Password=masterkey;Database=C:\InfoStudent.fdb;DataSource=localhost;ServerType=0;"
        Dim KetNoi As New FbConnection(ChuoiKetNoi)
        Dim CauLenhSQL As String = "INSERT INTO DMSV VALUES ('15031071','Phạm Trường Quân','DHKT1B','0985844272','Quan@pham.com','Non')"
        KetNoi.Open()
        Dim CauLenh As New FbCommand(CauLenhSQL, KetNoi)
        CauLenh.ExecuteNonQuery()
 End Sub
VB.net show message: FbException was unhandled: Malformed string.
I set the field in table "DMSV" with charset UTF-8. If i directly input to database, it can display the unicode string.
how can i fix this?
Thank so much for any help.