Insert from MS SQL to Lotus Notes using a NotesSQL disk

Question

I am trying to synchronize a SQL Server table with a Lotus Notes database. I installed the NotesSQL ODBC driver and was able to insert, update, and select notes from a database form using the ActiveX Script task in DTS. Everything works well until I try to insert Chinese characters into the text box in the notes database. After pasting, all I got is ??? characters.

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

Any help would be greatly appreciated, thanks.

Answer 1

Depending on the amount of data you are viewing, you might be better off with a web service. In Domino, it's pretty easy to create a CRUD service. Go to my blog to read Part1 and Part2 how to do it. Web services use UTF-8 and should not suffer from encoding problems.

Just to be sure: did you use the latest NotesSQL (8.0)?

Answer 2

I know little about your problem, but have you tried to import data through SSIS? I suppose there might be an option to complete your task.

, Notes. , .

Answer 3

Try putting some of the characters in Notes, then read them using the NotesSQL driver, and then try to figure out what kind of encoding you are really using.