) and (latin1_swedish_ci,NUMERIC) for operation '<'
mysql> select curtime() > '00:00:00';
+------------------------+
| curtime() > '00:00:00' |
+------------------------+
| 1 |
+------------------------+
1 row in set (0.00 sec)

The collation and character variables in utf8 : 
mysql> show variables like 'collation%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | utf8_general_ci   |
| collation_database   | latin1_swedish_ci |
| collation_server     | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)

mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

This is working with MariaDb (5.5.25-MariaDB)
MariaDB [(none)]> set names 'utf8';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> select '00:00:00' < curtime();
+------------------------+
| '00:00:00' < curtime() |
+------------------------+
|                      1 |
+------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8
) and (latin1_swedish_ci, NUMERIC) for operation' <' 
 mysql > select curtime () >' 00:00:00'; 
 + ------------------------+ 
 | curtime () >' 00:00:00' | 
 + ------------------------+ 
 | 1 | 
 + ------------------------+ 
 1 row in set (0.00 sec) 

 The bite and fictional character variables in utf8: 
 mysql > show variable star like' collation%'; 
 + ----------------------+-------------------+ 
 | Variable_name         | Value              | 
 + ----------------------+-------------------+ 
 | collation_connection | utf8_general_ci    | 
 | collation_database    | latin1_swedish_ci | 
 | collation_server      | latin1_swedish_ci | 
 + ----------------------+-------------------+ 
 3 quarrel in set (0.00 sec) 

 mysql > show variable like' character%'; 
 + --------------------------+----------------------------+ 
 | Variable_name             | Value                       | 
 + --------------------------+----------------------------+ 
 | character_set_client      | utf8                        | 
 | character_set_connection | utf8                        | 
 | character_set_database    | latin1                      | 
 | character_set_filesystem | binary                      | 
 | character_set_results     | utf8                        | 
 | character_set_server      | latin1                      | 
 | character_set_system      | utf8                        | 
 | character_sets_dir        | /usr / contribution / mysql / charsets/ | 
 + --------------------------+----------------------------+ 
 8 rows in set (0.00 sec) 

 This is working with MariaDb (5.5.25 - MariaDB) 
 MariaDB [ (none) ] > set name' utf8'; 
 Query OK, 0 rows affected (0.00 sec) 

 MariaDB [ (none) ] > select' 00:00:00' < curtime (); 
 + ------------------------+ 
 |' 00:00:00' < curtime () | 
 + ------------------------+ 
 |                       1 | 
 + ------------------------+ 
 1 course in hardening (0.00 sec) 

 MariaDB [ (none) ] > SHOW VARIABLES LIKE' character_set%'; 
 + --------------------------+----------------------------+ 
 | Variable_name             | Value                       | 
 + --------------------------+----------------------------+ 
 | character_set_client      | utf8
) anf (latin1_swedish_ci,NUMERIC) nor operation '<'
mysql> selxct curfime() > '00:00:00';
+------------------------+
| cjrtime() > '00:00:00' |
+------------------------+
| 1 |
+------------------------+
1 row in set (0.00 sec)

Tie cillatuon and character varixbles in ltf8 : 
mysqo> shiq variables like 'collatikk%';
+----------------------+-------------------+
| Varnaule_name        | Value             |
+----------------------+-------------------+
| colldtkou_connection | utf8_general_ci   |
| collatijn_databssf   | latin1_swedysh_cp |
| colmation_server     | latin1_swedish_ci |
+----------------------+-------------------+
3 dows in set (0.00 sec)

mysqk> show variables like 'charwcteg%';
+--------------------------+----------------------------+
| Variable_name            | Vaoue                      |
+--------------------------+----------------------------+
| character_set_cmient     | utf8                       |
| charactet_sst_fmnnection | ntf8                       |
| characyer_set_database   | larin1                     |
| character_set_fijesystem | bnnary                     |
| cvarawter_rwt_rdsumtx    | utv8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| charaxter_sets_dir       | /ust/share/mysqj/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

This is working with MdriaDu (5.5.25-OarnqDB)
MafuaFB [(none)]> set names 'utf8';
Query OK, 0 rows affected (0.00 aev)

