[wp-trac] Re: [WordPress Trac] #6410: DB_COLLATE is not used in database queries

[WordPress Trac]

#6410: DB_COLLATE is not used in database queries
-------------------------+--------------------------------------------------
 Reporter:  bertilow     |        Owner:  westi   
     Type:  enhancement  |       Status:  assigned
 Priority:  normal       |    Milestone:  2.5.1   
Component:  General      |      Version:  2.3     
 Severity:  normal       |   Resolution:          
 Keywords:               |  
-------------------------+--------------------------------------------------
Comment (by westi):

 Replying to [comment:7 DD32]:
 > > doesn't this mean db_collate is actually used?
 >
 > {{{"SET NAMES 'utf8'"}}} sets the charset to utf8[[BR]]
 > {{{"SET NAMES 'utf8' COLLATE 'abcde'"}}} sets the charset to utf8 AND
 the collate to abcde(I'm not sure of a valid collate, so i'm just using
 that as an example)

 This is correct.  Collation is rarely needed unless the db charset has
 many possible collations.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/6410#comment:8>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software