I have the following function on two servers:
CREATE FUNCTION `ProperCase`(cInput TEXT)
RETURNS text
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
Declare cReturn Text;
Set cReturn = CONCAT(UPPER(SUBSTRING(cInput,1,1)),LOWER(SUBSTRING(cInput
FROM 2)));
RET
[EMAIL PROTECTED]
cc:
Subject: re: now() function not working with load data infile
On Tuesday 24 December 2002 10:30, [EMAIL PROTECTED] wrote:
> I've created a test table with two columns. The first
> one is a varchar type for inputting first names. The
> second column is dat
On Tuesday 24 December 2002 10:30, [EMAIL PROTECTED] wrote:
> I've created a test table with two columns. The first
> one is a varchar type for inputting first names. The
> second column is datetime. The table will eventually
> expand to include a timestamp column, so I am not
> interested in g
I've created a test table with two columns. The first
one is a varchar type for inputting first names. The
second column is datetime. The table will eventually
expand to include a timestamp column, so I am not
interested in getting that to work at this time.
If I use MySQL monitor, I can use th
Yes, that's intentional - we have changed this in 4.1, but it's not
documented in the manual yet. A quote from the developer working on that
code:
So, the PASSWORD() function is now not to be used for passwords? The
problem is that I have built at least a few applications that use
PASSWORD() as
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002 [EMAIL PROTECTED] wrote:
> >Description:
> with the latest 4.1 tree (from today) the PASSWORD() function returns random
>alpha-numeric text /[a-f0-9]/
> 45 characters in length (which is too long for a password string)
');
>Fix:
Not known.
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: none
>Synopsis: PASSWORD() function not working
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.0-alpha (Source distri
>Description:
with the latest 4.1 tree (from today) the PASSWORD() function returns random
alpha-numeric text /[a-f0-9]/
45 characters in length (which is too long for a password string). The string
always starts with a * (asterisk).
example:*95144feaa0f433f3f62c29
