mysql \r问题

推荐一些不错的电子书：[url]http://www.memeshu.com[/url]
mysql 数据库不能输入 \r
例如：
insert into t_book_note (note_content) values ('a\r');

mysql> select * from t_book_note where id=8;
+----+---------+---------+----+-----------+--------------+--------+---------------------+--------+------------+-----------+
| id | book_id | user_id | pg | user_name | note_content | useful | intime | status | read_level | note_type |
+----+---------+---------+----+-----------+--------------+--------+---------------------+--------+------------+-----------+
| 0 | 2010-01-14 15:58:08 | 1 | 1 | 1 |
+----+---------+---------+----+-----------+--------------+--------+---------------------+--------+------------+-----------+
1 row in set (0.00 sec)

mysql> select note_content from t_book_note where id=8;
+--------------+
| note_content |
+--------------+
|
+--------------+


要对\r替换

例如在做web开发时

有可能犯得错误
note=note.replace("\n", "<br/>");
note=note.replace("\r\n", "<br/>");


一定要
note=note.replace("\r\n", "<br/>");
note=note.replace("\n", "<br/>");

顺序差了，结果可差很多