Re: How to get a reference of a character

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 12 Oct 2006 03:26:03 -0700
Message-ID: <1160648763.924420.107000@b28g2000cwb.googlegroups.com>

Tzanko wrote:
> I have a special character in a database that I do not have direct
> access to. The character appeared after database restore from backup
> and upgrade and I would like to remove it. However, since it is a
> strange looking character and seem to be interpreted differently on
> diferent platform/application, I am not sure how to refer to this
> character in my script.
> Any suggestions will be appreciated.
> Regards, Tzanko

*) Check what character set your database uses *) Check what character set is set on the client accessing the database. (NLS_LANG)
*) Look at the UNISTR() function

cheers,
Martin Received on Thu Oct 12 2006 - 05:26:03 CDT