1094: * is different between client and server (e.g. UTF-8 to SJIS).
1095: */
1096:
1097: /*
1098: * utl_raw.convert only takes a qualified NLS_LANG value in
1099: *
1100: * source charset parameters. Need to use l_client_nls_lang
1101: * and g_db_nls_lang here.
1102: */
1099: *
1100: * source charset parameters. Need to use l_client_nls_lang
1101: * and g_db_nls_lang here.
1102: */
1103: l_str := utl_raw.convert(utl_raw.cast_to_raw(l_onechar),
1104: l_client_nls_lang,
1105: g_db_nls_lang);
1106: l_byte_len := length(l_str);
1107: if l_byte_len = 2 then
1173: i integer := 1;
1174: begin
1175: /*
1176: * Set a source charset for code conversion.
1177: * utl_raw.convert() only accepts
1179: * 'AMERICAN_AMERICA' string if a give charset dose not have
1180: *
1181: */
1210: /*
1211: * convert a raw data from the source charset to the database charset,
1212: * then cast it to a varchar2 string.
1213: */
1214: return utl_raw.cast_to_varchar2(
1215: utl_raw.convert(l_raw, g_db_nls_lang, l_client_nls_lang));
1216: end decode;
1217:
1218:
1211: * convert a raw data from the source charset to the database charset,
1212: * then cast it to a varchar2 string.
1213: */
1214: return utl_raw.cast_to_varchar2(
1215: utl_raw.convert(l_raw, g_db_nls_lang, l_client_nls_lang));
1216: end decode;
1217:
1218:
1219: Procedure Retrieve_Org_Where_Clause