Hi,
I have data stored in dbf as DBCS. I want to migrate them to SQL Server NVARCHAR field. I tried code below but seem doesn't work.
lcmyfield = CREATEBINARY(STRCONV(myfield, 12))
SQLEXEC(1, "INSERT INTO myTable VALUES (CAST(?lcmyfield AS NVARCGAR(50)))")
Any ideas?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...