User authentication in cyrillic characters issue
<p>I am having a problem with inserting a username and password in a login system using cyrillic characters.</p>

<p>The password is decoded as SHA1, when i create a user with cyrillic characters it doesn't work for me!</p>

<p>Can you tell me if i need to insert something special in it?</p>

<p>Thanks!
here is my code:</p>

<pre><code>$username = $_POST['username']; //Set UserName
$password = $_POST['password']; //Set Password
$msg ='';
if(isset($username, $password)) {
    ob_start();
    include(DOC_ROOT.'/config.php'); //Initiate the MySQL connection
    // To protect MySQL injection (more detail about MySQL injection)
    $myusername = stripslashes($username);
    $mypassword = stripslashes($password);
    $myusername = mysqli_real_escape_string($dbC, $myusername);
    $mypassword = mysqli_real_escape_string($dbC, $mypassword);
    $sql="SELECT * FROM login_subadmin WHERE user_name='$myusername' and user_pass=SHA1('$mypassword')";
    $result=mysqli_query($dbC, $sql);
    // Mysql_num_row is counting table row
    $count=mysqli_num_rows($result);
</code></pre>
