MySQL Polskie Litery

[Nubzior]

Dobra, u mnie śmiga.

Kod serwerowy:

Squirrel Script

local mysqlHandler = null;
 
addEvent("onInit", function()
{
mysqlHandler = mysql_connect("127.0.0.1", "root", "", "go");
mysql_query(mysqlHandler, "SET NAMES cp1250;");
mysql_query(mysqlHandler, "SET CHARACTER_SET cp1250_polish_ci");
 
mysql_query(mysqlHandler, "INSERT INTO `gracze` (`nick`, `haslo`) VALUES ('Józuś', 'ąćópl');");
});
 
addEvent("onCommand", function(pid, cmd, params)
{
if(cmd == "test")
{
local args = sscanf("ss", params);
if (args)
{
mysql_query(mysqlHandler, "INSERT INTO `gracze` (`nick`, `haslo`) VALUES ('" + args[0] + "', '" + args[1] + "');");
}
}
});

Baza danych:

Code:

CREATE DATABASE IF NOT EXISTS `go` DEFAULT CHARACTER SET cp1250 COLLATE cp1250_polish_ci;
USE `go`;
CREATE TABLE IF NOT EXISTS `gracze` (
  `nick` varchar(20) COLLATE cp1250_polish_ci NOT NULL,
  `haslo` varchar(20) COLLATE cp1250_polish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=cp1250 COLLATE=cp1250_polish_ci;