如何在 oracle 11g 中插入印度卢比符号?

2021-12-30 00:00:00 oracle11g insert oracle

我想在 oracle 11g 中插入印度卢比符号.

我试过了:

插入货币(名称,符号)值('卢比',unistr('20B9'));

但它不起作用.

SELECT ascii('₹') FROM dual; 它给出了卢比符号的 ascii 值,但插入后它会在行中显示框.

在这里你可以看到

SELECT chr(14844601) FROM dual;

解决方案

似乎只需要在 SQL Developer 中更改字体即可.检查使用 oracle.jdbc.convertNcharLiterals 属性开启相同的行为,该属性作用于系统和连接级别.
要打开此属性,请在 SQL Developer 安装文件夹的 sqldeveloperidein 目录中找到 ide.conf 文件,并将此行添加到文件末尾:

AddVMOption -Doracle.jdbc.convertNcharLiterals=true

保存文件并重新启动 SQL Developer,现在一切都必须正常工作:

附言说明基于SQL Developer Version 3.2,旧版本可能有其他配置文件位置.例如.sqldeveloperinsqldeveloper.conf .

I want to insert Indian Rupee symbol in oracle 11g.

I have tried:

insert into currency(name, symbol) values ('rupee', unistr('20B9'));

but its not working.

SELECT ascii('₹') FROM dual; it gives ascii value for Rupee symbol but after insert it shows box in the row.

here you can see

SELECT chr(14844601) FROM dual;

解决方案

Seems that you just need to change a font in SQL Developer. Check this SQLFiddle.

There are two things wrong in your question text: to get unicode symbol from it's code nchr() function must be used instead of chr(). Second is that '₹' constant string treated as varchar2 and to properly specify nvarchar2 constant you must prepend N to this literal: N'₹' .

To change font just open Tools -> Preferences ... menu

and choose Code Editor -> Fonts node. At this page you can select font from Font Name dropdown list. Copy and past rupee symbol into Sample Text field to quickly see if font are acceptable. Arial (on win7) works fine for me:

This setting changes grid font as well as font in code editor:

Actions above puts you only to a half of the way to get full rupee symbol support because select N'₹' from dual will return only question sign. This is because of query text encoding conversion done between client and server side.
To deal with this issue Oracle provides ORA_NCHAR_LITERAL_REPLACE environment setting. This setting guides client API to analyze query text for character constants prefixed with N and use special internal format to encode such a data on client side before transferring query text to server. Unfortunately SQL Developer uses Thin JDBC API which ignores this environment setting, so adding this environment variable doesn't solve a problem.

But there are another way to turn on same behavior with oracle.jdbc.convertNcharLiterals property which acts on a system and connection levels.
To turn this property on, locate ide.conf file in sqldeveloperidein directory in SQL Developer installation folder and add this line to the end of a file:

AddVMOption -Doracle.jdbc.convertNcharLiterals=true

Save file and restart SQL Developer, all things must work now:

P.S. Instructions based on SQL Developer Version 3.2, old versions may have another location of configuration file. E.g. sqldeveloperinsqldeveloper.conf .

相关文章