sam15
asked on
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.
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.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
yes you should. symbols are stored and retrieves as a (var)char. for html you should encode them.