PB乱码
CREATE VIEW dbo.V_Iteminfor
AS
SELECT No_ AS itemno, [Product cycle] AS product_cycle, [BOM Rate] AS bom_rate,
(CASE [PD1 product type] WHEN '1' THEN N'GP铂扩' WHEN '2' THEN N'GP非铂扩' WHEN
'3' THEN N'3"ASCUT FR' WHEN '4' THEN N'3"ASCUT STD' WHEN
'5' THEN N'3"ASCUT浅扩散 ' WHEN '6' THEN N'3"ASCUT深扩散 ' WHEN '7' THEN
N'3"GPP - TVS' WHEN '8' THEN N'3"SIPOS FR' WHEN '9' THEN N'3"SIPOS STD'
WHEN '10' THEN N'4"ASCUT STD' WHEN '11' THEN N'4"ASCUT浅扩散' WHEN '12'
THEN N'4"GPP - EPI' WHEN '13' THEN N'4"GPP - TVS' WHEN '14' THEN N'4"SIPOS STD'
WHEN '15' THEN N'GPP - EPI' END) AS pd_type
FROM dbo.[Gulf Semi(V080601)$item]
WHERE ([Item Category Code] <> '
LC - TOOL ') AND
([Item Category Code] NOT LIKE ' MH % ')
转换后是正确的,但是PB读出来中文是乱码
string ls_pdtype
select pd_type into :ls_pdtype from V_Iteminfor where itemno = :ls_itemno;
this.object.pd1type[row] = ls_pdtype
报个messagebox,ls_pdtype的GP铂扩显示GP??