special-characters

How do I store/retrieve diacritic symbols from an HTML form into the DB
The DB is 9i and has we8 characterset.

I assume user can key in whatever diacritic or symbol using the keyboard comibinations
http://www.utexas.edu/learn/html/spchar.html

and oracle will save it. is this correct? would db shows it in simple query.

Now on the way out from DB to web page, do I have to use escape special character before it displays on the html form.

sam15Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ivo StoykovCommented:
Hi sam15
yes you should. symbols are stored and retrieves as a (var)char. for html you should encode them.
0
sam15Author Commented:
do you have a sample sql insert statement that inserts diacritic charactrers into a text field and then select them back to see them in sql*plus.
0
leclaudeCommented:
Too bad you're on Oracle 9i.  If you were on 10g you could make use of the convert function.  I hope you'll be upgrading soon.

For example:

select convert('<diacritic chars go here>', 'US7ASCII') result from dual
/

result
----------
hello
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sam15Author Commented:
I misunderstood the reqt.
We have a diacritic stored in DB. We want to generate XML on web that has the equivalent ASCII for it. Does DB store the ASCII equivalent for it?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.