Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Normal for mysql to strip trailing spaces?
Normal for mysql to strip trailing spaces? [message #425] Sun, 26 November 2006 01:47 Go to previous message
carpii is currently offline carpii
Messages: 48
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
[Message index]

Read Message
Read Message
Read Message
Previous Topic:Slow connection to mysql
Next Topic:building new index on big tables
Goto Forum:

  

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

Current Time: Fri Jul 10 03:51:42 EDT 2009

Total time taken to generate the page: 0.02099 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.