0

I wanna to insert data to MSSQL by this:

$conn = sqlsrv_connect($serverName, $connectionInfo);
$tsql = "INSERT INTO table (name, name2) VALUES('$name_demo','$name2_demo')";  

My form looks like this:

<form action="index.php" method="POST" id="sky-form2" class="sky-form">

      <fieldset>
        <div class="row">
          <section class="col col-6">
            <label class="label">NAME</label>
            <label class="input"> <i class="icon-append icon-user"></i>
              <input type="text" name="name_demo" required id="name_demo">
            </label>
          </section>
            <section class="col col-6">
            <label class="label">NAME2</label>
            <label class="input"> <i class="icon-append icon-user"></i>
              <input type="text" name="name2_demo" required id="name2_demo">
            </label>
          </section>
        </div>

      </fieldset>
      <footer>
           <button type="submit" value="submit" class="button">SEND</button>

      </footer>

      <div class="message"> <i class="icon-ok"></i><BR>
        <p>SENT!</p>

      </div>
    </form>

Everything works fine except that some letters like ąćęó into the database looks like ąćęó

For example such word like: LONDĄĆĘ in the database looks like: LONDĄĆÄ

Any idea? I was trying to play with collate in the database - nothing helps.

Jarek Jarek
  • 33
  • 1
  • 2
  • 7

0 Answers0