Mogelijk Hoofdletter ongevoelig in database

Post toch ongeveer de denk/script wijze

Nou kheb die waarde gewoon een id meegegeven en ipv op die naam te zoeken zoek ik op die id

Oke, voorkennis dus...

MySQL is hier nochtans niet hoofdlettergevoelig....

Of ik nu
SELECT * FROM tabel WHERE naam = 'rafael'
gebruik, of ik gebruik
SELECT * FROM tabel WHERE naam = 'RAFAEL'
beide geven hetzelfde resultaat :)

Edit:
Meer info, Windows XP, MySQL 4.0.23-nt, op m'n server ook net getest, Linux, MySQL 4.1.13-standard, werken beide perfect.

Ligt eerder aan het veld type denk ik... Ik heb TINYTEXT in gebruik op het desbetreffende veldje...

Ik heb varchar als type veld en MySQL 4.1.12a

VARCHAR
The range of Length is 1 to 255 characters. VARCHAR values are sorted and compared in case-insensitive fashion unless the BINARY keyword is given

Bron: http://help.scibit.com/Mascon/masconMySQL_Field_Types.html

Edit:

A.5.1. Case Sensitivity in Searches

By default, MySQL searches are not case sensitive (although there are some character sets that are never case insensitive, such as czech). This means that if you search with col_name LIKE 'a%', you get all column values that start with A or a. If you want to make this search case sensitive, make sure that one of the operands has a case sensitive or binary collation. For example, if you are comparing a column and a string that both have the latin1 character set, you can use the COLLATE operator to cause either operand to have the latin1_general_cs or latin1_bin collation. For example:

col_name COLLATE latin1_general_cs LIKE 'a%'
col_name LIKE 'a%' COLLATE latin1_general_cs
col_name COLLATE latin1_bin LIKE 'a%'
col_name LIKE 'a%' COLLATE latin1_bin

If you want a column always to be treated in case-sensitive fashion, declare it with a case sensitive or binary collation. See Section 13.1.5, “CREATE TABLE Syntax”.

Before MySQL 4.1, COLLATE is unavailable. Use the BINARY operator in expressions to treat a string as a binary string: BINARY col_name LIKE 'a%' or col_name LIKE BINARY 'a%'. In column declarations, use the BINARY attribute.

Simple comparison operations (>=, >, =, <, <=, sorting, and grouping) are based on each character's “sort value.” Characters with the same sort value (such as ‘E’, ‘e’, and ‘é’) are treated as the same character.

Bron: http://dev.mysql.com/doc/mysql/en/case-sensitivity.html

Zoals Rafael iets dergelijks al beschreef (of hoe ik het ook ervaren heb), het heeft (voornamelijk) te maken met de database-collation. Het type database. Volgens mij is het ook te zien in PHPMyAdmin. Hierin kan je kiezen welk type database'opbouw; je wilt gebruiken,
en of deze opbouw case-sensitive (hoofdlettergevoelig) is.