<div>
I'm pretty sure the database collation is Latin_General_BIN<br />
<br />
I see if I can change the collation, if not I will incorporate the UPPER or LOWER functions<br />
<br />
<br />

</div>


I'm pretty sure the database collation is Latin_General_BIN

I see if I can change the collation, if not I will incorporate the UPPER or LOWER functions




<div>
It's not the collation, but a setting within the collation settings page. &nbsp;That sounded better in my head. &nbsp;IIRC, it is one of the options available when you select binary comparison.<br />

</div>


It's not the collation, but a setting within the collation settings page.  That sounded better in my head.  IIRC, it is one of the options available when you select binary comparison.


<div>
Changing the database collation is fairly painful for existing data, but easy for new data.<br />
<br />
<a href="http://support.microsoft.com/kb/325335" rel="ugc">http://support.microsoft.com/kb/325335</a><br />
<br />
When using upper() or lower() ensure you use it on both sides.
</div>


Changing the database collation is fairly painful for existing data, but easy for new data.

http://support.microsoft.com/kb/325335 [http://support.microsoft.com/kb/325335]

When using upper() or lower() ensure you use it on both sides.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have developed a simple SQL search system that uses LIKE &quot;%a%&quot; conditions<br />
<br />
The search works fine on my dev platform, (Win XP / PHP / Apache / SQL 2005)<br />
<br />
But on the clients platform (Win Server 2003 / PHP / Apache / SQL 2000) the search is case sensitive<br />
<br />
Can any help me as to why this might be?<br />
<br />

</div>
</div>


Hi,

I have developed a simple SQL search system that uses LIKE "%a%" conditions

The search works fine on my dev platform, (Win XP / PHP / Apache / SQL 2005)

But on the clients platform (Win Server 2003 / PHP / Apache / SQL 2000) the search is case sensitive

Can any help me as to why this might be?



PHP MSSQL DB Like statments are case sensitive

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.