Hi everyone, I've just got a quick question that appears to just be a little quirk in MySQL, or perhaps just in my web interface to my database... I recently threw all my clan_data into a mysql table, and of course one of the fields is the who_name... well, in standard rom, as you should all know, the who name has a space at the end of it, such as "[MYCLAN] " so that when the who list gets generated, it pops a space in between the clan and the player name, but if the player isn't in a clan, there's no space at the beginning of his/her name uglying it up... well, the problem is that my database doesn't seem to be storing that extra space... here's how I have a sample who name entered (minus the quotations):
"``[`4MYCLAN``] " Where the ` is my color marker, and `` nullifies color... now I'm sure that if I went "``[`4MYCLAN``] ``" that it would hold onto that space, but with only a space on the end of the string, it seems to be stripping it, and I'm not sure why... is this just the way mysql behaves when storing a string, stripping extraneous spaces? Or is it the way my web interface (Usermin) is passing the value to the actual database, stripping the extra spaces before handing off the value? Or is there something else that I'm missing?... I could easily write a little hack into do_who that adds an extra %s where the space should be, and says to put "" if the player isn't in a clan, and " " if they are, but I'd rather just fix the problem if I can, rather than writing a way around it... thanks in advance for any help :) Richard Lindsey
