Xerratus
Happily stressed out, since 1974
Sunday, August 03, 2008
<< Fix for invalid character in sproc calling sp_xml_preparedocument that has valid vs.NET xml
.ToLongDateString() showing incorrect format on international server (Windows 2008 running IIS7)
Over the weekend I helped launch a website that was located in the US but opted to host the site on a Canadian dedicated server. One of the first things I did while setting up the server was to change the regional settings from "en-CA" to "en-US" (control panel -> regional and language options). After pushing the site up to the server, I noticed during my testing that everywhere I was displaying dates (using the built-in .ToLongDateString() function of the DateTime object), the incorrect format was showing up. Further more, transaction dates were being entered into the database incorrectly as well.
en-CA formats:
Short date: "dd/MM/yyyy"
Long date: "MMMM-dd-yy"
en-US formats:
Short date: "M/d/yyyy"
Long date: "dddd, MMMM dd, yyyy"
So, the computers region was setup correctly but the incorrect dates were still being shown. Since the dates were being driven by a .NET object, I next looked at the .NET Framework (I'm running 2.0). The solution I found was to modify the
globalization element
of the web.config by adding the following to the <system.web> element:
<
globalization
fileEncoding
=
"
utf-8
"
requestEncoding
=
"
utf-8
"
responseEncoding
=
"
utf-8
"
culture
=
"
en-US
"
uiCulture
=
"
en-US
"
/>
Furthermore, since this was a dedicated server and all of the sites were going to be US sites we moved this from the web.config to the machine.config so that all new sites would not run into this problem.
Sunday, August 03, 2008 @ 11:20 AM (-07:00) Pacific Daylight Time
Comments (0)
tags:
Programming
admin: Edit | Remove
Name
E-mail
Home page
Remember Me
Comment (Some html is allowed:
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u
) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview
Site Navigation
About Me
Calendar
Disclaimer
Site Search
Sponsored Links
Calendar
<
November 2008
>
Sun
Mon
Tue
Wed
Thu
Fri
Sat
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
Monthly Archives
August, 2008 (1)
July, 2008 (1)
March, 2008 (2)
January, 2008 (3)
December, 2007 (3)
October, 2007 (1)
September, 2007 (1)
August, 2007 (5)
July, 2007 (5)
June, 2007 (3)
April, 2007 (5)
February, 2007 (2)
January, 2007 (2)
December, 2006 (9)
November, 2006 (15)
October, 2006 (19)
September, 2006 (3)
August, 2006 (5)
July, 2006 (4)
June, 2006 (6)
May, 2006 (12)
April, 2006 (20)
March, 2006 (11)
February, 2006 (14)
January, 2006 (14)
December, 2005 (23)
November, 2005 (23)
October, 2005 (42)
September, 2005 (4)
Categories
Alert (14)
Community Server (2)
Daily Quote (1)
Did you know (7)
Dumb Searches (1)
Dumbass (15)
General (133)
Haiku (6)
Holiday (5)
Movie quote (8)
Paladin (4)
Paris (1)
Parody (1)
Photo (24)
Political (2)
Priceless (7)
Programming (35)
Pytheus (2)
Rant (23)
Screen capture (15)
SQL (3)
Technical (39)
Video (4)
Vista (8)
Visual Studio 2005 (2)
Wifey (33)
XP (1)
Feeds
RSS
Atom
Good Reading
Code Better
Coding Horror
Computer Zen
Daily WTF
Days Bush Has Left
Dooce
Fargg
Me-Nikk
Post Secret
Rory Blythe
TechCrunch
Sign In