[Help] Mysql Charset

[djharbi2]

Hi, saving datebase. But does not record the question properly

entered: your favorite writer?
saved: your favorite writer'

(? instead  '  is happening)

database charset: utf-8

how can I solve this problem?

local username = "root"
local password = "123456"
local b_data = dbConnect("mysql","dbname=mtaserver;host=localhost;charset=utf8;port=3311", username, password, "autoreconnect=1"),

local b_username = "admin"
local b_pass = "1234"
local b_ques = "your favorite writer?"
local b_answ = "T. Well"
local b_money = "0"

local bank = dbExec(b_data, "INSERT INTO bank (bank_username,bank_pass,bank_ques,bank_answ,bank_money) VALUES('"..b_username.."','"..b_pass.."','"..b_ques.."','"..b_answ.."','"..b_money.."')")

 

Edited June 16, 2019 by djharbi2

[salh]

where is b_date?

[djharbi2]

3 minutes ago, salh said:

where is b_date?

I didn't write it here, it normally exists

[djharbi2]

Does anyone know the problem?

[Patrick]

1 hour ago, djharbi2 said:

Does anyone know the problem?

 

Try, like this:

dbExec(b_data, "INSERT INTO bank (bank_username,bank_pass,bank_ques,bank_answ,bank_money) VALUES (?,?,?,?,?)", b_username, b_pass, b_ques, b_answ, b_money)

 

[djharbi2]

5 minutes ago, stPatrick said:

 

Try, like this:

dbExec(b_data, "INSERT INTO bank (bank_username,bank_pass,bank_ques,bank_answ,bank_money) VALUES (?,?,?,?,?)", b_username, b_pass, b_ques, b_answ, b_money)

problem persists

[Investor]

Could be related to issue 634 as its solution changed some stuff regarding question marks within a query.

[0xCiBeR]

Can you show us an outputDebugString showing the data that you are trying to insert?