SQL文如下:
SELECT RM_CD, KANJI_FULL_NAME_KNJ
FROM V_SYSTM_CSRM_ASOF
WHERE FUNCTION_CODE_DESC_ENG='MKT'
AND BUSSINES_SEGMENT_GRP_CD BETWEEN '1' AND '4'
ORDER BY RM_CD ASCV_SYSTM_CSRM_ASOF表如下:
ASOFDATE DATE
RECORD_SEQ_NO CHAR(3)
RM_CD CHAR(3)
FUNCTION_CD CHAR(3)
FUNCTION_CODE_DESC_ENG CHAR(3)
BUSSINES_SEGMENT_GRP_CD CHAR(3)
BUSINESS_SEGMENT_GRP_DESC_ENG CHAR(3)
BUSINESS_SEGMENT_UNIT_CD CHAR(3)
BUSINESS_SEGMENT_UNIT_DESC_ENG CHAR(3)
AP_CD CHAR(3)
AP_DESC_ENG CHAR(3)
BRANCH_CD CHAR(3)
SHORT_NAME_ENG VARCHAR2(40)
SHORT_NAME_KNJ VARCHAR2(40)
FULL_NAME VARCHAR2(40)
FAMILY_NAME VARCHAR2(40)
KANJI_FULL_NAME_KNJ VARCHAR2(40)
KANJI_FAMILY_NAME_KNJ VARCHAR2(40)
TEL_NO VARCHAR2(20)
FAX_NO VARCHAR2(20)这个V_SYSTM_CSRM_ASOF表建在另一个instance中,使用db link连接使用。
SELECT RM_CD, KANJI_FULL_NAME_KNJ
FROM V_SYSTM_CSRM_ASOF
WHERE FUNCTION_CODE_DESC_ENG='MKT'
AND BUSSINES_SEGMENT_GRP_CD BETWEEN '1' AND '4'
ORDER BY RM_CD ASCV_SYSTM_CSRM_ASOF表如下:
ASOFDATE DATE
RECORD_SEQ_NO CHAR(3)
RM_CD CHAR(3)
FUNCTION_CD CHAR(3)
FUNCTION_CODE_DESC_ENG CHAR(3)
BUSSINES_SEGMENT_GRP_CD CHAR(3)
BUSINESS_SEGMENT_GRP_DESC_ENG CHAR(3)
BUSINESS_SEGMENT_UNIT_CD CHAR(3)
BUSINESS_SEGMENT_UNIT_DESC_ENG CHAR(3)
AP_CD CHAR(3)
AP_DESC_ENG CHAR(3)
BRANCH_CD CHAR(3)
SHORT_NAME_ENG VARCHAR2(40)
SHORT_NAME_KNJ VARCHAR2(40)
FULL_NAME VARCHAR2(40)
FAMILY_NAME VARCHAR2(40)
KANJI_FULL_NAME_KNJ VARCHAR2(40)
KANJI_FAMILY_NAME_KNJ VARCHAR2(40)
TEL_NO VARCHAR2(20)
FAX_NO VARCHAR2(20)这个V_SYSTM_CSRM_ASOF表建在另一个instance中,使用db link连接使用。
我是在一个application中做的,在开发环境中没出现过这个问题,交给客户的时候就有这个问题了。
Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing.
OS: Solaris 8
1、检查一下你出问题的客户端nls_lang的设置和你开发环境上的有没有不同,因为你说开发环境上没有问题;
2、将数据库升级到9.2.0.4
客户的实际运行环境中nca是utf-8,icr是shift_jis请问各位在不改变字符集编码的基础上如何解决这个问题呀?多谢多谢!
SELECT KANJI_FULL_NAME_KNJ
FROM V_SYSTM_CSRM_ASOF
WHERE FUNCTION_CODE_DESC_ENG='MKT'
AND BUSSINES_SEGMENT_GRP_CD BETWEEN '1' AND '4'
;执行一下看看有没有问题
SELECT KANJI_FULL_NAME_KNJ
FROM V_SYSTM_CSRM_ASOF
WHERE ROWNUM<10;
谢谢aweihz