OraFAQ Forum: SQL & PL/SQL » Storing Chinese Character

Home » SQL & PL/SQL » SQL & PL/SQL » Storing Chinese Character (Oracle 11g, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Storing Chinese Character [message #341703]

Wed, 20 August 2008 00:58

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

Report message to a moderator

Re: Storing Chinese Character [message #341705 is a reply to message #341703]

Wed, 20 August 2008 01:14

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to change NLS_CHARACTERSET and database character set.
Read Database Globalization Support Guide

Regards
Michel

Report message to a moderator

Re: Storing Chinese Character [message #341706 is a reply to message #341705]

Wed, 20 August 2008 01:16

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

Report message to a moderator

Re: Storing Chinese Character [message #341711 is a reply to message #341706]

Wed, 20 August 2008 01:35

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

NLS_CHARACTERSET  = UTF8
NLS_NCHAR_CHARACTERSET = AL16UTF16

Babu

Report message to a moderator

Re: Storing Chinese Character [message #341714 is a reply to message #341711]

Wed, 20 August 2008 01:41

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

Report message to a moderator

Re: Storing Chinese Character [message #341717 is a reply to message #341714]

Wed, 20 August 2008 01:46

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

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

Babu

Report message to a moderator

Re: Storing Chinese Character [message #341720 is a reply to message #341717]

Wed, 20 August 2008 01:54

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

Report message to a moderator

Re: Storing Chinese Character [message #341728 is a reply to message #341714]

Wed, 20 August 2008 02:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Storing Chinese Character [message #341731 is a reply to message #341717]

Wed, 20 August 2008 02:19

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Storing Chinese Character [message #341733 is a reply to message #341720]

Wed, 20 August 2008 02:20

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Storing Chinese Character [message #341740 is a reply to message #341731]

Wed, 20 August 2008 02:40

babuknb
Messages: 1736
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 09:40:08 CST 2024