暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle/PLSQL: Convert 函数

原创 Anbob 2011-06-20
1036
Oracle/PLSQL, the convert function converts a string from one character set to another.
The syntax of the convert function is:
convert( string1 , char_set_to , [ char_set_from ] )
string1 is the string to be converted.
char_set_to is the character set to convert to.
char_set_from is the character set to convert from.
Character sets include:
 































US7ASCIIUS 7-bit ASCII character set
WE8DECWest European 8-bit character set
WE8HPHP West European Laserjet 8-bit character set
F7DECDEC French 7-bit character set
WE8EBCDIC500IBM West European EBCDIC Code Page 500
WE8PC850IBM PC Code Page 850
WE8ISO8859P1ISO 8859-1 West European 8-bit character set

Applies To:
Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
是把一个字符串从一个字符集转为另一个字符集显示,返回varchar2
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论