insert with entity recognition

From: okey <oldyork90_at_yahoo.com>
Date: Mon, 16 Aug 2010 12:36:28 -0700 (PDT)
Message-ID: <b48c66da-3de7-4e86-9169-6905599fb84b_at_t2g2000yqe.googlegroups.com>



unicode database setup 10g

&#0174 is a copyright symbol

How can we make insert entity encode on the fly?, as in

insert into product (title) values ('&#0174');

We want the actual copyright symbol to show, not the &#0174. Inserting/updating from the application server is no problem, we entity encode there.

(ps - we get the insert scripts like this)

thank you. Received on Mon Aug 16 2010 - 14:36:28 CDT

Original text of this message