Page 1 of 1

Posted: Wed Jun 22, 2005 6:13 pm
by ray.wurlod
Welcome to US Imperialism, where Shift-3 is "#" (which, curiously, those in the US call the "pound sign"). Yamini's solution is the simplest.

Posted: Wed Jun 22, 2005 7:54 pm
by chulett
What do you call it, Ray... Hash? Square? Sharp? Shibboleth? :wink:

Posted: Wed Jun 22, 2005 11:41 pm
by ray.wurlod
Hash, or "hash sign" or "hash mark".

Nothing whatsoever to do with hashed files. Or hash. Either kind. Saves confusion with the name of the currency.

Posted: Thu Jun 23, 2005 4:51 am
by raoraghunandan
Hi Yamini and All,

When I am trying to use NVarchar i get the following error: ' Stage does not support UNICODE character set'

I tried using the OCI 9i Stage as well as the DRS stage, both times getting the same error.

Any suggestions?

Thanks,
Raghu

Posted: Thu Jun 23, 2005 6:18 am
by chulett
ray.wurlod wrote:Hash, or "hash sign" or "hash mark".
I know... was just kidding.
raoraghunandan wrote:When I am trying to use NVarchar i get the following error: ' Stage does not support UNICODE character set'
True, the OCI stage does not. The DRS stage probably throws the same error when set to Oracle but what about when you set it to 'ODBC'? It may support unicode. :?

Posted: Thu Jun 23, 2005 6:23 am
by roy
Hi,
Do you have NLS enabled in your server?
If not you might need to install it first.
Then choose the proper NLS for the stage.

(Some how I vaguely recall something regarding support of the euro sign, so I wonder if one exists for the pound as well?)

IHTH,

Posted: Thu Jun 23, 2005 5:35 pm
by ray.wurlod
"They" had to do a lot of fiddling to support the Euro symbol. Especially since Micro$oft decided to use the character for Euro that "they" used for null.

If you remember that "they" are based in Boston, where the Tea Party is still remembered, this may explain why there is no explicit support for the sterling pound symbol. :lol: