Skip to Main Content
  • Questions
  • Database server of Shift JIS communicate with client of Unicode encoding.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Saxena.

Asked: November 11, 2016 - 2:13 am UTC

Last updated: November 16, 2016 - 5:08 pm UTC

Version: Oracle 12c

Viewed 1000+ times

You Asked

Hi,

I have a database server which is having a character set set as Shift JIS and is communicating with client which is having same encoding,
But i have one more client which uses UNICODE encoding is it possible that this client can acquire data from my database server(Shift JIS)


Thanks and Regards.

and Chris said...

From Sergiusz Wolicki, our in-house NLS expert:

Of course, you can. Unicode supports all characters that Shift-JIS (JA16SJIS[TILDE]) supports and Oracle clients support character set conversion. Particular configuration requirements depend on the particular client API. Note that a Unicode-configured Oracle database client still needs a properly configured/enabled application to display the characters on the screen.

Also, Unicode supports significantly more characters that Shift-JIS. Therefore obviously, while you can display the whole content of your database, the opposite is not true. Not everything that you enter using the Unicode client can be stored in the Shift-JIS database.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Character Integrity Issues in a Multibyte Database Environment

Anant Saxena, November 17, 2016 - 12:38 am UTC

Hi,

I have a realted question i read a artical realted to
"Character Integrity Issues in a Multibyte Database Environment".

Link:
http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch7progrunicode.htm#i1008855

I didn't understand the workaround.

Thanks and Regards,
A Saxena