Db case sensitive: Difference between revisions From Online Manual

Jump to: navigation, search
(Created page with "{{smcfunc |function=db_case_sensitive |usage=$smcFunc['db_case_sensitive'] |description=Tells SMF whether the database is case sensitive (PostgreSQL and SQlite) or not (MySQL). '...")
 
m (refresh SMW properties)
 
(One intermediate revision by one other user not shown)
Line 7: Line 7:
$member_name = $smcFunc['db_case_sensitive'] ? 'LOWER(member_name)' : 'member_name'</nowiki>
$member_name = $smcFunc['db_case_sensitive'] ? 'LOWER(member_name)' : 'member_name'</nowiki>
}}
}}
<noinclude>
<noinclude>
[[Category:Database Functions]]
[[Category:Database Functions]]</noinclude>
[[Category:2.0]]
[[Category:Customizing SMF]]
[[Category:Developing SMF]]</noinclude>

Latest revision as of 16:40, 11 October 2012

Usage:

$smcFunc['db_case_sensitive']


Description: Tells SMF whether the database is case sensitive (PostgreSQL and SQlite) or not (MySQL). Shall not be called as a function, but used a boolean.

Return: True if the database is case sensitive false otherwise.

Example:

// Get the case of the columns right - but only if we need to as things like MySQL will go slow needlessly otherwise.
$member_name = $smcFunc['db_case_sensitive'] ? 'LOWER(member_name)' : 'member_name'



Advertisement: