Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 2.5.0b5

Bug #13313 setCharSet does not support 'COLLATE'
Submitted: 2008-03-05 12:39 UTC
From: mthielen Assigned: quipo
Status: Closed Package: MDB2 (version 2.4.1)
PHP Version: 5.2.5 OS: Linux, Windows
Roadmaps: (Not assigned)    

 [2008-03-05 12:39 UTC] mthielen (Markus Thielen)
Description: ------------ I want to change the connection collation and not only the charset. With MySQL(i) this is done by set names latin1 COLLATE 'latin1_german1_ci'; The method setCharSet in Driver/mysql(i).php does only support the charset, not the collation. Test script: --------------- .... $mdb->setCharSet('latin1_german1_ci'); Expected result: ---------------- The connection charset should be latin1 and the collation should be latin1_german1_ci Actual result: -------------- => MDB2 Error: unknown error _doQuery: [Error message: Could not execute statement] [Last executed query: SET NAMES 'latin1_german1_ci'] [Native code: 0]


 [2008-03-05 13:27 UTC] quipo (Lorenzo Alberton)
Please fetch the CVS version and try with this code: $charsetCollation = array('latin1', 'latin1_german1_ci'); $mdb2->setCharSet($charsetCollation); If it doesn't work, please reopen this bug report. Thank you.