oracle / character set us7ascii / japanese language

49 views
Skip to first unread message

juncheol lee

unread,
Jun 24, 2016, 6:53:34 AM6/24/16
to Execute Query
oracle version :11.2.0.4
NLS_CHARACTERSET : US7ASCII
jdbc library : ojdbc6.jar
execute query version : 5456

Language: Japanese

In the edit select, update is done properly.
However, garbled characters appear in the result set.

sample>

update tmpjclee set id = '日本語'
where id = '日本語';
-> Ok

select id from tmpjclee where id = '日本語';
?? Ú ?? {?? ê
-> Incorrectly

If you modify any of that would come execute query possible?

Takis Diakoumis

unread,
Jun 24, 2016, 9:02:54 AM6/24/16
to execut...@googlegroups.com
hello

thanks for reporting this. EQ isn't doing anything with input queries and values...
but, i'll have a play and get back to you asap. 

thanks again
Takis


--
You received this message because you are subscribed to the Google Groups "Execute Query" group.
To unsubscribe from this group and stop receiving emails from it, send an email to executequery...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

juncheol lee

unread,
Jun 28, 2016, 1:41:16 AM6/28/16
to Execute Query
Is there something you found ?
Please let me know if I think something this section.

Thank attention.

2016년 6월 24일 금요일 오후 10시 2분 54초 UTC+9, Takis Diakoumis 님의 말:

Takis Diakoumis

unread,
Jun 28, 2016, 1:56:08 AM6/28/16
to execut...@googlegroups.com
just to be clear ... are you saying the result set table is wrong?

can you take a screenshot of the table.

thanks

juncheol lee

unread,
Jun 28, 2016, 5:27:09 AM6/28/16
to Execute Query



2016년 6월 28일 화요일 오후 2시 56분 8초 UTC+9, Takis Diakoumis 님의 말:

Fredrik Safstrom

unread,
Jun 28, 2016, 1:44:05 PM6/28/16
to execut...@googlegroups.com
Howdy...

Looks like a setup problem to me...

Try the following,
select * from nls_database_parameters;                                 
The three parameters that matters are these,
NLS_CHARACTERSET       AL32UTF8                                        
NLS_LENGTH_SEMANTICS       CHAR                                        
NLS_NCHAR_CHARACTERSET       AL16UTF16                                 

These need to be able to hold a Japanese Character set.
If you are using US7ASCII you might not even store all 8bits, so even if the driver tries to convert to and from Japanese, it cannot.

I'm not an Oracle expert but I know these settings need to be set when creating the database.
Some of these parameters can be changed after the database is created but tables are not converted automatically.
So all tables that were already created will retain their old settings.

/Fredrik
Reply all
Reply to author
Forward
0 new messages