| Author |
storing currency symbols in the sql server database
|
|
|
| Hi,
can you guide us on how to store currency symbols in SQL Server database
tables .. The symbols are to be displayed on the ASP pages being fetched from
the Database. Plz guide..
| |
| Jon Paal 2006-12-18, 6:56 pm |
| http://aspalliance.com/groups/micro...ols_in_SQL.aspx
"iweb" <iweb@discussions.microsoft.com> wrote in message news:3660BF3D-18C6-4186-9641-7B2BC5911BC1@microsoft.com...
> Hi,
> can you guide us on how to store currency symbols in SQL Server database
> tables .. The symbols are to be displayed on the ASP pages being fetched from
> the Database. Plz guide..
| |
| Anthony Jones 2006-12-19, 7:56 am |
|
"iweb" <iweb@discussions.microsoft.com> wrote in message
news:3660BF3D-18C6-4186-9641-7B2BC5911BC1@microsoft.com...
> Hi,
> can you guide us on how to store currency symbols in SQL Server database
> tables .. The symbols are to be displayed on the ASP pages being fetched
from
> the Database. Plz guide..
I would recommend that you use an NVARCHAR field to store your currency
symbols and use UTF-8 encoding on the pages that need to show them:-
Response.CodePage = 65001
Response.CharSet = "UTF-8"
Things can get messy on IIS5 (Win2k) I would recommend you make all pages in
the application use UTF-8 (regardless of whether they need to show these
symbols or not).
|
|
|
|