RellaX Posted May 20, 2018 Share Posted May 20, 2018 (edited) Не могу записать русский текст базу данных, везде использую кодировку utf8, Сам mysql .lua function connect() connection = dbConnect("mysql","dbname="..db_table..";host="..db_host..";port="..db_port..";unix_socket=/var/run/mysqld/mysqld.sock",db_Name,db_Password) if (connection) then outputServerLog("MySQL: База данных была успешно подключена!") return true else outputServerLog("MySQL: База данных не была подключена!! Повторное подключение через 5 секунд...") setTimer(connect,5000,1) end end addEventHandler("onResourceStart",resourceRoot,connect) function singleQuery(str,...) if (connection) then local query = dbQuery(connection,str,...) local result = dbPoll(query,-1) if (type(result == "table")) then return result[1] else return result end else return false end end function execute(str,...) if (connection) then local query = dbExec(connection,str,...) return query else return false end end Edited May 20, 2018 by RellaX Link to comment
nikitafloy Posted May 21, 2018 Share Posted May 21, 2018 dbExec(ваше подключение, "SET CHARACTER SET utf8") 1 Link to comment
RellaX Posted May 21, 2018 Author Share Posted May 21, 2018 1 hour ago, nikitafloy said: dbExec(ваше подключение, "SET CHARACTER SET utf8") Мда, знал про это, но пихал туда, куда не нужно... Пофиг, спасибо. Решено Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now