Display Euro with LCID 1

[BDC2]

I'm devloping an international property listings database for a client. If say the property was in the UK I can set the LCID and it will display GPB£, fine.

How can I display French properties (or any other Euro converted country) in Euros. The Session.LCID = 1036 displays currency in French Francs which is undesirable. I need to force Euros, is it possible with LCID?

Thanks, BDC.

 

[BDC2]

Anyone? BDC.

 

[onpnt]

Hi BDC2,
I did a bit of research on your question and was really supprised the answer was not a easy quick one. I found various discussions as to there being issues with the LCID settings involved with the EURO. After reading a few things it seemed to me at least writing a converter for the symbol was or would be my solution for it.

anyways here's some things I found out
<quote src=&quot;M$&quot;>
LCID Optional Integer.
The LCID attribute can be used to specify the country/region whose currency format is being used. For example, 1033 for the United States.
Two special cases involve the Euro symbol format. If LCID = -1 (0xFFFFFFF), the Euro symbol is added as a prefix to the number. If LCID = -2 (0xFFFFFFE), the Euro symbol is added as a suffix to the number. The number of decimal digits is 2, although this can be overridden by the Decimals attribute of the field. The Euro currency symbol is equal to 0x20AC in UCS-2.
</quote>

links

http://msdn.microsoft.com/library/d...ry/en-us/spsdk11/caml_schema/spxmlelField.asp

M$ reference

http://msdn.microsoft.com/library/d...r2002/htm/cs_ss_featureinternational_hdtw.asp

table

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spptsdk/html/tsfpplcid.asp

conversion script

http://www.alphasierrapapa.com/comp...mponentCenter/Euro/Samples/eurocalculator.asp

_________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[BDC2]

Thanks onpt,

I found that first M$ ref, but LCID = -1 gives an error. I was hoping there would be a magic EURO setting like this that works, oh well.

I imagined I would have to write a converter so thanks for the eurocalculator links and for your research time ;-) BDC.

 

[onpnt]

_________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]