This week's book giveaway is in the OCAJP forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
Hey guys, Here is my dillema, I am making a JDBC connection to an oracle database and taking my result set and building an XML file using a PrintWriter. Everything works very well, except for one issue. The oracle database stores bullet characters inside some of the fields, and when the PrintWriter class attempts to write them I get ? marks, because the PrintWriter, does not know how to represent to bullets in a character form as they are not normal character values that can be represented on the native file system. I think if I change it to a Printstream I can fix the issue by just writting out native bytes, the problem with this solution is it involves a major rewrite. Does anyone out there have another idea to make this work with and be able to get back the bullet characters as bullets that can be displayed in html? I have also considerered using perl.ora tools, but unfortunaly you can not to a search and replace on a ? mark, because it may be a valid ? mark, and not supposed to be a bullet. Thoughts ideas would be very welcome. Thanks, Matt [ March 13, 2002: Message edited by: Matt Ghiold ]
Is the porblem still there with blobs / clobs ? Have you setup you Oracle to support Unicodes ? The way you express teh proble it's not solvable - as such - on the java side alone ! May be could you try to give abroader idea of the parameter we could influence ? Like wrtting the element sin the file in ASCII replacing the bullet by a String like [bullet] of some sort ... There is dozen of io classes that could be helpfull in atomating that,you know ! Thomas,