Regional Settings

[JFF]

Code: Select all

NEWSUBZONE CANADA, -4
  SUBZONENAME 'Quebec (West, EST)'
  INTERNETCODE 'ca'
  TIMEZONECODE "EST", "EDT"
;  ADDDSTTDWM , , , , , , , , , , 
;  ADDDSTTDM , , , , , , 
  ADDLANGUAGES FRENCH, ENGLISH
  ADDPHONESIMPLEIDD "011"
  ADDPHONECOUNTRYCODE "1"
  ADDINTERNATIONALCURRENCY 'CAD '
  ADDCURRENCY '$'
  ADDCURRENCYGROUPDIGITS 3
  ADDCURRENCYDECIMALSEPERATOR ','
  ADDINTERNATIONALFRACDIGITS 4
  ADDCURRENCYFRACDIGITS 4
;  ADDCURRENCYBEFORESIGN 
;  ADDCURRENCYPOSITION 
  ADDNUMBERGROUPDIGITS 3
;  ADDGROUPSEPERATOR       ;? 
  ADDGROUPSEPERATORUTF 0x00A0
  ADDDECIMALSEPERATOR ','
  ADDPOSITIVESIGN '+'
  ADDNEGATIVESIGN '-'
  ADDSEPERATESIGNWITHSPACE N
;  ADDSIGNPOSITION 
  ADDZEROUSED Y
  ADDCALENDAR GREGORIAN
  ADDDATETIMEFORMAT '%A %D %B %Y %H h %M'
  ADDDATEFORMAT '%A %D %B %Y'
;  ADDSHORTDATEFORMAT 
  ADDTIMEFORMAT '%H h %M'
ENDSUBZONE

French (canada) standard......

money.... 000 000 000, 00 $, - 000 000 000, 00 $
finance ... - 000 000 000, 00 $ is (000 000 000, 00) $
numbers 000 000 000, 000 000
date : 1er janvier 1970 ; Jeudi, 1er janvier 1970, 01-01-1970
date : 2 janvier 1970 ; Vendredi, 2 janvier 1970, 02-01-1970
time : ex... right now 13:33...

I don't know why but for currencies and date/time formate they tend to separate us in many different settings... like in windows

Canadian French
Canadian Multilingual ...
English (Canada)
French (Canada)
[...]

In windows these settings differ mostly by the keyboard settings but English (Canada) and French (Canada) are the two ones I use and date, time, money and numbers are not the same... and keyboard is really different.

[Brendan]

Hi,

Thanks for responding

French (canada) standard......

money.... 000 000 000, 00 $, - 000 000 000, 00 $
finance ... - 000 000 000, 00 $ is (000 000 000, 00) $
numbers 000 000 000, 000 000

My database currently doesn't support the financial form. I think using brackets instead of the negative sign (and maybe red text instead of black) is something accountants use worldwide, so it would be an option in spreadsheets and accountancy software rather than a regional setting. If this isn't a correct assumption let me know and I'll add it to the database

I don't know why but for currencies and date/time formate they tend to separate us in many different settings... like in windows

Canadian French
Canadian Multilingual ...
English (Canada)
French (Canada)
[...]

In windows these settings differ mostly by the keyboard settings but English (Canada) and French (Canada) are the two ones I use and date, time, money and numbers are not the same... and keyboard is really different.

Are these differences a good thing? Currently my database would generate:

Code: Select all

 If FRENCH is set as default:
   "samedi 26 juin 2004 01 h 23"
   "sam. 26 juin 04 01 h 23"
   "samedi 26 juin 2004"
   "sam. 26 juin 04"
   "01 h 23"
   - 000 000 000, 00 $
   000 000 000, 000 000

 If ENGLISH is set as default:
   "Saturday 26 June 2004 01 h 23"
   "Sat 26 Jun 04 01 h 23"
   "Saturday 26 June 2004"
   "Sat 26 Jun 04"
   "01 h 23"
   - 000 000 000, 00 $
   000 000 000, 000 000

I can add more "sub-zones" to support more Canada's, although I can't see why microsoft would have "French (Canada)" and "Canadian French" as they seem like the same thing to me. My database currently has something like "Canadian Multilingual" and nothing else...

Also the regional settings are not effected by the keyboard type. The person who installs the OS would install the keyboard driver that is appropriate for the type of keyboard. Several users may have different regional settings, so that you could have a German user, an English user and an Arabic user all using the same French keyboard (and probably getting annoyed at it ::)).

Also, how do your short dates look? For e.g. here we'd write "26/6/04" (or occasionally "26-6-04"), but Americans would write "6/26/04"..


Thanks,

Brendan

[JFF]

Also, how do your short dates look? For e.g. here we'd write "26/6/04" (or occasionally "26-6-04")

Same here... but in long dates... the first day of a month should be written "1er [mois]" and the next day "2 [mois]", and.... (mois = month)

If ENGLISH is set as default:
"Saturday 26 June 2004 01 h 23"
"Sat 26 Jun 04 01 h 23"
"Saturday 26 June 2004"
"Sat 26 Jun 04"
"01 h 23"
- 000 000 000, 00 $
000 000 000, 000 000

they don't use 24hour time format (so... AM/PM)... i kind of remember the dollar sign before the number.... $ 000,000,000.00.... i'm not sure where is the negative sign (before the $, or after)...

[Brendan]

Hi,

I've updated the regional database, and released a demo (my OS) that contains a graphical menu that uses the regional database to display the time & date (for e.g. "mardi 7 septembre 2004 17 h 09" if France is set).

It takes into account the time zone and daylight saving info, the language, etc and also allows the region to be set (so that once the RTC is set to UTC you can find the time anywhere in the world)..

All of the regional database source files can be viewed online. Also everything (source, binary and docs) can be downloaded. The web site is:
http://www.users.bigpond.com/sacabling/


Cheers,

Brendan


BTW I still need more information, so if you're an Irish speaking Albanian living in Sweden with Chinese relatives... ::)

[Candy]

BTW I still need more information, so if you're an Irish speaking Albanian living in Sweden with Chinese relatives... ::)

Might be able to get you a french-speaking Iranier living in Greece with Dutch relatives... gonna try my best