Ask the Expert

Export rich text field data from Notes to Informix

I need to export data from a Notes database to an Informix database. I can successfully export text, date or number data to the Informix tables. But when I try to export rich text field data (retrieved in LotusScript with the GetFormattedText method) from the Notes database to the Informix table's column, which is a CLOB data type, it fails.

This is the first time I've worked with Informix. I'm doing this export with LotusScript and an ODBC connection on my desktop. What should I do?

Also, I have a SQL Server database running on my local Notes server, where this application resides. I created a test table to which I can write this data, and when I try to write the rich text field data to a "text" data type in the SQL server table of my test database, it only writes some of the data, and only on some of the rich text field data. I'm using a string var to do this. Does this suggest a memory limitation for the string var I'm using in LotusScript?

Getting rich text data from Notes to another database system is a challenge, since Lotus uses its own proprietary format for rich rext fields. Try using LEI, which "understands" rich text fields. However, even with this method, your front-end Informix application still may not present the RT data properly.

Do you have comments on this Ask the Expert question and response? Let us know.

This was first published in June 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: