Hi, all

How can I enter an ASCII character (£, ALT-156) into a varchar column in a
table? Whe I enter it (either through an application or throught TOAD) it
switches to the # symbol.

I have Oracle 8.1.7 with characterset US7ASCII.

Thanks for any help.

MP

Hi,

I think you will have troubles.

US7ASCII is a 7 bit long character set so you can enter characters
from alt +000 to alt + 127.

So, it will be difficult for you.

You will have to change your character set to at least WE8ISO8859P1
(western Europe) ou UTF8 (AL32UTF8).

The best thing is to create a new database with the right character
set. If not, it is possible to migrate character set for a database
but it is not an easy thing if you have "non common" column types
(like NVARCHAR, BLOB, NLOB).

regards,

Olivier

"Perico de los Palotes" <ppalotes2004 (AT) yahoo (DOT) com> wrote

Thanks, Olivier. That was very helpful.

Regards,

MP




"Olivier Guyot" <guyot.oliv (AT) wanadoo (DOT) fr> wrote