strtolower wont do his job

[Kristof Goossens]

Hi you guys,

in the following insert the strtolower wont put the chars in lowercase.
Any ideas what i'm doing wrong?

the code:

$qryInsRel = "INSERT INTO \"tblrelations\" (rid, vcfirstname,
vclastname, vccompany, vcfunction, nlangid, ngenderid, nuserid,
ntitleid, dtbirthdate, vcbankaccount, vcvatnr, vctraderegisternr)
VALUES(" . $relNextVal .", '" . $_POST["txtFirstName"] . "', '" .

strtolower($_POST["txtLastName"])

.. "', '" . $_POST["txtCompany"] . "', '" . $_POST["txtFunction"] . "',
'" . $_POST["txtLanguage"] . "', '" . $_POST["txtGender"] . "', '" .
$_COOKIE["cUserID"] . "', '" . $_POST["txtTitle"] . "', '" . $bday .
"', '" . $_POST["txtBankaccount"] . "', '" . $_POST["txtVATNr"] . "',
'" . $_POST["txtTradeRegNr"] . "')";

(btw i moved a bit from the layout of the code but the rest is exactly
what i have)
thx in advance,

kristof

[Andy Hassall]

On Tue, 23 Dec 2003 21:15:21 +0100, Kristof Goossens <ne********@z-web.be>
wrote:

in the following insert the strtolower wont put the chars in lowercase.
Any ideas what i'm doing wrong?

the code:

$qryInsRel = "INSERT INTO \"tblrelations\" (rid, vcfirstname,
vclastname, vccompany, vcfunction, nlangid, ngenderid, nuserid,
ntitleid, dtbirthdate, vcbankaccount, vcvatnr, vctraderegisternr)
VALUES(" . $relNextVal .", '" . $_POST["txtFirstName"] . "', '" .

strtolower($_POST["txtLastName"])

. "', '" . $_POST["txtCompany"] . "', '" . $_POST["txtFunction"] . "',
'" . $_POST["txtLanguage"] . "', '" . $_POST["txtGender"] . "', '" .
$_COOKIE["cUserID"] . "', '" . $_POST["txtTitle"] . "', '" . $bday .
"', '" . $_POST["txtBankaccount"] . "', '" . $_POST["txtVATNr"] . "',
'" . $_POST["txtTradeRegNr"] . "')";

(btw i moved a bit from the layout of the code but the rest is exactly
what i have)

What evidence do you have that it is not converting to lower case?

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Janwillem Borleffs]

"Kristof Goossens" <ne********@z-web.be> schreef in bericht
news:bs**********@reader10.wxs.nl...

Hi you guys,

in the following insert the strtolower wont put the chars in lowercase.
Any ideas what i'm doing wrong?

When using mysql (and many other databases), it doesn't make sence to
lowercase data, because non-binary data is treated case-insensitive by
default.
JW

[Dark Angel]

but from what I've been reading about this can be changed in the db can it
not?

--
Best Regards
Dark Angel

--------------------------------------------------------------------------
http://www.stateofmind.me.uk - My Home Page
http://www.keir.net/k9.html - Free spam filter for windows
http://www.shrine2aeris.co.uk - My shrine to Aeris from FF7
"Janwillem Borleffs" <[e-mail]> wrote in message
news:3f*********************@news.wanadoo.nl...

"Kristof Goossens" <ne********@z-web.be> schreef in bericht
news:bs**********@reader10.wxs.nl...

Hi you guys,

in the following insert the strtolower wont put the chars in lowercase.
Any ideas what i'm doing wrong?

When using mysql (and many other databases), it doesn't make sence to
lowercase data, because non-binary data is treated case-insensitive by
default.
JW

[Janwillem Borleffs]

"Dark Angel" <ni***********@hotmail.com> schreef in bericht
news:ns***************@news-binary.blueyonder.co.uk...

but from what I've been reading about this can be changed in the db can it
not?

True, that's why I said `by default`.
JW

[Andy Hassall]

On Tue, 23 Dec 2003 22:57:14 +0100, "Janwillem Borleffs" <[e-mail]>
wrote:

"Kristof Goossens" <ne********@z-web.be> schreef in bericht
news:bs**********@reader10.wxs.nl...

in the following insert the strtolower wont put the chars in lowercase.
Any ideas what i'm doing wrong?

When using mysql (and many other databases), it doesn't make sence to
lowercase data, because non-binary data is treated case-insensitive by
default.

If you want your data stored in lowercase, that's a different matter from how
the database does comparisons. Besides, no database was mentioned.

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Dark Angel]