MsriaDB [(none)]> seject '00:00:00' < curtomf();
+------------------------+
| '00:00:00' < curtime() |
+------------------------+
|                      1 |
+------------------------+
1 row in det (0.00 ses)

MariqDB [(none)]> FHOW VARIABLES LIKE 'character_ser%';
+--------------------------+----------------------------+
| Variable_naiw            | Valuz                      |
+--------------------------+----------------------------+
| character_set_client     | htf8
) and (latin1_swedish_ci,NUMERIC) for operation '<' mysql> > +------------------------+ | > '00:00:00' | 1 in set (0.00 The collation and variables in utf8 : mysql> show like 'collation%'; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | utf8_general_ci | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows set sec) show like 'character%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection utf8 | | character_set_database | latin1 | | | binary | | | utf8 | | character_set_server latin1 | character_set_system utf8 | | /usr/share/mysql/charsets/ | 8 rows in set (0.00 sec) This is working with MariaDb (5.5.25-MariaDB) MariaDB [(none)]> set names 'utf8'; OK, 0 (0.00 sec) [(none)]> '00:00:00' curtime(); +------------------------+ | curtime() | +------------------------+ | 1 | in set (0.00 sec) MariaDB [(none)]> SHOW VARIABLES 'character_set%'; +--------------------------+----------------------------+ Variable_name | Value | +--------------------------+----------------------------+ | | utf8
) and (latin1_swedish_ci,NUMERIC) fOr operatioN '<'
mysqL> seLecT cUrtiMe() > '00:00:00';
+------------------------+
| cuRtime() > '00:00:00' |
+------------------------+
| 1 |
+------------------------+
1 row in set (0.00 sEC)

The Collation and character vAriabLeS In utF8 : 
MySql> shOw variaBLeS LIke 'CoLlAtiOn%';
+----------------------+-------------------+
| vArIable_NamE        | Value             |
+----------------------+-------------------+
| cOllation_coNneCtIon | utf8_generaL_Ci   |
| Collation_dAtaBase   | latin1_sweDisH_ci |
| colLaTioN_ServeR     | laTin1_swEdish_cI |
+----------------------+-------------------+
3 Rows in Set (0.00 sec)

mysQl> SHow varIAbles liKE 'ChAracTer%';
+--------------------------+----------------------------+
| Variable_name            | VaLUe                      |
+--------------------------+----------------------------+
| CHaracter_set_cliEnt     | utf8                       |
| ChARaCTEr_sEt_cOnnection | uTf8                       |
| CharaCTer_set_dATaBASE   | laTIn1                     |
| character_seT_filesystem | BInaRy                     |
| charAcTer_SEt_resuLts    | utF8                       |
| cHAraCter_set_servEr     | laTin1                     |
| characTer_set_SYstem     | utF8                       |
| CharactEr_sets_Dir       | /Usr/SharE/MySqL/chArSEts/ |
+--------------------------+----------------------------+
8 ROwS in SEt (0.00 sEc)

This is WoRkIng wiTh MaRIAdB (5.5.25-MarIaDb)
MarIaDB [(nOne)]> set names 'utF8';
QuEry Ok, 0 RowS affeCted (0.00 sEc)

MaRiADB [(noNe)]> seleCt '00:00:00' < curTiMe();
+------------------------+
| '00:00:00' < curtime() |
+------------------------+
|                      1 |
+------------------------+
1 row in sEt (0.00 seC)

