• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Bear Bibeault
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh

Insert French in Domino through JDBC

 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dear all
I have no idea about how to insert French to Domino R5 through JDBC 1.0
I have tried to use the setUnicodeStream() method in the preparedStatement class.
However, the result is empty when I used Domino Client to open the record. I seems that I just insert an empty string into domino.

Any other suggestion about how to achieve this goal ?
Thanks and Regards

 
Ranch Hand
Posts: 106
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Edwin Wong:
Dear all
I have no idea about how to insert French to Domino R5 through JDBC 1.0
I have tried to use the setUnicodeStream() method in the preparedStatement class.
However, the result is empty when I used Domino Client to open the record. I seems that I just insert an empty string into domino.


* setUnicodeStream() is useless if you don't use the inputstream for preparedstatement
* java.lang.String supports standard encoding like ISO8859_1.
with a well encoded ISO 8859 (latin 1) string , you should be able to use it with the executeUpdate() method. The driver of the database should be able to convert Unicoded string into inhouse encoded field in the DB
You should construct a string with "\u00xx" and ensure that you can display it with System.out.println , after that, use executeUpdate() method to put the string into the DB via the JDBC driver. try to access the field with the DOmino client or a JDBC statement (executeQuery). if you don't have the result , verify your DB (Domino) supports ISO8859_1 (latin 1) encoding.
Guillaume
I can send U my AZERTY keyboard with the whole characters �����
 
Edwin Wong
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It's me again.
The problem still exist.
Using the Lotus JDBC-Driver, following problem occurs:
Special characters were represented as TWO Bytes. I think this could be
an problem with translation between ANSI an Unicode...
I can't use java.exe to inset a character such as �
However, I can insert this character normally by jview
As jview doesn't support java2, I can't use java2 method.
Therefore, I think I can't use jveiw for my project.
I just want to insert '�' to domino normally.
Does anyone know a solution or a workaround?
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic