MYSQL找不到字段？

Question

mysql> SELECT * FROM LSB;
+------+------+------------+------+------+------+
| 单号 | 品名 | 供货商编号 | 颜色 | 规格 | 单位 |
+------+------+------------+------+------+------+
| 001  | CP   |            |      |      |      |
+------+------+------------+------+------+------+
1 row in set (0.00 sec)mysql> SELECT 单号, 品名, 供货商编号, 颜色, 规格, 单位 FROM 入库单表;
+------+------+------------+------+------+------+
| 单号 | 品名 | 供货商编号 | 颜色 | 规格 | 单位 |
+------+------+------------+------+------+------+
| 001  | CP   |            |      |      |      |
+------+------+------------+------+------+------+
1 row in set (0.00 sec)mysql> SELECT 入库单表.单号 FROM 入库单表 WHERE 入库单表.单号 = LSB.单号;
ERROR 1054 (42S22): Unknown column 'LSB.鍗曞彿' in 'where clause'

Answer 1

SELECT 入库单表.单号 FROM 入库单表 inner join LSB on 入库单表.单号 = LSB.单号;

Answer 2

字符集设置的问题。set names gbk;set name latin1;几种都试试。

Answer 3

set nams gbk;
select ...

Answer 4

回复3、4楼：
不好使。另外我在配置MYSQL的时候已经配置了 GB2312 了

Answer 5

show create table LSB;
show create table 入库单表;

Answer 6

mysql> show create table LSB;
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
-----+
| Table | Create Table     |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
-----+
| LSB   | CREATE TABLE `lsb` (
  `单号` text,
  `品名` text,
  `供货商编号` text,
  `颜色` text,
  `规格` text,
  `单位` text
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
-----+
1 row in set (0.00 sec)
mysql> show create table 入库单表;
+----------+--------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------+
| Table    | Create Table
                                                            |
+----------+--------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------+
| 入库单表 | CREATE TABLE `入库单表` (
  `单号` text,
  `入库日期` datetime DEFAULT NULL,
  `品名` text,
  `供货商编号` text,
  `颜色` text,
  `规格` text,
  `数量` int(11) DEFAULT NULL,
  `单位` text,
  `单价` double DEFAULT NULL,
  `金额` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 |
+----------+--------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------+
1 row in set (0.00 sec)

Answer 7

SELECT 入库单表.单号 FROM 入库单表 inner join LSB on 入库单表.单号 = LSB.单号;SELECT 入库单表.单号 FROM 入库单表 ,LSB ;
什么结果

Answer 8

mysql> SELECT 入库单表.单号 FROM 入库单表 ,LSB ;
+------+
| 单号 |
+------+
| 001  |
+------+
1 row in set (0.00 sec)

Answer 9

SELECT * FROM 入库单表 inner join LSB on 入库单表.单号 = LSB.单号;SELECT * FROM 入库单表 ,LSB ;
什么结果

Answer 10

按下面方法贴出你的检查结果。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码