Fix Bug #4047: remove the improvement ported from 4.0 that made InnoDB to remember the original select_lock_type inside LOCK TABLES

into mc05.(none):/space2/tomas/mysql-4.1-ndb-test

into mysql.com:/dbdata/psergey/mysql-4.1-ps-merge

into mysql.com:/home/jonas/src/mysql-4.1-ndb

into mysql.com:/home/jonas/src/mysql-4.1-ndb

into mysql.com:/home/mysql_src/mysql-4.1-874

into mc05.(none):/space2/tomas/mysql-4.1

into gluh.mysql.r18.ru:/home/gluh/MySQL-BUGS/mysql-4.1

  WL#1160.
  Adding variable-conformant startup options for --default-character-set and --default-collation

  Dump could fail to load because of --default-character-set command line option.
  More safe dump is now produces, --default-character-set doesn't matter.

  Bug #3990  	`--with-charset' ./configure's switch doesn'taffect mysql client library.

into brian-akers-computer.local:/Users/brian/mysql/mysql-4.1

A couple of small changes to ha_example (mainly comments). 

into brian-akers-computer.local:/Users/brian/mysql/mysql-4.1

into brian-akers-computer.local:/Users/brian/mysql/mysql-4.1

No need for mysql_commit, especially after DDL statements.

Is there a way to sefely use MYSQL_BIND structure without bzero?

into kite-hub.kitebird.com:/src/extern/MySQL/bk/mysql-4.1

into poseidon.ndb.mysql.com:/home/tomas/mysql-4.1-ndb

  Typo fix.
  Thanks Vladimir Kolpakov who noticed it.

into mysql.com:/dbdata/psergey/mysql-4.1-ps-merge

into mysql.com:/home/mysql_src/mysql-4.1

by binlogging some SET ONE_SHOT CHARACTER_SETetc,
which will be enough until we have it more compact and more complete in 5.0. With the present patch,
replication will work ok between 4.1.3 master and slaves, as long as:
- master and slave have the same GLOBAL.COLLATION_SERVER
- COLLATION_DATABASE and CHARACTER_SET_DATABASE are not used
- application does not use the fact that table is created with charset of the USEd db (BUG#2326).
all of which are not too hard to fulfill. 
ONE_SHOT is reserved for internal use of mysqlbinlog|mysql and works only for charsets,
so we give error if used for non-charset vars.
Fix for BUG#3875 "mysqlbinlog produces wrong ouput  if query uses
 variables containing quotes" and BUG#3943 "Queries with non-ASCII literals are not replicated
 properly after SET NAMES".
Detecting that master and slave have different global charsets or server ids.