Geek asks and answers

Oracle character encoding

I have MVIEW on a DEV server like

CREATE MATERIALIZED VIEW MY_MVIEW
AS
SELECT  col1 AS "N° INVOICE" from TABLE

MVIEW was installed on the PROD server, and when I check its request, I have an °unrecognized character

SELECT query from user_mviews where mview_name = 'MY_MVIEW' ;

QUERY
---------------------------------------
SELECT  col1 AS "N? INVOICE" from TABLE

use Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production for both environments.

Any idea why this happened and how to fix it? or do I need to rename my nickname?

+3
source share
2 answers

Whenever you see a question mark instead of a special character, this means that the client’s character set does not support that character, and the conversion was not available.

, , , . NLS_LANG . NLS_LANG .

NLS_LANG . Oracle®

BTW, NLS_LANGUAGE ! , .

+5

, NO_INVOICE, - . , - . , NLS_LANG.

+4

More articles:


All Articles