Unsolved
This post is more than 5 years old
272 Posts
0
11628
Notice for International users of OME.
Issue:
The SQL Server login account must be set to a language that uses a date format with month before day.
Day\Month\Year is not supported and affects all languages except English.
This fix is only required for the following languages.
| Arabic |
Arabic |
| British |
British English |
| čeština |
Czech |
| Dansk |
Danish |
| Deutsch |
German |
| eesti |
Estonian |
| Español |
Spanish |
| Français |
French |
| Italiano |
Italian |
| Nederlands |
Dutch |
| Norsk |
Norwegian |
| polski |
Polish |
| Português |
Portuguese |
| Português (Brasil) |
Brazilian |
| română |
Romanian |
| slovenčina |
Slovak |
| slovenski |
Slovenian |
| Suomi |
Finnish |
| Türkçe |
Turkish |
| ελληνικά |
Greek |
| български |
Bulgarian |
| русский |
Russian |
| ไทย |
Thai |
You should run this update when…
- Using typical install with an existing SQL Server Database.
- Using custom install to an existing SQL Server Database.
- The login to SQL Server has been altered to use a different default language
Resolution
Within SQL Server Management Studio change the login account to use English by default.
Note: You will need SQL Management Studio for this procedure.
Download SQL Express Management Studio 2008 R2
Development is working to resolve this issue.
Andreas Erson
94 Posts
0
May 29th, 2012 02:00
So, not supporting the Day/Month/Year-format that the vast majority of countries are using. Dell should really hire a standards-guy so that Dell gets these things right the first time.
DELL-Rob C
2.8K Posts
0
May 29th, 2012 15:00
Thanks for taking the time to post Andreas.
Heh, yes, we have a few of those standards-guys around :-)
OME _does_ in fact support day/month/year format in these countries.
This is a specific issue where the SQL server _ login account_ must be set to a language that uses a date format with month before day. This is a setting in the SQL server account, not how OME will display the dates. (You could, if you want, create a special ome login for this.) With this SQL setting, OME will display the dates fine in the countries listed in the OP.
The defect will be addressed in the next version of OME.
Thanks,
Rob
DELL-Rob C
2.8K Posts
0
May 30th, 2012 08:00
Thanks! Let us know how things go with you and OME.
Cheers,
Rob
Andreas Erson
94 Posts
0
May 30th, 2012 08:00
Rob C,
Great! Not as bad as I first thought then.
Keep up the good work!