Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/htdocs/w01136d3/wordpress/wp-content/plugins/deans_code_highlighter/geshi.php on line 2147
Ob WHERE-Abfragen nun Großkleinschreibung beachten, kann man mit der Kollation festlegen, in der die Datenbank und die Tabellenfelder definiert werden. Die Kollation utf8_bin ist case sensitive. Für ein case insensitives Datenbankdesign kann man die Kollation utf8_general_ci verwenden, wobei das „ci“ für case insensitive steht. Mit utf8_bin sind aber trotzdem ist case insensitive Abfragen möglich, man muss nur die Kollation in der Abfrage mitlifern:
COLLATE utf8_general_ci
span class=“st0″>’Peter‘‚P%‘
Generell empfehle ich jedem, für internationale Projekte immer utf8 zu verwenden.
