How to enter an umlaut in MS SQL in php?

Question

PHP

Hello uv. community. Tell me, I'm entering the text into the database in which there are umlauts and the database is entered incorrectly.

$server = '111.111.111.117'; 
$user = "test";     
$pass = "test";   
$mydb = "test"; 

$con = mssql_connect($server, $user, $pass);

mssql_query("INSERT INTO [table] ([Address]) VALUES ('Ostfildern, Niemöllerstrasse')");

Ostfildern, Niemöllerstrasse comes to the base

Answer 1

[Address]

Must be of type UNICODE .
Google gave this answer: UTF-8 encoding problem .