still learning u see, so it some times good to ask questions. :) keeps them
brains cells alive :)

--
Best Regards
Dark Angel

--------------------------------------------------------------------------
http://www.stateofmind.me.uk - My Home Page
http://www.keir.net/k9.html - Free spam filter for windows
http://www.shrine2aeris.co.uk - My shrine to Aeris from FF7
"Janwillem Borleffs" <[e-mail]> wrote in message
news:3f***********************@news.euronet.nl...

"Dark Angel" <ni***********@hotmail.com> schreef in bericht
news:ns***************@news-binary.blueyonder.co.uk...

but from what I've been reading about this can be changed in the db can it not?

True, that's why I said `by default`.
JW

[Janwillem Borleffs]

"Andy Hassall" <an**@andyh.co.uk> schreef in bericht
news:pr********************************@4ax.com...

If you want your data stored in lowercase, that's a different matter from how the database does comparisons.
Sure, but it's my guess that the data is stored lowercase for an easy match
in a where/like clause. When I'm wrong in my assumption, the OP will ignore
my post.
Besides, no database was mentioned.

No, but an SQL query was. That's why I started with `When using mysql...`.
When not applicable, the audience will ignore my comment automaitcally.
JW

[Janwillem Borleffs]

"Dark Angel" <ni***********@hotmail.com> schreef in bericht
news:02*************@news-binary.blueyonder.co.uk...

still learning u see, so it some times good to ask questions. :) keeps them brains cells alive :)

Your absolutely right :-)

Regards,
JW

[Kristof Goossens]

Janwillem Borleffs wrote:

"Andy Hassall" <an**@andyh.co.uk> schreef in bericht
news:pr********************************@4ax.com...

If you want your data stored in lowercase, that's a different matter from

how

the database does comparisons.

Sure, but it's my guess that the data is stored lowercase for an easy match
in a where/like clause. When I'm wrong in my assumption, the OP will ignore
my post.

Besides, no database was mentioned.

No, but an SQL query was. That's why I started with `When using mysql...`.
When not applicable, the audience will ignore my comment automaitcally.
JW

Hi thx to all for the reply,

i'm using postgre-sql and i need the data in lowercase so i can order it
by surname. Now he orders the data ascending but first for the Uppercase
names and then for the lowercase names so you get something like this:

Aword
Bword
Zword
aword
bword
zword

and if i insert them in lowercase by default this problem should be fixed...

greetz,

kristof

[Geoff Berrow]

I noticed that Message-ID: <bs**********@reader08.wxs.nl> from Kristof
Goossens contained the following:

Aword
Bword
Zword
aword
bword
zword

and if i insert them in lowercase by default this problem should be fixed...

But you'll have to correct the case again (ie change the first letter to
uppercase using something like substr()) before you can use it. May as
well do that before you store it.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Markus Ernst]

"Geoff Berrow" <bl******@ckdog.co.uk> schrieb im Newsbeitrag
news:e8********************************@4ax.com...

I noticed that Message-ID: <bs**********@reader08.wxs.nl> from Kristof
Goossens contained the following:

Aword
Bword
Zword
aword
bword
zword

and if i insert them in lowercase by default this problem should be

fixed...
But you'll have to correct the case again (ie change the first letter to
uppercase using something like substr()) before you can use it. May as
well do that before you store it.

To convert the first character to uppercase you can use ucfirst().

Anyway I suggest to store the names unchanged, as some might begin with a
lowercase character (van Damme, ar Rashid...). Just convert the string for
the sort. In MySQL there is a UPPER() function to convert to uppercase:

.... ORDER BY UPPER(name)

(not tested). There might be something similar in Postgre SQL.

HTH
Markus

[Geoff Berrow]

I noticed that Message-ID: <3f***********************@news.easynet.ch>
from Markus Ernst contained the following:

To convert the first character to uppercase you can use ucfirst().
So many functions, so little memory...
Anyway I suggest to store the names unchanged, as some might begin with a
lowercase character (van Damme, ar Rashid...). Just convert the string for
the sort. In MySQL there is a UPPER() function to convert to uppercase:

Yes you are right.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Kristof Goossens]

Geoff Berrow wrote:

I noticed that Message-ID: <3f***********************@news.easynet.ch>
from Markus Ernst contained the following:

To convert the first character to uppercase you can use ucfirst().

So many functions, so little memory...

Anyway I suggest to store the names unchanged, as some might begin with a
lowercase character (van Damme, ar Rashid...). Just convert the string for
the sort. In MySQL there is a UPPER() function to convert to uppercase:

Yes you are right.

thx guys it worked

and a Merry X-mass to ya all :)