Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Save currency symbol in DB
>Subject: Save currency symbol in DB
>From: "Andrew Stubbs" news_at_stusoft.com
>Date: 2/10/01 1:58 PM GMT Standard Time
>Message-id: <981813497.4662.0.nnrp-09.3e31fc09_at_news.demon.co.uk>
>
>I am trying to save the "£" pound sign into a varchar, but when i retrieve
>it I get the "#" sign.
>I am using WEISO8859P1 charset on the server. I have also tried changing
>NLS_LANG etc but it makes no difference. Using 8.1.6 on Linux.
>
>Where have I gone wrong ?
>
>Andrew
>
>
>
>
>
>
>
>
Hi Andrew,
You say you're using 8.1.6 on Linux. Is that where both the server and the
client session (i.e. the one that returns the #) or is the client session on a
different platform, e.g. Windows NT ?
Regards,
Rob
Received on Mon Feb 12 2001 - 16:52:28 CST