Posted on 2008-11-11
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
    LVL 22

    Expert Comment

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

    Author Comment

    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.
    LVL 1

    Accepted Solution

    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

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now