Re: SQL script

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 01 Jun 2001 17:03:02 -0700
Message-ID: <3B182D36.3602380E@exesolutions.com>

parminder garcha wrote:

> I have a basic SQL script that inserts into tables. Some of the text string
> contain the '£' for example 'This is the cost £25.00', however ever time the
> scripts run the '£' sign is replaced by a '#', does anyone know how to keep
> my
> '£' sign from turning into a '#'.
>
> Regards.
> ps. please email me at parminder.garcha_at_bt.com

Sounds to me like you have the national language character set incorrectly selected.

Look in your documentation on setting the NLS parameters.

Daniel A. Morgan Received on Fri Jun 01 2001 - 19:03:02 CDT