InnoDB crash recovery and innodb_support_xa, sync_binlog

xa=on + sync_binlog=0 is2 times slower than xa=off + sync_binlog=0. xa=on + sync_binlog=1 is 4..7 times slower than xa=off + sync_binlog=0. # This benchmark done with hard disk that have 128MB write cache and # battery backup unit. but xa=on + sync_binlog=1 is very slower... Please any a

UDF: how to get chracter set or convert stinrg to another character set

character_set_client character_set_connection character_set_results MySQL-4.0.18 character_set 2. how to convert character encoding in UDF. eg: convert "ujis" stinrg which was provided by client to "utf8". Thanks for any help. -- HIROSE, Masaaki -- MySQL General M