跪求：当insert,update 含有特殊字符的时候，编码不对。

Question

当运行这个：
update pi_portal_mission set MS_HOM_NAME ='Jörg Ranau' where MS_PRIMS_MISSID='M016';
update pi_portal_fmstaff set FM_STAFF_NAME ='Sigute Jakštonyte' where FM_MISS_ID =176 and FM_STAFF_ID =1;发现结果不对，编码是乱码。 
select 结果发现：
MS_HOM_NAME                                                                     
--------------------------------------------------------------------------------
Jörg Ranau   FM_STAFF_NAME                                                                   
--------------------------------------------------------------------------------
Sigutė JakÅ¡tonytė   采用的数据参数：
PARAMETER                                                        VALUE---------------------------------------------------------------- ----------------------------------------------------------------NLS_LANGUAGE                                                     AMERICANNLS_TERRITORY                                                    AMERICANLS_CURRENCY                                                     $NLS_ISO_CURRENCY                                                 AMERICANLS_NUMERIC_CHARACTERS                                           .,NLS_CALENDAR                                                     GREGORIANNLS_DATE_FORMAT                                                  DD-MM-RRRRNLS_DATE_LANGUAGE                                                AMERICANNLS_CHARACTERSET                                                 UTF8NLS_SORT                                                         BINARYNLS_TIME_FORMAT                                                  HH.MI.SSXFF AM PARAMETER                                                        VALUE---------------------------------------------------------------- ----------------------------------------------------------------NLS_TIMESTAMP_FORMAT                                             DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT                                               HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT                                          DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY                                                $NLS_NCHAR_CHARACTERSET                                           UTF8NLS_COMP                                                         BINARYNLS_LENGTH_SEMANTICS                                             BYTENLS_NCHAR_CONV_EXCP                                              FALSE 

Answer 1

谢谢楼上2位。也的确是字符不能识别的问题。1: 当在运行CMD SQLPLUS 之前，先SET NLS_LANG=AMERICAN_AMERICA.UTF8
2：当调用运行的SQL之前，最好将文件保存在TXT， 然后转换格式成： UTF8 WITHOUT BOM之前我都试第一种，发现还是不可以，重要是第2步，运行的语句也要是： UTF8 。
字符码才一致，才能认到。