Re: how to store special symbols in Oracle

On Wed, 19 Aug 1998 11:29:48 -0700, Glen Upreti <glen.upreti_at_nau.edu> wrote:
>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.

It is possible to "cheat" and insert 8 bit characters with SQL*LOADER. Unfortunately, if you do that and later try to exp/imp into a db with an 8 bit character set, the friendly imp will screw up the characters by trying helpfully trying to translate them. Is there any way to avoid this problem (still using exp/imp)? I understand I could update sys.props$ set value$='WE8ISO8859P1' where name='NLS_CHARACTERSET'; but I also realize this is dangerous and am trying to avoid dangerous. The put it to ascii and SQLLOAD into new database solution also is more than I care to do except as a last resort - lots 'o gigs. How does imp know what character set exp used, anyways?

>
>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

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Wed Aug 19 1998 - 17:56:35 CDT