Newsletter sign-up
View all newsletters

Enterprise Java Newsletter
Stay up to date on the latest tutorials and Java community news posted on JavaWorld

JavaWorld Daily Brew

JAVA insert chinese character



When I use below statement to insert chinese character. It is store '????' into database.

try{
ps=conn.prepareStatement("insert into Arn_Web_LabourRpt_Details " +
" (RequestId, InsLineNo, Description, Location, OrderNo, LabourNo, JobDate," +
" Leader, ReportNo, Product, OK, Rejected, MDNo, Address, PerferenceLabour, ActualLabour, ConfirmationStatus," +
" LastUpdateDate,LastModify,ProjectName) " +
" values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,getdate(),?,?)");
ps.setInt(1,RequestId);
ps.setInt(2, this.getInsLineNo());
ps.setString(3, this.getDescription());
.
.
.
ps.executeUpdate();
}

When I use JSP include this statement

It is fine to display the chinese character.

But I want to use another media (such as: MSSQL report Server,crystal report) to show database data. It show '????'

How can solve this problem? I want to store the normal chinese character into database, then it can retreive the data directly without encode.