Re: Rookie Character Set Question

Chris Battles wrote:

> We have a browser based application that posts information to the
> database via stored procedures and the plsql web toolkit. Some users
> prefer to compose their responses in a rich text editor (MS Word,
> Wordperfect, etc) and then paste their response into the form. When
> these items are saved to the database some of their high ASCII
> characters are being saved as their HTML equivalents (“ for the
> left double quotation mark, ” for the right double quotation
> mark, etc.) What is the proper way to accomodate this - should we be
> trapping/replacing these characters on the way in/out or perhaps
> setting a character set parameter that tells the database the proper
> way to handle them?
>
> I suspect that this is super simple - I think that the toughest part
> about my problem is asking the question correctly so I apologize in
> advance.

There are calls in the toolkit just to do that... escape_sc (escape Special Characters) jumps to mind. However, ” can be saved just as well (it *does* take more space, though!), and will be translated back by the browser just as smoothly, so there really should not be a need to trap them - unless you run into space problems...

-- 

Regards,
Frank van Bortel