Learn how to a build a cloud-first strategyRegister Now



Posted on 2008-11-11
Medium Priority
Last Modified: 2013-12-19
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

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.

Question by:sam15
  • 2
LVL 22

Expert Comment

by:Ivo Stoykov
ID: 22940684
Hi sam15
yes you should. symbols are stored and retrieves as a (var)char. for html you should encode them.

Author Comment

ID: 22947041
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.

Accepted Solution

leclaude earned 1500 total points
ID: 22950191
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


Author Comment

ID: 22952751
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?

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question