I have a problem while searching with chinese charcters
Below is the code
OracleConnection conn = new OracleConnection(cs);
string StrQuery;
conn.Open();
StrQuery = "";
try
{
System.Environment.SetEnvironmentVariable("ORA_NCHAR_LITERAL_REPLACE", "TRUE");
System.Environment.SetEnvironmentVariable("ORA_NVARCHAR_LITERAL_REPLACE", "TRUE");
StrQuery = "SELECT P.PRODUCT_ID, P.PRODUCT_CODE \"Product Code\", P.PRODUCT_NAME_ENG \"Product Name (Eng)\", " +
"P.PRODUCT_NAME_CHI AS \"Product Name (Chi)\", BR.BRAND_NAME \"Brand Name\", BR.BRAND_ID," +
"PC.PROD_CATEGORY_NAME \"Product Category Name\", PC.PROD_CATEGORY_ID, PA.PARA_DESC \"Unit Of Measure\"," +
"P.UNIT_MEASURES ,P.PACKAGE_QTY \"Packing Quantity\", P.PRODUCT_SPEC \"Specification\", P.IMAGE_NAME, " +
"P.IMAGE_EXT, P.IMAGE_PATH,P.PRODUCT_DESIGN FROM GM_PARAMETERS PA, MS_PRODUCT_DEFINITION P, MS_BRAND BR, " +
"MS_PRODUCT_CATEGORY PC WHERE P.BRAND_ID = BR.BRAND_ID AND P.PROD_CATEGORY_ID = PC.PROD_CATEGORY_ID " +
"AND P.UNIT_MEASURES = PA.PAR_AID AND UPPER(PRODUCT_NAME_CHI) LIKE UPPER(N'%" + txtSearchText.Text + "%') ORDER BY PRODUCT_NAME_ENG";
Oracle.DataAccess.Client.OracleCommand cmd = new OracleCommand(StrQuery, conn);
cmd.CommandType = CommandType.Text;
OracleDataAdapter da = new OracleDataAdapter();
da.SelectCommand = cmd;
da.Fill(dsGrid);
conn.Close();
}
catch (Exception ex)
{
throw ex;
}
From above code I am retriving null dataset or sometimes I have data with ????? but when I build website data is retrived properly. It will work for entire day. Next day it won't work until I rebuild entire project.
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
used in master page
In web.config, I used
<globalization requestencoding="utf-8" responseencoding="utf-8">
fileEncoding="utf-8"/>
Any help will be appreciated.