php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Request #64048 Case Insensitive Data In Firebird/Interbase
Submitted: 2013-01-22 15:51 UTC Modified: 2013-06-25 12:22 UTC
From: jackmason at mindspring dot com Assigned:
Status: Wont fix Package: InterBase related
PHP Version: 5.3.21 OS: Linux/Windows
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jackmason at mindspring dot com
New email:
PHP Version: OS:

 

 [2013-01-22 15:51 UTC] 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".

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2013-03-22 13:58 UTC] matheus at gigatron dot com dot br 
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?
 [2013-06-25 12:22 UTC] mariuz@php.net
-Status: Open +Status: Wont fix
 [2013-06-25 12:22 UTC] mariuz@php.net 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

You need to use a Case Insensitive Collation on the server side 

http://www.destructor.de/firebird/caseinsensitivesearch.htm
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 25 23:01:29 2024 UTC