|
|
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.