• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Insert French in Domino through JDBC

 
Edwin Wong
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • 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

 
Guillaume Compagnon
Ranch Hand
Posts: 106
  • Mark post as helpful
  • send pies
  • 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
  • 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic