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
503 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus notes - Follow up notes mail missing 15 73
Check for files on IFS. if found, copy to one folder, move to another 1 165
@Mailsend 3 59
iSeries Backup 3 23
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…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

777 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