Home » RDBMS Server » Server Administration » Prevent the bi-lingual characters in database?
Prevent the bi-lingual characters in database? [message #440345] Fri, 22 January 2010 14:01 Go to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
we are using oracle10g version. Currently my character set is WE8MSWIN1252 At present, somehow,
we have non-english characters(for example spanish) in the database. We wanted to stop entering
these kind of characters.. Can we prevent this by changing the current character set?
Any help is highly appreciated...

Regards
Re: Prevent the bi-lingual characters in database? [message #440351 is a reply to message #440345] Fri, 22 January 2010 14:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Only US7ASCII allows you to enter only english character, hopefully for you GB did not enter €uro world.

You cannot change the character set but you can create a new database with this character set and import your schemas.

This does not prevent from inserting non-english characters but this prevent the database from understanding them.

Regards
Michel

[Updated on: Fri, 22 January 2010 14:53]

Report message to a moderator

Re: Prevent the bi-lingual characters in database? [message #440353 is a reply to message #440351] Fri, 22 January 2010 15:07 Go to previous message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Michal, Thanks for the input... I understand now.

[Updated on: Fri, 22 January 2010 16:00]

Report message to a moderator

Previous Topic: ora-03114 using local database
Next Topic: Migration from DB2 to Oracle
Goto Forum:
  


Current Time: Fri Nov 29 11:47:03 CST 2024