OraFAQ Forum: Server Administration » how to know the character set of oracle server and client...?

Home » RDBMS Server » Server Administration » how to know the character set of oracle server and client...?

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

how to know the character set of oracle server and client...? [message #182364]

Fri, 14 July 2006 08:18

balavignesh
Messages: 180
Registered: March 2005

Senior Member

Hi,

how to know the character set of oracle server and client...?

regards
bala

Report message to a moderator

Re: how to know the character set of oracle server and client...? [message #182379 is a reply to message #182364]

Fri, 14 July 2006 08:37

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Select from nls_session_parameters and nls_database_parameters.

Report message to a moderator

Re: how to know the character set of oracle server and client...? [message #182414 is a reply to message #182379]

Fri, 14 July 2006 12:40

balavignesh
Messages: 180
Registered: March 2005

Senior Member

Hi frank,

thanks for reply.

If there is mismatch b/w the server and client character set , how can we change the client char set compatible to server char set,say for ex the server char set is US7ASCII and client char set is WE8MSWIN1252

Report message to a moderator

Re: how to know the character set of oracle server and client...? [message #182427 is a reply to message #182364]

Fri, 14 July 2006 14:51

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

You should not match the characterset of Client with the server, infact server db should be superset of all native languages of client applications.

Report message to a moderator

Previous Topic:	Characterset Migration
Next Topic:	Should I add a fourth datafile or autoextend

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:47:52 CDT 2024