Re: how to store special symbols in Oracle

the symbol you are trying to insert is not, as far as I know, standard in US7ASCII, so you should check what you set the nls_charset to at db creatation time by selecting it from nls_parameters and if you are using UNIX and did not specify another charset at creation time, then your default is US7ASCII and you must recreate you db with another charset which will accept that symbol.

Glen Upreti
Oracle DBA
Northern Arizona University
glen.upreti_at_nau.edu

petergangzhang_at_my-dejanews.com wrote:
>
> does anyone know how to store special symbols in Oracle
> database?
> I am trying to save ‘®’ symbol into the database, it doesn’t
> work, it is
> always saved as ‘?’. I am using VARCHAR2 as the datatype. For
> example,
> when I try to insert into a table with a field like: ‘Tritace®’,
> I will
> get ‘Tritace?’ stored in the database. Does anyone know how to do this?
>
> Thanks!
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Aug 19 1998 - 13:29:48 CDT