Re: GLS
We are using en_us.CP1252@dict with NCHAR, NVARCHAR and
we dont have problem, whats the difference with es_es.8859 ?
Atte.
On 5 Jun 2000, at 11:08, Isidre PONS ROCA wrote:
> En Martin A. Marques va escriure el dia 4 Jun 2000, a les 10:27:
>
> > I need help with GLS support. I have to build a few DBthat will contain
> > strings with spanish characters like the acute vocals and n-tilde.
> > How does GLS work, and how do I set it up?
> >
> > Thanks
> >
> >
> > --
> > "And I'm happy, because you make me feel good, about me." - Melvin Udall
> > -----------------------------------------------------------------
> > Mart'n Marqu's email: martin@math.unl.edu.ar
> > Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> > Administrador de sistemas en math.unl.edu.ar
> > -----------------------------------------------------------------
>
> Put at your environment
>
> DB_LOCALE=es_es.8859-1
> CLIENT_LOCALE=es_es.8859-1>
> To obtain pure GLS suport the CHAR columns must defined as NCHAR but this decrease the system performance
> arround 200%, or more, if this columns are indexded or index-part.
>
>
>
> ---------------------------------------
> Isidre PONS ROCA
> BASE - Gesti' d'Ingressos Locals
> (Diputacio de Tarragona)
> Servei de Sistemes de Informacio
> Av President Lluis Companys 12-C
> 43005 - Tarragona
> SPAIN
> Tel # +34 977 236731
> Fax # +34 977 227302
> http://www.altanet.org
> ipons@dtgna.altanet.org
> ---------------------------------------
"Duran Grande, Jorge" wrote: > > We are using en_us.CP1252@dict with NCHAR, NVARCHAR and > we dont have problem, whats the difference with es_es.8859 ? > > Atte. 8859-1 is the same charset as 819 or 1252. 8859-1 > ISO style 819 > IBM stype 1252 > Microsoft Style If you use en_us as locale, your "order by" statements and indexes will build in us american sort order. also your time and date values will displayed in it's american style (except you use DBDATE or GL_DATETIME, etc) Your @dict mins the style of sorting dict -> dictionary style phone -> phonebook stype Wile