Req #64048 [Com]: Case Insensitive Data In Firebird/Interbase
Edit report at https://bugs.php.net/bug.php?id=64048&edit=1
ID: 64048
Comment by: matheus at gigatron dot com dot br
Reported by: jackmason at mindspring dot com
Summary: Case Insensitive Data In Firebird/Interbase
Status: Open
Type: Feature/Change Request
Package: InterBase related
Operating System: Linux/Windows
PHP Version: 5.3.21
Block user comment: N
Private report: N
New Comment:
What exactly is the limitation that the PDO-Firebird (or Interbase) interfaces has?
What sort of query or procedure can you do on a firebird client (such as IBExpert) that you cannot
do through the pdo/interbase interfaces?
Previous Comments:
------------------------------------------------------------------------
[2013-01-22 15:51:27] jackmason at mindspring dot com
Description:
------------
Firebird/InterBase databases provide case insensitive data capabilities for both tables and queries
but no such feature seems to exist in the PHP interface to either Firebird or InterBase.
The data we need to access will have wide variations in uppercase and lowercase such as McGraw,
Macarthur, MacArthur, Magee, MaGee as well as similar variations in data such as "the
Last..." versus "The Last...", "an Invitat..." versus "An
Invit..." or even "an invit..".
Please provide a method of issuing a query for "McGraw" that would find
"mcgraw", "Mcgraw", and "mcGraw".
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=64048&edit=1
Thread (3 messages)