"\u5176\u4ED6\"这种信息怎么转化出来?

ilovemk

public class TEST{
  public static void main(String args[]){
    System.out.println("\u5176\u4ED6\u672A\u8BF4\u660E\u539F\u56E0");
  }
}

fenglhua

呵呵,非常感谢!

snowy_howe

呃,这个?
UNISTR takes as its argument a string and returns it in the national character set.The national character set of the database can be either AL16UTF16 or UTF8. UNISTR provides support for Unicode string literals by letting you specify the Unicode encoding value of characters in the string. This is useful, for example, for inserting data into NCHAR columns.

The Unicode encoding value has the form '\xxxx' where 'xxxx' is the hexadecimal value of a character in UCS-2 encoding format. To include the backslash in the string itself, precede it with another backslash (\\).

For portability and data preservation, Oracle Corporation recommends that in the UNISTR string argument you specify only ASCII characters and the Unicode encoding values.

ilovemk

原帖由 snowy_howe 于 2007-12-1 16:28 发表
呃,这个?
UNISTR takes as its argument a string and returns it in the national character set.The national character set of the database can be either AL16UTF16 or UTF8. UNISTR provides support fo ...

谢谢提醒
SQL> select unistr(replace('\u5176\u4ED6\u672A\u8BF4\u660E\u539F\u56E0','u',''))
str from dual;

STR
--------------
其他未说明原因

nokilled

原帖由 ilovemk 于 2007-12-1 17:38 发表

谢谢提醒
SQL> select unistr(replace('\u5176\u4ED6\u672A\u8BF4\u660E\u539F\u56E0','u',''))
str from dual;

STR
--------------
其他未说明原因

windows下可以 unix下却不行 不知道又没有合适的解决方式

lastwinner

楼上的，windows下oracle 9201可以运行