title: .Net core api 2.2 request to Coldfusion Api character issue inserting to MSSQL db
body: <p>I make the request to coldfusion api from .net core api as shown below</p>
  <pre><code>Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
  
  var httpWebRequest = (HttpWebRequest)WebRequest.Create(&quot;http://url&quot;);
  httpWebRequest.ContentType = &quot;application/json&quot;;
  httpWebRequest.Method = &quot;POST&quot;;
  
  var jsonSeri_ = Newtonsoft.Json.JsonConvert.SerializeObject(_frmCustomerTicket);
  
  Encoding iso = Encoding.GetEncoding(&quot;iso-8859-9&quot;);
  Encoding utf8 = Encoding.UTF8;
  byte[] utfBytes = utf8.GetBytes(jsonSeri_);
  byte[] isoBytes = Encoding.Convert(utf8, iso, utfBytes);
  string msg = iso.GetString(isoBytes);
  
  using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
  {
  
      streamWriter.Write(msg);
  
  }
  </code></pre>
  <p>in coldfusion api I get the request json as below</p>
  <pre><code>&lt;cfif cgi.content_type EQ &quot;application/json&quot;&gt;
        &lt;cfset _deserializeJSON = deserializeJSON(ToString(getHTTPRequestData().content))&gt;
      &lt;cfelse&gt;
  {&quot;userFname&quot;:&quot;&quot;,&quot;userEmail&quot;:&quot;&quot;,&quot;companyId&quot;:1,&quot;priority_id&quot;:3,&quot;userLTopic&quot;:&quot;donanım arızası&quot;,&quot;pdesc&quot;:&quot;cookie güzel bir şekilde çalışıyorrrrr&quot;}
  </code></pre>
  <p>then, I send the json data to another page to insert the data to MSSQL database.</p>
  <p>this is how I pass the data:</p>
  <pre><code> &lt;cfset var formStruct = _deserializeJSON /&gt;
   &lt;cfinclude template=&quot;queryexecute.cfm&quot;&gt;
  </code></pre>
  <p>In another page, I use the code as below.</p>
  <pre><code>&lt;cfprocessingdirective pageEncoding=&quot;utf-8&quot;&gt;
  
  &lt;cfparam name=&quot;formStruct&quot; default=&quot;&quot;&gt;
  
  INSERT INTO
    G_SERVICE
     (
                              
       SERVICE_ACTIVE,
       ISREAD,
       SERVICECAT_ID,
       SERVICE_STATUS_ID,
       PRIORITY_ID,
       COMMETHOD_ID,
       SERVICE_HEAD,
       SERVICE_DETAI
   )
   VALUES
    ( 
      1
      , 0
      , 1
      , 92
      , #formStruct.priority_id#
      , 0
      , &lt;cfqueryparam cfsqltype=&quot;CF_SQL_NVARCHAR&quot; value=&quot;#(formStruct.userLTopic)#&quot;&gt;
      , &lt;cfqueryparam cfsqltype=&quot;CF_SQL_NVARCHAR&quot; value=&quot;&lt;p&gt;  #(formStruct.pdesc)#  &lt;/p&gt;&quot;&gt;
      , &lt;cfqueryparam cfsqltype=&quot;CF_SQL_TIMESTAMP&quot; value=&quot;#now()#&quot;&gt;
      , &lt;cfqueryparam cfsqltype=&quot;CF_SQL_TIMESTAMP&quot; value=&quot;#now()#&quot;&gt;
  )
  </code></pre>
  <p>The weird thing is that, when it is being inserted, the formstruct parameters changes as below:</p>
  <p>I can not get why it changes while being inserted as Ä±,Ã¼ .</p>
  <pre><code>{&quot;userFname&quot;:&quot;&quot;,&quot;userEmail&quot;:&quot;&quot;,&quot;companyId&quot;:1,&quot;priority_id&quot;:3,&quot;userLTopic&quot;:&quot;donanÄ±m arÄ±zasÄ±&quot;,&quot;pdesc&quot;:&quot;cookie gÃ¼zel bir ÅŸekilde Ã§alÄ±ÅŸÄ±yorrrrr&quot;}
  </code></pre>