[rt-users] Login fails after reinstall of RT 3.4.4 -- SOLVED

[Scott Courtney]

On Tuesday 08 November 2005 01:29, Les Mikesell wrote:
> > I only discovered the problem by accident. As I was trying Luke's suggestion
> > for the password, and had previously been referencing records by ID number,
> > as in "SELECT * FROM Users WHERE id=12;". In that case, however, I issued the
> > command "SELECT * FROM Users WHERE name='root';" and was amazed that MySQL
> > didn't match the record.
> 
> Is your system default characterset latin1?  If not, when does the
> conversion happen when a non-default characterset is specified
> at the table level in mysql?

I'm pretty sure it's UTF-8 encoding, and I'm not sure about the character
set. I haven't yet had time to test with specifying the charset at the table
level. (At this point, I'm just glad to have my users back online. {GRIN})

Scott

-- 
------------------------------------------------------------------------------
Scott Courtney         | "I don't mind Microsoft making money. I mind them
scott at 4th.com          | having a bad operating system."    -- Linus Torvalds
http://4th.com/        | ("The Rebel Code," NY Times, 21 February 1999)
                       | PGP Public Key at http://4th.com/keys/scott.pubkey