wood burning stoves 2.0*
The moose likes JDBC and the fly likes Does varchar allow non-printable characters 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 "Does varchar allow non-printable characters" Watch "Does varchar allow non-printable characters" New topic
Author

Does varchar allow non-printable characters

Chandru Ganesan
Ranch Hand

Joined: Feb 08, 2003
Posts: 37
I would like to pack a max of 25 characters (containing numeric values '0' - '9'] into a database varchar(25) field. In order to do this, I use BCD encoding. However, when I print the BCD encoded string, it results in some non-printable character. I have following questions?
1. Can I use, a varchar datatype in the database, to store non-printable characters
2. Is there anyway, I could represent characters ['0' - '9'] in BCD format without using non-printable characters?
The packed decimal value will be converted to a string and subsequently sent over SOAP/XML to the SOAP server.
Appreciate your help
thanks
Chandru Ganesan
The underlying database is DB2
Thanks for your help.
Chandru Ganesan
Ranch Hand

Joined: Feb 08, 2003
Posts: 37
Is there anybody who could answer this question?
 
wood burning stoves
 
subject: Does varchar allow non-printable characters
 
Similar Threads
why we should use CHAR type when we have VARCHAR?
regular pattern
Using Excel to generate test data for Sql tables
executeUpdate() ?
simple question - varchar(100) does it matter in terms of space?