Re: [mv] Locale stuff

[jojo@buchonline.net]

Hi Mike Heins,

> Dear All,
> One reason for the confusion about this stuff I think is
> clear; I have never emphasized the power of this setting
> in catalog.cfg:
> 
> 	Locale de_DE

I use this i.e. in my srchfrom page at the top of the page like
[setlocale de_DE].

And in my catalog.cfg i have

Locale eur_EUR p_cs_precedes       0
Locale eur_EUR p_sep_by_space      2
Locale eur_EUR mon_decimal_point   ,
Locale eur_EUR mon_thousands_sep .

Locale de_DE
Locale de_DE p_cs_precedes 0
Locale de_DE p_sep_by_space 2
Locale de_DE frac_digits 2
Locale de_DE mon_decimal_point   ,
Locale de_DE mon_thousands_sep .


In my FreeBSD-Box, the command "printenv" tell me this:
server:/home/<xyz>/mvend[<xyz>]# printenv 
PATH=/home/<xyz>/mvend/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
TERM=xterm-color
MAIL=/var/mail/<xyz>/mvend
BLOCKSIZE=K
USER=<xyz>
HOME=/home/<xyz>/mvend
SHELL=/usr/local/bin/tcsh
HOSTTYPE=FreeBSD
VENDOR=intel
OSTYPE=FreeBSD
MACHTYPE=i386
SHLVL=1
PWD=/home/<xyz>/mvend
LOGNAME=<xyz>
GROUP=<xyz>
HOST=server.intrabol.local
RSYNC_RSH=ssh
EDITOR=/usr/bin/ee
PAGER=more
LC_COLLATE=de_DE.ISO_8859-1
LC_CTYPE=de_DE.ISO_8859-1
LC_MONETARY=de_DE.ISO_8859-1
LC_NUMERIC=de_DE.ISO_8859-1
LC_TIME=de_DE.ISO_8859-1
LC_MESSAGES=de_DE.ISO_8859-1
LC_ALL=de_DE.ISO_8859-1
[DEL]
server:/home/mvend[mvend]# 

Without the LC_stuff or with en_US.ISO8859-1, i can't use the german
umlaut. With de_DE.ISO_8859-1 i can use the german umlaut (äöüß). It
seems me, i have set the locale stuff right.

 
> Try this sometime. It sets MiniVend's locale to that as the default,
> and automatically brings in the POSIX currency settings defined in
> the locale distribution. It should also cause sorting and searching
> to be correct for that locale.
> 
> Be careful -- the last one pertains, or the one that is specified
> as "default" in LocaleDatabase (locale.asc in the demo).
> 
> Now the big question at hand is this:
> 
> 	Should [setlocale foo] cause sorting and collation to change?

I have little trouble to sort the items. I have 

<FORM ACTION="[process-target main]" METHOD=POST><INPUT TYPE=hidden NAME=mv_search_map VALUE="
                               mv_searchspec=search12
                               mv_searchspec=search14
                               mv_searchspec=search1
                               mv_searchspec=search11">
                               <INPUT TYPE=hidden NAME=mv_search_field Value="author">
                               <INPUT TYPE=hidden NAME=mv_search_field Value="title">
                               <INPUT TYPE=hidden NAME=mv_search_field Value="0">
                               <INPUT TYPE=hidden NAME=mv_search_field Value="verlag">

and

        <SELECT NAME="mv_sort_field">
        <OPTION VALUE="title:f" SELECTED>[L]Title[/L] 
        <OPTION VALUE="author:f">[L]Author[/L]
        <OPTION VALUE="price:n">[L]Price[/L]
        <OPTION VALUE="title:r">[L]Reverse Title[/L]
        <OPTION VALUE="author:r">[L]Reverse Author[/L]
        <OPTION VALUE="price:nr">[L]Reverse Price[/L]
        <OPTION VALUE="">[L]none[/L]
        </SELECT>


in my srchform page. I try to find "Kind" (child) with Sorting by title
and i get this:


No.	title                              
1	Aggressivität im Kindesalter und Jugendalter
2	'Lehrstunden' eines blinden Kindes
3	Artikulationstherapie bei Vorschulkindern
4	Arbeitshilfen zur Planung der Arbeit im Kindergarten
5	Alltag der Schulkinder
6	Arbeitsfeld Kindergarten

The same with sorting by author:

No.	author
1    Axline, Virginia M.
2    Akpinar, Ünal; Lopez- Blasco, Andres; Vink, Jan
3    Beate Schuster
4    Baumgartner, Stephan; Füssenich, Iris
5    Barthelmes, Jürgen; Feil, Christine; Furtner- Kallmünzer, Maria
6    Andres, Beate; Dippelhofer-Stiem, Barbara
7    Aufn. v. Billhardt, Thomas


The same with sorting by price:

No.	price
1       Preis: DM 14,80  
2       Preis: DM 12,50  
3       Preis: DM 14,80  
4       Preis: DM 14,80  
5       Preis: DM 15,00  
6       Preis: DM 14,80  
7       Preis: DM 14,80  
8       Preis: DM 8,00 

> 
> I am not sure it should; this could cause some real problems, some
> very nasty and gnarly ones. Even with the wonderful "use locale" capability
> of Perl, it will be hard to track what needs be done.
> 
> I need input on all of this -- while I have tried very hard to 
> make MiniVend an international piece of software, I need your help.
> I live in the still-very-monocultural United States.
 
I am not sure, which input you need. MV is great and i like MV (Thank
you a lot for this fine program!) I want to help you and i want to
prop/support you. Maybe you have or create another little perl code to
test the sorting order, uppercase and lowercase with a little
products.asc (created by the user self) without minivend? I think it
will help us to test, if something is wrong with OS, with perl, with t
he setting of locale or with minivend.

Can you suggest me, how can i prop/support you?

Sorry for my bad english!

Joachim

BTW: I have call a FreeBSD guru to help me with the trouble of locale!

-- 
Hans-Joachim Leidinger
buch online                 jojo@buchonline.net
Munscheidstr. 14            FAX: +49 209 1971449
45886 Gelsenkirchen