SQL Developer特殊字符 [英] SQL Developer Special Chars

问题描述

我在使用Oracle数据库和ASCII char编码时遇到问题.

I am having problems with an Oracle Database and the ASCII char encoding.

我正在尝试使用包含特殊字符(如á，é，í，ó，ú，(西班牙语)等)的字符串在Varchar2()列上进行更新语句.

I'm trying to make Update sentences on Varchar2() columns with strings that contains special characters like á, é, í, ó, ú, (spanish) etc.

例如，每次我从该列中恢复数据时，我都会看到髇"或髇"而不是ó".

Each time i recover the data from that column, as for example, instead of seeing 'ó', i got '髇' or '髇'.

我正在写更新句子，例如:

I'm writing Update sentences like:

UPDATE TABLE_1
SET DESCRIPTION = 'THIS IS A TEXT WITH SPECIAL CHAR ó ÉND'
WHERE ID = '1';

当我这样做时:

SELECT ID ||' | '|| DESCRIPTION FROM TABLE_1 WHERE ID = '1';'

我得到了:

1 | THIS IS A TEXT WITH SPECIAL CHAR 髇 END

我正在使用SQL Developer 4.0.3版

I'm using SQL Developer Version 4.0.3

谢谢您的帮助.

推荐答案

您必须在注册时检查Nlslang和数据库字符集，看来它们是不同的.

You have to check the Nlslang in you registery and the database characterset, it seems they are different.

示例:

SELECT * FROM v$nls_parameters WHERE parameter LIKE 'NLS_CHARACTERSET'
/

PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET                                                 AL32UTF8

从registery转到oracle registery，并在nlslang中添加值American_America.Al32UTF8(作为示例)，类似于您在数据库中拥有的值.

from the registery go to oracle registery and in nlslang add value American_America.Al32UTF8(as an example) similar what you have in the database.

通过某种方式，也可以从控制面板中的语言发出问题，如果要使用法语字符，最好将其分配为法语. (控制面板\时钟，语言和区域...，然后在管理标签中)

By the way sometime also the issue its from the langauge in the control panel , if you want to use french characters is better to assign it french. (Control Panel\Clock, Language, and Region... then in administrative tab)

这篇关于SQL Developer特殊字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！