(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> | ||
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'
