> -----Original Message-----
> From: Martijn Tonies [mailto:m.tonies@stripped]
> Sent: Thursday, June 12, 2008 6:23 AM
> To: MySQL List
> Subject: Re: Function Still Not Working
> > Sorry for posting this again, but I got only one response last time,
> > still having the problem. I spent HOURS the other day manually
> > through the data and Properizing these things by hand. I don't want
> to do
> > that again if I can avoid it. If anyone has any clues on this one,
> > appreciate it.
> > It's a very simple function used to properize a string sent to it.
> When I
> > a simple SELECT ProperCase('JESSE'); it returns "JESSE" on our
> > is running 5.0.17-nt-log. On another server that I've got, running
> > 5.0.51a-community-nt, this function returns "Jesse" as it should.
> > The only difference that I can think of is the version. Is there a
> > with the older version that would cause this function not to work
> Any difference in default collation?
I am curious about that, as well. It brings to mind a discussion that
happened on this list last week (I believe) about case
sensitive/insensitive use of LIKE. I believe the synopsis was that
tables are either created as case-insensitive, or the search needs to be
specified as case sensitive (with BINARY).
Could this be a similar issue, perhaps? One table is specifically
case-insensitive with regard to the function, and the other is not?