CocaColaBear Posted April 9, 2014 Share Posted April 9, 2014 Hi all. I have problem on the side of MTA with encoding. Example query: dbExec(bdConnection, "UPDATE table SET text = 'Русский текст' WHERE id = 1") In database i have: "? ???????????? ?‚?µ?????‚" But if I do not execute this query from the MTA, and from phpMyAdmin result - Ok. Russian string normally displayed. Field and database encoding: cp1251 or utf8 (tried both) Link to comment
Arnold-1 Posted April 9, 2014 Share Posted April 9, 2014 try this dbExec(bdConnection, "UPDATE table SET text = ? WHERE id = 1",'Русский текст') not sure will work but try, i'm also new to SQL. Link to comment
Spajk Posted April 9, 2014 Share Posted April 9, 2014 You should change the database encoding to UTF-8. Link to comment
CocaColaBear Posted April 10, 2014 Author Share Posted April 10, 2014 You should change the database encoding to UTF-8. I've tried, no results 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