File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Insert French in Domino through JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Insert French in Domino through JDBC " Watch "Insert French in Domino through JDBC " New topic
Author

Insert French in Domino through JDBC

Edwin Wong
Greenhorn

Joined: Apr 15, 2001
Posts: 10
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

Joined: Aug 09, 2001
Posts: 106
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 �����


---------<BR>Guillaume
Edwin Wong
Greenhorn

Joined: Apr 15, 2001
Posts: 10
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?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Insert French in Domino through JDBC
 
Similar Threads
JDBC Applets
Can a servlet perform an action at intervals
Using Domino SDO with JSF
Insert French in Domino through JDBC
Connection to Domino through LTPA