MySQL Performance: MySQL => Normal for mysql to strip trailing spaces?

Members

Help

Home

Home » Performance » MySQL » Normal for mysql to strip trailing spaces?

Show: Today's Messages :: Show Polls :: Message Navigator

Normal for mysql to strip trailing spaces? [message #425]

Sun, 26 November 2006 01:47

carpii
Messages: 46
Registered: November 2006

Member

I have a table users, with u_username field varchar(20)
Im using mysql v5

select u_userid from users where u_username = 'carpii'
returns user id 17

select u_userid from users where u_username = 'carpii '
also returns user id 17

Is this normal behavior for mysql?
Can it be changed?

Report message to a moderator

Re: Normal for mysql to strip trailing spaces? [message #426 is a reply to message #425 ]

Sun, 26 November 2006 10:29

bitrockers
Messages: 11
Registered: November 2006
Location: Germany

Junior Member

That's indeed weired.... we're using Mysql 5.0.19 and it's the same behaviour as you describe. That also happens on 5.0.22.

If you do the same query using like instead of =,

... where u_username like 'carpi '

it doesn't happen. I don't know if that is expected behaviour by ANSI standard or mysql.

Greetings
Christian

UPDATE: Guess its expected behaviour by ANSI-Standard. While looking in bugs.mysql.com I've found the following bug. At the end you can see a comment in the mysql source code, that says they 'have' to do it. Smile

http://bugs.mysql.com/bug.php?id=14637

[Updated on: Sun, 26 November 2006 10:48]

Report message to a moderator

Re: Normal for mysql to strip trailing spaces? [message #427 is a reply to message #426 ]

Mon, 27 November 2006 10:02

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

Yeah,

This is far from being obvious but this is how it is designed.

See: http://www.mysql.org/doc/refman/5.1/en/char.html

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Previous Topic:	Slow connection to mysql
Next Topic:	building new index on big tables

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 7 17:45:46 EST 2009

Total time taken to generate the page: 0.22565 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.