Solved

How can I read and display unicode Non Latin 1 characters in Lotus Notes from ISeries table using ODBC

Posted on 2012-03-21
6
534 Views
Last Modified: 2014-12-23
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?
0
Comment
Question by:Cedarsrus
6 Comments
 
LVL 16

Accepted Solution

by:
theo kouwenhoven earned 250 total points
ID: 37751318
Hi  Cedarsrus,

As far as I know is Japanees a DBCS type character, so you have to use a DBCS at the iSeries side.
See for more in formation the IBM page about "Working with DBCS data"

Regards,
Murph
0
 

Author Comment

by:Cedarsrus
ID: 37751375
Hi Murph ,
The current version of our database is double byte. The newer version that we are having difficulty with moves a number of the key tables to Unicode.
We want to store Japanese, Russian, etc. in these unicode fields.

We've done some more testing and we think it's to do with the Lotus Notes client. The Japanese client can read the unicode data , but the UK Notes client can't.


Andrew
0
 
LVL 46

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 250 total points
ID: 37752210
0
 

Author Comment

by:Cedarsrus
ID: 37815404
OK - Now we know what the real problem is - Lotus Notes LSX ODBC connector was written for ODBC 2.x and tells the odbc driver what the active code page is to determine whether to use Narrow or wide in its interpretation of the commands and results.

So a Japanese based client sends and receives "wide" but a UK based PC sends a "narrow" and expects "narrow" but can't cope when the returned results are in unicode.

Any suggestions as to how we can work around this ?
0
 
LVL 14

Expert Comment

by:daveslater
ID: 40514595
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question