Posts: 534
Threads: 265
Joined: Jul 2014
Hi,
Using %e in INSERT INTO query gives me e string in database what a ? i write a normal test
Posts: 280
Threads: 1
Joined: Oct 2014
Reputation:
0
%e is like %s but %e automaticly escape your string to avoid sql injections
Posts: 534
Threads: 265
Joined: Jul 2014
I know that but i say that when i use %e the string is not normal...
Posts: 280
Threads: 1
Joined: Oct 2014
Reputation:
0
When player enter a string and you want send it to db
For example
Register dialog
Change password
Or for example edit email
Somthing like this
Posts: 534
Threads: 265
Joined: Jul 2014
Read what i write.. All is well, but in database text what i write is 'e' but i write a normal text with %s is everything normal..
Posts: 1,733
Threads: 20
Joined: Nov 2010
Reputation:
0
Can you show the query?
Do you use the "mysql_format" or the normal "format" provided by PAWN?
Also, with which variable-type is your column defined in MySQL?
For strings, just use varchar type fields.
Posts: 534
Threads: 265
Joined: Jul 2014
I just changed %s to %e and then not normal things start to write.. I change to %s everything is well. For update queries, select all is well. I use mysql_tquery