I have a Application in VB.net that is tied to a SQL DB. I can create a view in SQL with various tables which will give me essentially 4 columns. Column 1 is a string data type with "¬" (euro). Column 2 is a money data type let's say with a value of "2.50". Column 3 is a string data type with "¥" (yen). Column 4 is a money data type let's say with a value of "200.15". What I want to do is have the application read Coulmn 2 as "¬2.50" and Column 4 as "¥200.15"
When I view any money data types I always see "$" (dollar) and I know that if I change my Windows Regional and Language Options from English(United States) to Japanese then I can always see "¥" (yen). What I want to do is somehow override or ignore the Regional and Language Options so that I can display the currency symbol that I want.
Will it make a difference if column 2 is always a particular currency type and column 4 is always a particular currency type, versus having anything including "¥" (yen), "¬" a(euro), $(dollar), and £(pound)?