'Â£ ' getting converted to '#'

ray.wurlod · Post by **ray.wurlod** » Wed Jun 22, 2005 6:13 pm

Welcome to US Imperialism, where Shift-3 is "#" (which, curiously, those in the US call the "pound sign"). Yamini's solution is the simplest.

chulett · Post by **chulett** » Wed Jun 22, 2005 7:54 pm

What do you call it, Ray... Hash? Square? Sharp? Shibboleth?

ray.wurlod · Post by **ray.wurlod** » Wed Jun 22, 2005 11:41 pm

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.

raoraghunandan · Post by **raoraghunandan** » Thu Jun 23, 2005 4:51 am

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

chulett · Post by **chulett** » Thu Jun 23, 2005 6:18 am

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.

roy · Post by **roy** » Thu Jun 23, 2005 6:23 am

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,

ray.wurlod · Post by **ray.wurlod** » Thu Jun 23, 2005 5:35 pm

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