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)));
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
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
: 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 datetime. The table will eventually
expand to include
-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).
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
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:
.
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 distribution)
Environment:
Slackware Linux 8.1 - 2.4.20 - 256MB - GCC