utf8_hungarian_ci
?tterem
(https://kepkuldes.com/images/8693f464e5f65bbd29c7d0943458de3d.png)Kód: [Kijelölés]mysql_set_charset("latin2_hungarian_ci ", g_Sql);
A tábla kódolását is 'latin2_hungarian_ci'-re állítsd + a benne lévő mezőkét is.
mysql_query (g_Sql, "SET NAMES latin2");
main()
{
g_Sql = mysql_connect("127.0.0.1", "root", "", "db_test");
mysql_set_charset("latin2_hungarian_ci ", g_Sql);
mysql_query (g_Sql, "SET NAMES latin2");
new stringem[25] = "Árvíztûrõ tükörfúrógép";
new query[128];
mysql_format(g_Sql, query, sizeof query, "INSERT INTO `test` (`szoveg`) VALUES ('%s')", stringem);
mysql_query(g_Sql, query);
}
Próbáld meg akkor ezt hozzáadni:Direkt beküldte az ember, hogy utf8_hungarian_ci-ben van a tábla karakterkódolása..Kód: [Kijelölés]mysql_query (g_Sql, "SET NAMES latin2");
Így néz ki az én példa scriptem:Kód: [Kijelölés]main()
{
g_Sql = mysql_connect("127.0.0.1", "root", "", "db_test");
mysql_set_charset("latin2_hungarian_ci ", g_Sql);
mysql_query (g_Sql, "SET NAMES latin2");
new stringem[25] = "Árvíztûrõ tükörfúrógép";
new query[128];
mysql_format(g_Sql, query, sizeof query, "INSERT INTO `test` (`szoveg`) VALUES ('%s')", stringem);
mysql_query(g_Sql, query);
}
Eredmény:
(https://i.imgur.com/Swp4pUG.png)
[18:33:09] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:09] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:09] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:09] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:09] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:09] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:09] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:09] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:10] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:11] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:12] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype
[18:33:13] [ERROR] cache_get_field_content_int - invalid datatype