Chinese Character Search

See more:

C#

ASP.NET

Oracle

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.