drbigfresh Posted March 7, 2008 Share Posted March 7, 2008 I was updating a field in phpmyadmin (for a table I didn't create), and instead of just generating the usual update statement, it generated an update statement combined with converting every field associated with that record. I've never seen this before, is this an indication I need to make some changes to something in the table? The update is below: "UPDATE `wedding_user` SET `MarkerID` = 'xxx' WHERE `wedding_user`.`ID` = 2 AND CONVERT(`wedding_user`.`FName` USING utf8) = 'Troy' AND CONVERT(`wedding_user`.`LName` USING utf8) = 'Burnley' ...." Quote Link to comment https://forums.phpfreaks.com/topic/94938-quick-strange-mysql-update-question/ Share on other sites More sharing options...
Daniel0 Posted March 7, 2008 Share Posted March 7, 2008 It's just changing the encoding to utf8, I'm not sure why it does that though. It shouldn't break anything. Quote Link to comment https://forums.phpfreaks.com/topic/94938-quick-strange-mysql-update-question/#findComment-486322 Share on other sites More sharing options...
drbigfresh Posted March 7, 2008 Author Share Posted March 7, 2008 it definitely isn't breaking anything, I am just worried that it is doing it because the encoding is somehow wrong for the table... Quote Link to comment https://forums.phpfreaks.com/topic/94938-quick-strange-mysql-update-question/#findComment-486427 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.