JDBC server side driver support to save mandarin characters into we8iso8859p1 characterset DB

114
July 10, 2019, at 03:30 AM

Im trying to save Mandarin characters into Oracle instance database 11g. Field datatype - NVARCHAR2 ; NLS_CHARACTERSET - WE8ISO8859P1 ; NLS_NCHAR_CHARACTERSET - AL16UTF16 I prefer not to change the CharacterSet as it has huge data.

At a test DB I tried with NLS_CHARACTERSET - AL32UTF8 and insert statement, but did not help. Tried changing defaultCharacterEncoding = UTF-8, not helping. If I directly edit, copy-paste mandarin characters into NVARCHAR2 field of DB, then it displays these characters correctly on screen (JSF page), The problem is only in saving.

I need help in saving mandarin characters in Oracle DB field. After trying in two different charactersets, I think there might be some JDBC settings which also need to be considered or some jar included in classpath.

Rent Charter Buses Company
READ ALSO
I need to write and read a file, stored on a File server using java [on hold]

I need to write and read a file, stored on a File server using java [on hold]

I am developing an application which allows a certain number of users connected on server to read and write to a particular file through this applicationI wanted to know the api s of java which could be useful

114
Nested Expressions In JsonPath

Nested Expressions In JsonPath

Could anyone please let me know how to evaluate nested expressions using JsonPath

112
MockBean not injected in MVC Controller test

MockBean not injected in MVC Controller test

I'm trying to test my controller in isolation of the spring application context

288