| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2009-01-24 : 06:59:12
|
| I'd like to be able to enter that into a SQL Server database column. I can put £ here on the forum cos I'm using a Mac. With a PC I only get to put # or $I'm sure you experts can advise me... Is there a £ somewhere in that character set? How do I find it? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-24 : 08:55:14
|
| you dont need to store currency symbol in table column. just make field money and while displaying at front end make use of currency format functions to get £ symbol automatically. ALso make sure language & regional settings is pointed to english UK |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2009-01-24 : 09:26:00
|
| I agree with Visakh that you don't need to (and probably should not) store the £ symbol when storing financial data.If you want to store the currency symbols or other special characters in a character column, you can do that. In Windows, you can type the £ symbol and other special characters using keystroke combinations. To see the keystroke combinations, use Start->Run, type CharMap and press enter. |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-01-24 : 11:00:38
|
| However, what if the name of a trader's product is, for example: Buy Two @ 1.20 for the price of £2It's just in a description field, and I just want to put the £ symbol in there. The value will come in a different column. The currency and calculations will come in a report. In this Mac browser I can type £ whereever I want. Using a PC the closest character I can find is #. I know the Japanese Yen might have the same problem. € ?8 § ¶ • ª º – ?« … ¬ ° ¨?÷ = = µ ~ ~ ? v ç ˜ O ` å ß ? ƒ © ? ? ° ¬ œ ? ´ ® † ¥ ¨ ^ o p |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-01-24 : 14:13:11
|
| I'll tell you how I've done it. There may be another way - if I knew how to identify that symbol using something like a code such as (char xxx) ?I used this very post, written by Mac, and copied the pound symbol and copied it from the browser on a PC and pasted that into SQL and Crystal Reports formulae... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-25 : 05:06:47
|
| i think £ is CHAR(163) |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-01-25 : 09:34:06
|
| Excellent. Thanks. Good to know the syntax for that. I'm gonna try to get the whole characyer set displayed with a loop |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-01-25 : 09:54:16
|
| declare @x intset @x = 0while @x <270beginprint char(@x)set @x = @x+1endCan't copy the messages output |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-25 : 12:14:59
|
| why do you need to copy? just use the value to store in column. |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-01-26 : 04:55:05
|
| Tried it, tried it.As you can see, I'm using print, not select. Print gives output in messages, not the result set. Doing it with select, each character is in its own row. I tried:select into #temp char(@x) which is no good without a standard FROM clauseHow do I do it? The char(1 .. 270) thing is strange |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-26 : 08:37:31
|
do you mean this?select char(173) as val into #temp or insert into tableselect char(173) |
|
|
|
|
The £ Symbol