Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Japanese characters are all "???" with Oracle
15 views
Skip to first unread message
zbob99
Mar 6, 2005, 7:27:11 AM3/6/05
to
I am having a problem storing and retrieving Japanese characters from Oracle.
Here are the specs: Oracle 9i Oracle JDBC thin driver CFMX 6.1 with updater
UTC-8 page encoding Installed the Japanes IME support that is built-in to WinXP
pro to input the Japanese chars. I can sucessfully input, store, retrieve and
view Japanese characters using an 'Access with unicode' database but when I
change the database to Oracle 9i with JDBC thin driver then I only get
upsidedown '?''s. Any suggestions would be greatly appreciated. Bob
Here are the specs: Oracle 9i Oracle JDBC thin driver CFMX 6.1 with updater
UTC-8 page encoding Installed the Japanes IME support that is built-in to WinXP
pro to input the Japanese chars. I can sucessfully input, store, retrieve and
view Japanese characters using an 'Access with unicode' database but when I
change the database to Oracle 9i with JDBC thin driver then I only get
upsidedown '?''s. Any suggestions would be greatly appreciated. Bob
zbob99
Mar 6, 2005, 8:50:05 AM3/6/05
to
Typo: UTF-8 not UTC-8, of course. Also, using NVARCHAR datatype for the Japanese character field in a stnadard Oracle 9i db table. Thanks for any advice.
Bob
PaulH
Mar 6, 2005, 11:13:59 PM3/6/05
to
what encoding did you use for the oracle db?
zbob99
Mar 7, 2005, 7:15:49 PM3/7/05
to
I did not use any special encoding for the database. I thought I could simply
use an NVARCHAR datatype. Is this perhaps the problem? What encoding should I
use and how is it accomplished? Do I need to recreate the db? Hope not!
Thanks. Bob
use an NVARCHAR datatype. Is this perhaps the problem? What encoding should I
use and how is it accomplished? Do I need to recreate the db? Hope not!
Thanks. Bob
PaulH
Mar 7, 2005, 11:54:04 PM3/7/05
to
oracle's probably using the default encoding, no idea what that would be. if
you need unicode then i imagine utf-8 (or whatever oracle calls it) would be
best. i don't know oracle well enough to advise you on how to do that (which is
why i didn't answer this thread for so long).
you need unicode then i imagine utf-8 (or whatever oracle calls it) would be
best. i don't know oracle well enough to advise you on how to do that (which is
why i didn't answer this thread for so long).
zbob99
Mar 8, 2005, 9:05:57 AM3/8/05
to
I will get with my local Oracle guru for some additional advise on this. Thanks Paul!
zbob99
Mar 8, 2005, 2:08:24 PM3/8/05
to
Oracle has a default database character set of 'WE8MSWIN1252' which is not
unicode but also has another setting called national character set which is
'AL16UTF16' for my database which is unicode (UTF16). Best I can figure this
setting supposedly allows storage of Unicode characters in 'N' datatype
columns. But not sure and it certainly has not worked for me. I think I am
stuck with 'good ole' MSAccess for now until I have time and the nerve to
rebuild or alter the Oracle database. Thanks for your help Paul. BTW, for you
Oracle wannabes, you can view your current database character set with the
following command: select * from NLS_DATABASE_PARAMETERS; Bob
unicode but also has another setting called national character set which is
'AL16UTF16' for my database which is unicode (UTF16). Best I can figure this
setting supposedly allows storage of Unicode characters in 'N' datatype
columns. But not sure and it certainly has not worked for me. I think I am
stuck with 'good ole' MSAccess for now until I have time and the nerve to
rebuild or alter the Oracle database. Thanks for your help Paul. BTW, for you
Oracle wannabes, you can view your current database character set with the
following command: select * from NLS_DATABASE_PARAMETERS; Bob
zbob99
Mar 8, 2005, 9:00:21 PM3/8/05
to
I finally got this to work with Oracle. It required altering the database
character set which apparently can be risky if not done correctly. Here is a
link discussing the issues, options and risks:
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96529/whatsnew.htm
And here are the set of sql commands that I ran to alter my Oracle 9i db from
the default character set to UTF8. SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER
SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER
SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASE CHARACTER SET
INTERNAL_USE UTF8; It is also recommended to run 'CSSCAN' prior to altering to
determine if your database is convertible. Cheers! Bob
character set which apparently can be risky if not done correctly. Here is a
link discussing the issues, options and risks:
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96529/whatsnew.htm
And here are the set of sql commands that I ran to alter my Oracle 9i db from
the default character set to UTF8. SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER
SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER
SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASE CHARACTER SET
INTERNAL_USE UTF8; It is also recommended to run 'CSSCAN' prior to altering to
determine if your database is convertible. Cheers! Bob
0 new messages