Assume I have a table named "PRODUCT_INFO" which has two fields product_id and product_name where product_id is the primary key.
On my JSP page, I am reading the values present in PRODUCT_INFO [table name] and listing it under a list box. Of that, 1 particular product(got from the table) has a unique name [DNA ”Kotimokkula”Option GlobeSurfer III]. When getting listed in that dropdown list box, it is appearing as it is.
Upon selecting this product and giving submit it goes to a servlet where when I read this vale thru request parameter it is giving [DNA ?Kotimokkula?Option GlobeSurfer III] instead of the original name present in the table PRODUCT_INFO which is [DNA ”Kotimokkula”Option GlobeSurfer III].
My next objective is to find the product_id corresponding to this product [DNA ”Kotimokkula”Option GlobeSurfer III]. Since I am getting the value as a different one from the original one present in the table I am unable to get the product id but instead getting null.
I am using the following character set in my jsp page
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
<%@ page contentType="text/html;charset=windows-1252"%>
Could any of you help me to find out the root cause and how to arrive at a solution without changing the product name present in the table?