[mapguide-internals] MapGuide RFC 18 - Localization

Wed Mar 7 14:52:30 EST 2007

Traian,

The issue is as I described it below that sorting and using SQL string
functions does not currently work if your RDBMS is in a different locale
then your MapGuide server. The solution this RFC is proposing will help
with this situation because rather then having the MapGuide server do
everything in the "C" locale it will now use the OS or user defined
locale, exception is the LC_NUMERIC category. Therefore, if you want
things to behave like they currently do then you will need to do nothing
as the server will be set to the OS locale, but if you have an odd
situation where your RDBMS happens to be in a different locale then your
MapGuide server and you are okay with overriding the MapGuide server
locale you will be able to change it. Without this RFC this was not an
option at all.

Thanks,
Bruce

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Traian
Stanev
Sent: March 7, 2007 12:42 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

I guess I'm trying to find out if we are trying to fix a problem in a
specific provider by changing the whole MapGuide process to use the
locale of one single FDO data source. What if I am connected to two FDO
data sources that use different locales? I would like to know what
"issues" really means.

Traian

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Bruce
Dechant
Sent: Wednesday, March 07, 2007 2:36 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

Traian,

There are issues with the MG server being in one locale and the RDBMS
being in another. By adding this property you could have the MapGuide
server locale match that of your data (this is the issue that came from
FDO).

Thanks,
Bruce 

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Traian
Stanev
Sent: March 7, 2007 12:32 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

Doesn't that depend on who executes the code? If the provider is an
RDBMS running in another process, that could be using a different locale
setting from MapGuide itself.  Another thing -- if FDO uses Unicode
everywhere like its API implies (MapGuide also), is there some sort of a
Unicode locale that covers all kinds of string lower/upper/sorting?

Traian

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Bruce
Dechant
Sent: Wednesday, March 07, 2007 2:27 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

Any provider that does sorting on attribute data or uses SQL UPPER/LOWER
functions. Without this change the above does not work as expected.

Thanks,
Bruce

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Traian
Stanev
Sent: March 7, 2007 12:14 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

Which providers in particular require this and in what way?

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Bruce
Dechant
Sent: Wednesday, March 07, 2007 2:04 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

It directly affects them and is part of the reason this RFC is being
done. :)

Bruce

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Traian
Stanev
Sent: March 7, 2007 12:03 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

How will that setting affect FDO providers loaded by the MapGuide
process?

Traian

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Bruce
Dechant
Sent: Wednesday, March 07, 2007 2:01 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

Steve,

Date/time/currency formatting will use the locale specified. Numbers
will continue to use the "C" locale internally as they have been.

Thanks,
Bruce

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Steve
Dang
Sent: March 7, 2007 11:58 AM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

Hi Bruce,

I assume this RFC includes some mechanism to switch from user locale to
C locale and vice versa, so that date/time/number/currency formatting
(e.g. MgUtil::StringToDouble, etc.) continues to work.

Thanks,
Steve.

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Bruce
Dechant
Sent: Wednesday, March 07, 2007 11:38 AM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

Thanks Trevor.

I'll update the RFC to reflect that the locale is platform specific and
does differ between Windows and Linux.

Bruce

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Trevor
Wekel
Sent: March 7, 2007 11:31 AM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] MapGuide RFC 18 - Localization

Hi Bruce,

We also have to be careful with locale on Linux.  We may need to modify
the MG_WCHAR_TO_CHAR macro to switch from wchar_t* to localized text.
On Linux, we currently assume the codepage is unicode compliant and
convert to UTF-8 text.  So we may need to use iconv to do the codepage
conversion on Linux.  Also the locale string convention is a little
different on Linux.

http://linux.about.com/library/cmd/blcmdl3_setlocale.htm

Here's a few examples of Linux locale strings:

en_US
en_US.iso88591
en_US.iso885915
en_US.utf8
en_ZA
en_ZA.iso88591

Thanks,
Trevor

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Bruce
Dechant
Sent: Wednesday, March 07, 2007 11:08 AM
To: MapGuide Internals Mail List
Subject: [mapguide-internals] MapGuide RFC 18 - Localization

The draft RFC 18 specification is now ready for review:

http://trac.osgeo.org/mapguide/wiki/MapGuideRfc18

Please post any comments to this mailing list.

Thanks,

Bruce Dechant

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals