SQL statement to store and retrieve 2byte letters like Japanese characters

[vbie]

How do I store and retrieve 2byte letter like Japanese character in Oracle SQL?

What are the SQL statements?

Hope you can help me.

vbie

[debasisdas]

you need to change NLS_CHARACTERSET.

[vbie]

well how do I do that pls?

[vbie]

you need to change NLS_CHARACTERSET.

well, how do I do that pls?

[amitpatel66]

well, how do I do that pls?

You can try using CONVERT function for converting one chracter set to another.
Check CONVERT FUNCTION

[vbie]

Thank you.

I have, for example, an oracle table with the ff. data structure:

Column Data Type
-----------------------------------------
Code VARCHAR2
Desc VARCHAR2

Now, I inputted data as follows:

Code Desc
------------------------------------------
01 Common
02 ?-?¿?3?¿ --> *Note
03 General

*Note: These characters were originally typed as japanese characters, but when saved they looked that way.

So then, in applying your suggestion of CONVERT function, I tried this:

SELECT CONVERT( DESC, 'US7ASCII', 'JA16SJIS') FROM SAMPLE

*JAI6SJIS is the character set for Japanese.

However, the result is this:

Code Desc
----------------------------------------
01 Common
02 ?-???3??
03 General


I hope you can help me further.



vbie

[vbie]

What is JA16SJIS ?

That represents which chracterset ?

Good afternoon.

I was researching about your suggestion to change the NLS_CHARACTERSET and to determine what my database has, I issued this command:

SELECT * from NLS_DATABASE_PARAMETERS
where PARAMETER in ( 'NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET' )

And I got this result:

Parameter Value
--------------------------------------------------------------------------------
NLS_CHARACTERSET JA16SJIS
NLS_NCHAR_CHARACTERSET AL16UTF16


But I don't know how to make a correct SQL command applying your suggestion, so I researched some more and found lots of info about encoding sets, etc..

Then I tried the CONVERT function suggested by the other moderator and tried to combine your suggestion with his.

I still can't save or retrieve a japanese character like kanji or hiragana into our system using SQL.


vbie

[vbie]

You can try using CONVERT function for converting one chracter set to another.
Check CONVERT FUNCTION

Thank you Sir/Ma'am for giving some ideas.

[debasisdas]

well, how do I do that pls?

try to do this

STARTUP MOUNT exclusive RESTRICT
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN ;
update props$
set value$='UTF8'
where name in ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
commit;
SHUTDOWN IMMEDIATE;