Home » SQL & PL/SQL » SQL & PL/SQL » Storing Chinese Character (Oracle 11g, Windows XP)
Storing Chinese Character [message #341703] Wed, 20 August 2008 00:58 Go to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Hi

As we are currently moving into globalization support,
we are in a desperate need to store other language
characters( primarily chinese ) into the database.

Below is the technical information and requirement
specification:

TECHNOLOGIES:
JAVA 1.3, JDBC Thin Driver, oracle 11g,
Toad 8.5.

SESSION CONFIGURATION:
NLS_CHARACTERSET = WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16

REQUIREMENT:

I have to store chinese character from a web page into the
database and retrieve the same information
to display onto the web page.

How should i continue?

Lookin for information with basic guidelines.

Thanks in Advance
Na2
Re: Storing Chinese Character [message #341705 is a reply to message #341703] Wed, 20 August 2008 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to change NLS_CHARACTERSET and database character set.
Read Database Globalization Support Guide

Regards
Michel
Re: Storing Chinese Character [message #341706 is a reply to message #341705] Wed, 20 August 2008 01:16 Go to previous messageGo to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Thanks for the reply Mic.
But, what is the parameter value which
we should give for NLS_CHARACTERSET?

Thanks
Natesh
Re: Storing Chinese Character [message #341711 is a reply to message #341706] Wed, 20 August 2008 01:35 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hello,

NLS_CHARACTERSET  = UTF8
NLS_NCHAR_CHARACTERSET = AL16UTF16


Babu
Re: Storing Chinese Character [message #341714 is a reply to message #341711] Wed, 20 August 2008 01:41 Go to previous messageGo to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Hi Babu

Alter session Set NLS_CHARACTERSET  = 'UTF8';


above command is giving missing or invalid option error.

Please Help.

Thanks
Natesh
Re: Storing Chinese Character [message #341717 is a reply to message #341714] Wed, 20 August 2008 01:46 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Hello,

You need migrate or re-create your controlfile. Best way communicate with your DBA.

Babu
Re: Storing Chinese Character [message #341720 is a reply to message #341717] Wed, 20 August 2008 01:54 Go to previous messageGo to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Hi Babu,

Have you worked on this kind of
language oriented task. If yes,
i want to make our conversation offline.

Please help in the regard.

Thanks
Natesh Polina
Re: Storing Chinese Character [message #341728 is a reply to message #341714] Wed, 20 August 2008 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
thisisnatesh wrote on Wed, 20 August 2008 08:41
Hi Babu

Alter session Set NLS_CHARACTERSET  = 'UTF8';


above command is giving missing or invalid option error.

Please Help.

Thanks
Natesh

Always Copy and paste your statement execution.
You can't change your session character set with ALTER SESSION, you have to use environment parameter (NLS_LANG) and restart the client program.

Regards
Michel
Re: Storing Chinese Character [message #341731 is a reply to message #341717] Wed, 20 August 2008 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
gentlebabu wrote on Wed, 20 August 2008 08:46

Hello,

You need migrate or re-create your controlfile. Best way communicate with your DBA.

Babu

Recreating the control file is useless to change the character set.

Regards
Michel

Re: Storing Chinese Character [message #341733 is a reply to message #341720] Wed, 20 August 2008 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
thisisnatesh wrote on Wed, 20 August 2008 08:54
Hi Babu,

Have you worked on this kind of
language oriented task. If yes,
i want to make our conversation offline.

Please help in the regard.

Thanks
Natesh Polina

Read the book I posted, you can't do it with a few lines in a forum.

Regards
Michel

Re: Storing Chinese Character [message #341740 is a reply to message #341731] Wed, 20 August 2008 02:40 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
Recreating the control file is useless to change the character set.

Regards
Michel


Sorry for that & Thanks a lot.

Babu
Previous Topic: How to Stop insertion of specific transactions in a table in ORACLE
Next Topic: How to find High impact sql query in terms of CPU utilization
Goto Forum:
  


Current Time: Mon Dec 05 03:10:48 CST 2016

Total time taken to generate the page: 0.13042 seconds