i need help to transfer data from BLOB (TEXT) into MS-SQL
the source will be table Customer1, Name(varchar), Code(varchar), Remarks(BLOB SUB_TYPE TEXT SEGMENT SIZE 80)
to
the destination table Customer2, Name(Varchar), code(varchar), remarks(varchar)
i try to use the code below
Dim cn As New ADODB.Connection
Dim cn2 As New ADODB.Connection
Dim rs As New ADODB.Recordset
rs.Open "Select CODE,NAME,REMARKS from Customer1", cn, adOpenForwardOnly, adLockReadOnly
cn2.Execute "Insert into Customer2 (Code,Name,Remarks) Values ('" & rs("Code") & "','" & Replace(rs("Name") & "", "'", "''") & "','" & rs("REMARKS") & "')"
transfering field Code and Name are successful, but Remarks is not succesful where i get the unrecognized character inside my destination field.
any suggestion? is it database limitation?
i am using InterBase 6 Open Edition, IBConsole Version 1 as source and Microsoft SQL Server 2005 as destination.
very urgent n thanks in advance