How can I read and display unicode Non Latin 1 characters in Lotus Notes from ISeries table using ODBC
Posted on 2012-03-21
I have an Iseries which has a unicode capable field. I have inserted Japanese (and other) non-Latin1 characters into this table.
Using the client access odbc driver I can read these characters successfully into MS Excel.
Using the ISeries access RunSQLstatements , I can see these characters when I change the font to unicode.
When I use my lotus notes SQL retreival tools the non-latin1 characters appear as a ? and will not display.
I have set the "Enable Unicode" in preferences to On.
Using ODBC traces it appears that the lotus notes is sending a message to the ODBC driver that it is narrow (??) which indicates non-unicode but this is not correct.
Is Anyone with experience of using lotus notes with ISeries Access ODBC or using Lotus Notes in an ISeries world with unicode able to offer any advice?