Prevent the bi-lingual characters in database? [message #440345] |
Fri, 22 January 2010 14:01 |
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 |
|
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
|
|
|
|