给个例子 mysql> create table aa -> (name1 varchar(8) binary, -> name2 varchar(8)); Query OK, 0 rows affected (0.00 sec)mysql> insert into aa values('Mm','Nn'); Query OK, 1 row affected (0.00 sec)mysql> select * from aa; +-------+-------+ | name1 | name2 | +-------+-------+ | Mm | Nn | +-------+-------+ 1 row in set (0.00 sec)mysql> select * from aa where name2='nn'; +-------+-------+ | name1 | name2 | +-------+-------+ | Mm | Nn | +-------+-------+ 1 row in set (0.00 sec)mysql> select * from aa where name1='mm'; Empty set (0.00 sec)mysql> select * from aa where name1='Mm'; +-------+-------+ | name1 | name2 | +-------+-------+ | Mm | Nn | +-------+-------+ 1 row in set (0.00 sec)
varchar2(50)->varchar2(50)
binary->char(1) (因为ORACLE中字段没有布尔型的)
binary如何替代需要仔细考虑了
MySQL也没有varchar2,应该是varchar所以应该是 varchar(5) binary 改成 oracle的varchar2(50) 即可
mysql> create table aa
-> (name1 varchar(8) binary,
-> name2 varchar(8));
Query OK, 0 rows affected (0.00 sec)mysql> insert into aa values('Mm','Nn');
Query OK, 1 row affected (0.00 sec)mysql> select * from aa;
+-------+-------+
| name1 | name2 |
+-------+-------+
| Mm | Nn |
+-------+-------+
1 row in set (0.00 sec)mysql> select * from aa where name2='nn';
+-------+-------+
| name1 | name2 |
+-------+-------+
| Mm | Nn |
+-------+-------+
1 row in set (0.00 sec)mysql> select * from aa where name1='mm';
Empty set (0.00 sec)mysql> select * from aa where name1='Mm';
+-------+-------+
| name1 | name2 |
+-------+-------+
| Mm | Nn |
+-------+-------+
1 row in set (0.00 sec)
所以MySQL用binary来设定字段值区分大小写
CREATE TABLE phpbb_search_wordlist (
word_text varchar2(50) binary NOT NULL default '',
word_id number(8) NOT NULL ,
word_common number(1) default '0' NOT NULL,
PRIMARY KEY (word_text),
KEY word_id (word_id)
) TYPE=MyISAM =13 ;
我从mysql导出来的数据是这样的
INSERT INTO phpbb_search_wordlist VALUES (0x6578616d706c65, 1, 0);
INSERT INTO phpbb_search_wordlist VALUES (0x706f7374, 2, 0);
要把这个word_text字段的数据导入oracle的这样一个表中该字段要定义成什么类型!???
long raw
把字段定义成这种类型数据根本插不进去的啊 !没用哦!
INSERT INTO phpbb_search_wordlist VALUES (0x6578616d706c65, 1, 0);
INSERT INTO phpbb_search_wordlist VALUES (0x706f7374, 2, 0);
要把这个word_text字段的数据导入oracle的这样一个表中该字段要定义成什么类型!???那怎么把这个导出来的数据导到oracle表里呢!