I change the insert sql statement in my JAVA program, by including convert function to convert 1 encoding to BIG5 encoding (my Oracle is BIG5).
I also check using my java program to get my local encoding
System.getProperty ("file.encoding"), it gives me 'WE8ISO8859P15'.
So I change the INSERT sql to include conversion from 'WE8ISO8859P15' to BIG5 -->
vlSqlQuery = "INSERT INTO mytable (str_myfield) VALUES (convert " +str_myfield + ", 'WE8ISO8859P15', 'ZHT16BIG5'))";
str_myfield is data read from my txt file
The result is different but still garbled.
I also tried from 'UTF8', 'AL32UTF8', 'AL16UTF16', 'US7ASCII', 'UTFE' to 'ZHT16BIG5' with no avail.
Any idea what is my java encoding? Why not 'WE8ISO8859P15' as returned by System.getProperty ("file.encoding")?
Then environment of the server running my java program shows:
LC_ALL=en_GB.ISO8859-15 (which means 'WE8ISO8859P15' encoding).