Differences

This shows you the differences between two versions of the page.

--- v5:session:session_index [2023/03/27 13:02] – [MySQL or PDO MySQL] create table with binary collation dregad
+++ v5:session:session_index [2023/03/27 13:14] – [MySQL or PDO MySQL] explain reason for using binary collation dregad
@@ Line 162: / Line 162: @@
 )
 </code>
+<WRAP info>
+When [[https://www.php.net/manual/en/session.configuration.php#ini.session.sid-bits-per-character|session.sid_bits_per_character]] php.ini setting is set to 6, the //Session ID// can contain both upper and lowercase letters.
+Collisions could occur in this case, due to MySQL performing case-insensitive searches by default.
+To avoid that, the //sesskey// column should use binary (or a case-sensitive) collation.
+</WRAP>
 ==== PostgreSQL ====