|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)?|
|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||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.|
I don't know what that is
|zophy||Xgc, mucho gracias|
|Xgc||zophy: You're welcome.|
|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.|
yeah, they are
|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.