#mysql - Sat 19 May 2007 between 14:39 and 14:48

NY Lost Funds



XgcSp00f3d: and mysqld normally should not be.
Sp00f3dand it's jammed! :<
I can not do anything now
XgcSp00f3d: Did you restart (stop then start)?
Sp00f3dno
killall mysqld
XgcSp00f3d: I can't admin your system. You really need to know how to do this for your specific installation.
EdBoyXgc: did you get my PM?
XgcSp00f3d: 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.
zophywhat C lib works well for using mysql ?
EdBoyno, I checked
both are latin1
XgcEdBoy: MySQL isn't lying.
mmxgnQuestion: How can I get a resultset from two queries that has rows of both and not removing duplicates like union does?
Xgczophy: http://dev.mysql.com/doc/refman/5.0/en/c.html
EdBoyI know.
Xgcmmxgn: UNION ALL
EdBoyI opened up both tables
they're identical, but one won't accept VARCHAR(255)
it's really weird
mmxgnok thank you.
XgcEdBoy: Use mysqldump to dump the table and post that.
EdBoyuhhhhhh
I don't know what that is
zophyXgc, mucho gracias
Xgczophy: You're welcome.
EdBoyoh
found it
XgcEdBoy: Those tables are using the default character set. I doubt you change the server default, which is probably still a multi-byte character set.
EdBoywoah woah
yeah, they are
actionXgc nods.
Xgcnods.
EdBoywhy they're initiating with the default, I don't know
XgcEdBoy: Just recreate them with an explicit character set.
EdBoyby changing it to character_set latin1?
XgcEdBoy: CREATE TABLE tbl ( ... ) ENGINE=MyISAM CHARSET=blah;
EdBoy: It's possible ALTER TABLE can be used. Be careful with that.

Page: 2 9 16 23 30 37 

IrcArchive

NY Lost Funds