Re: insert with entity recognition

> &#0174 is a copyright symbol

Actually, it's the "registered trade mark" symbol.

> How can we make insert entity encode on the fly?, as in
>
> insert into product (title) values ('&#0174');

You have to use the Unicode exadecimal character number code, i.e.:

insert into product (title) values (unistr('\00AE')) ;

HTH         Y. Received on Tue Aug 17 2010 - 07:18:56 CDT