| Xgc | Sp00f3d: and mysqld normally should not be. |
| Sp00f3d | and it's jammed! :< I can not do anything now |
| Xgc | Sp00f3d: Did you restart (stop then start)? |
| Sp00f3d | no killall mysqld |
| Xgc | Sp00f3d: I can't admin your system. You really need to know how to do this for your specific installation. |
| EdBoy | Xgc: did you get my PM? |
| Xgc | Sp00f3d: You may not be starting properly. EdBoy: I see it. You should use a pastebin next time. EdBoy: You're likely still using the wrong character set. EdBoy: That's pretty much guaranteed. |
| zophy | what C lib works well for using mysql ? |
| EdBoy | no, I checked both are latin1 |
| Xgc | EdBoy: MySQL isn't lying. |
| mmxgn | Question: How can I get a resultset from two queries that has rows of both and not removing duplicates like union does? |
| Xgc | zophy: http://dev.mysql.com/doc/refman/5.0/en/c.html |
| EdBoy | I know. |
| Xgc | mmxgn: UNION ALL |
| EdBoy | I opened up both tables they're identical, but one won't accept VARCHAR(255) it's really weird |
| mmxgn | ok thank you. |
| Xgc | EdBoy: Use mysqldump to dump the table and post that. |
| EdBoy | uhhhhhh I don't know what that is |
| zophy | Xgc, mucho gracias |
| Xgc | zophy: You're welcome. |
| EdBoy | oh found it |
| Xgc | EdBoy: Those tables are using the default character set. I doubt you change the server default, which is probably still a multi-byte character set. |
| EdBoy | woah woah yeah, they are |
| action | Xgc nods. |
| Xgc | nods. |
| EdBoy | why they're initiating with the default, I don't know |
| Xgc | EdBoy: Just recreate them with an explicit character set. |
| EdBoy | by changing it to character_set latin1? |
| Xgc | EdBoy: CREATE TABLE tbl ( ... ) ENGINE=MyISAM CHARSET=blah; EdBoy: It's possible ALTER TABLE can be used. Be careful with that. |