oracle / character set us7ascii / japanese language

[juncheol lee]

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]

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.

--

http://executequery.org

[juncheol lee]

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]

just to be clear ... are you saying the result set table is wrong?

can you take a screenshot of the table.

thanks

[juncheol lee]

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

[Fredrik Safstrom]

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