Internationalizing a website

[edmicman]

I have a SQL Server 2000 database and run a website using ASP. I have a client who wants a custom website, who resides in Australia. He's concerned about dates, times, postal codes, etc. showing up. I'm not really sure where to start....are things like dates set up on the server side as far as the database structure or something? Or is it on the client side in how their browser interprets things? Or do I need to use VBScript / Javascript to mask things like dates, phone numbers, zip codes, etc.? Any info would be great....thanks!

 

[Maverick2002]

date/time/etc that shows up on a webpage is usually the server date/time, which varies with location of the server (it has nothing to do with the server database; it's just the date/time reported by the server's OS). IIRC you could just as easily write a script that would display the same date/time as a user's PC would by fetching that data.

 

[edmicman]

Ah, thanks for the info. I'll check into what options I have with that...

 

[stndn]

By the way, one thing you might want to note:

Does he want the date to be dd/mm/yyyy, or mm/dd/yyyy?
Also, for the sake of 'timezone standardization', you can choose to make the date/time in GMT then convert it to whatever local timezone your client wants.

Usually the server has set their appropriate timezone where the server is located, and with the call to gmttime() function (whatever it is in ASP), it will convert the time to appropriate GMT time.