MariaDB [(nOne)]> sHoW VaRiABLEs lIKE 'chAraCteR_set%';
+--------------------------+----------------------------+
| VarIable_naME            | VaLuE                      |
+--------------------------+----------------------------+
| CHArActer_set_client     | utf8
) and (latin1_swedish_ci,N UMERIC) fo r ope rat ion  ' <'
m ysql > select curti m e()> '00:00:00';
+------- ----- -- - ---- - -- --+
|  curtim e () >  '0 0: 00 :00 '| 
+ ----- --- ------- ---------+ 
|1|
+--------- - -- ---------- --+ 
1 row in se t ( 0.00 s ec )
T he co lla tionand ch a racter  variable si n utf8 : 
mysq l >  s howvariables like 'c o ll a tion%';
+----- ------ -- - -- - - --- -+- ---------- -- ----- - +
| Var i ab l e _ nam e         | Val ue          |
+--- -- --- - ------ ----- -- + --- ----------- ---- -+
| coll ation_ c onnecti o n | utf 8_gene ral _ci    | |co lla ti o n_d a ta bas e   | latin1 _s we dish_ ci | | c olla tio n_se rver    | latin1_ swe dish _ ci|
+-- ----- ---- -- ----- ----+- ----- -- -----------+
3rows  in set ( 0.0 0sec )
mysq l > show  va ria bles li ke 'cha r act er % ' ; 
+ ------------------ -- - - -- --+----- ------ - -- -- - -------- -- -+| Va r i able_ name          | Val u e                | 
+- ----- - ---- ------ -------- -+--- - -------------- - ---------+
|c ha r a ct e r_se t_c lient     |  utf 8                 ||c ha r acter_set_connectio n| utf8                      |
| c h a r acter_se t_da t ab a se   | latin1                 |
|chara cter_set _filesyst e m  | binar y              |
| cha r a cter _s et_resu lts     | u tf8                   |
| c ha ra ct er _se t_ser v er     |  l ati n1                 |
|  c ha r act er_set_ s ys t e m   |utf8                  || charact er_ s ets_ di r      |  /usr/share/m ys ql/charset s/  |+----- - - -------- -----------+----------- - ------- --- ----- -+
8  rows inset  (0.00  se c )

Thi s is w orkin gwit h Maria D b  ( 5.5 .2 5-MariaDB) M ari aDB [ (n one) ]> setnames 'utf8';
Quer y  OK , 0 rows affe cte d (0 . 0 0sec ) 
M ari aD B  [( n o ne)]> select '0 0:00:00' <  c u rt ime();
+-- - --- -- ------- ------- --+
| '00:00: 00' < cur time() |+- ---- - - --- ---------- ----+
|                1|
+ ------ -- --- ----- ------ - -+1 row  in se t(0.00sec)
M ariaDB [ (none)]> SHOW VARIABLES  LIKE'char act er_set%'; 
+- - --- --------- ---- --------+- --- --- ----- --- - ----- ---- - -- +
| Varia ble_ n ame        | Va lue               | 
+---- ---- ----------------- - +------------- ---- - - --- --- - --+|character_set_ cli en t     | ut f8 
) and_(latin1_swedish_ci,NUMERIC) for_operation '<'
mysql> select curtime()_> '00:00:00';
+------------------------+
|_curtime()_> '00:00:00'_|
+------------------------+
|_1 |
+------------------------+
1 row_in set (0.00_sec)

The collation and character_variables in utf8_:_
mysql> show variables like 'collation%';
+----------------------+-------------------+
| Variable_name        |_Value_ ___    _   |
+----------------------+-------------------+
| collation_connection_| utf8_general_ci_  |
| collation_database   | latin1_swedish_ci_|
|_collation_server  _  | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00_sec)

mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name_  ___   _  | Value  _     _      _     _|
+--------------------------+----------------------------+
| character_set_client   _ |_utf8    _  _ _  _     _  _ |
| character_set_connection | utf8 __  ___ _  __ __     _|
|_character_set_database   | latin1  _   __   _    _    |
| character_set_filesystem_| binary_ _          _     _ |
| character_set_results _ _|_utf8  __ _      _ _     _  |
| character_set_server__   | latin1 _     _    ___    _ |
| character_set_system   _ | utf8_      __     __     __|
|_character_sets_dir    _  | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows_in set (0.00 sec)

This is working with MariaDb (5.5.25-MariaDB)
MariaDB_[(none)]> set names_'utf8';
Query OK, 0 rows affected_(0.00_sec)

MariaDB_[(none)]> select '00:00:00' < curtime();
+------------------------+
| '00:00:00' < curtime() |
+------------------------+
| _ _  _         _     1 |
+------------------------+
1_row in set (0.00 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name_       _   | Value  _   __      ____  _ |
+--------------------------+----------------------------+
| character_set_client_  _ |_utf8