You should use "binary" attribute.
mysql> select binary "fff " = "fff" ;
+-------------------------+
| binary "fff " = "fff" |
+-------------------------+
| 0 |
+-------------------------+
1 row in set (0.28 sec)
mysql> select "fff " = "fff" ;
+------------------+
| "fff " = "fff" |
+------------------+
| 1 |
+------------------+
1 row in set (0.00 sec)
mysql> select version() ;
+-----------+
| version() |
+-----------+
| 3.23.46 |
+-----------+
1 row in set (0.00 sec)
when you create table...
create table table_name ( a char(10) binary ... ) ;
you can check white characters.
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
