Insert from MS SQL to Lotus Notes using NotesSQL drive

Question

I am trying to sync up a SQL Server table with a Lotus Notes database. I have set up the NotesSQL ODBC driver and have been able to insert, update and select from the notes database form using the ActiveX Script Task in DTS. Everything works well until I try to insert Chinese characters into Text field in the notes database. After insertion, all I got are ??? characters.

So my question is how do you insert unicode into notes database using the ODBC driver? i have tried something like this (where NotesForm is a form from notes): Insert NotesForm (UnicodeField, Field2) VALUES (N'some unicode', 'normal field')

Any assistance would be greatly appreciated, thanks.

Answer 1

I don't know much about your issue, but have you tried to import data through SSIS? I guess there might be an option or so to perform your task.

Perhaps could simply change the encoding of your Notes field. I can't tell you more, sorry.

Answer 2

Try to put some Chinese characters into Notes, then read them using NotesSQL driver and then try to figure out what encoding You are really using.

Answer 3

Depending on the volume of data you are looking at you might be better of with a web service. It is fairly easy to create a CRUD service in Domino. Head over to my blog to read Part1 and Part2 how to do that. Webservices use UTF-8 and shouldn't be plagued by charset troubles.

Just to be sure: You used the latest NotesSQL (8.0)?