Problem with displaying Spanish names ... please h
User reported Spanish characters displaying incorrectly in dbaccess despite showing fine in SQL Server Management Studio. Setting DB_LOCALE=es_es.8859-1 alone didn't work. Suggestions included setting all three locale variables: SERVER_LOCALE, CLIENT_LOCALE, and DB_LOCALE to Spanish encodings (es_es.8859-1 or es_ES.819). No final confirmation of resolution provided in thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
My customer queries a table in MSSQL Server Management Studio (Windows) which
returns a Spanish name, and it appears OK. But when she runs the same query
from dbaccess, part of that Spanish name now shows "special" characters which
she cannot read well. What do you do to fix this in dbaccess? Does it involve
with setting the environment for that dbaccess session with DB_LOCALE variable
or something? and how?
Thank you.
Its difficult to know as you are using a windows cmd window and= it
depends on the font used,
It's been a good long time since I = worked with a Spanish version of
windows, but you could try,
=
Try
mode con cp select=3D1252
set CLIE= NT=5FLOCALE=3Des=5Fes.cp1252
run query,
= mode con cp select=3D850
set CLIENT=5FLOCALE=3Des=5Fes.850
<= div>Run query.
Also how was the data inserted into= the database?
is There a specific character that you where expec= ting and what did
you get.
-----ids-bounces@iiug.org wrote: -----
To: ids@iiug.org
From: "Kern Doe"
Sent by: ids-bounces@iiug.org
Date: 02/15/2013 11:51AM
Subj= ect: Problem with displaying Spanish names ... plea.... [29518]
My customer queri= es a table in MSSQL Server Management Studio
(Windows) which
returns a = Spanish name, and it appears OK. But when she runs the
same query
from = dbaccess, part of that Spanish name now shows "special"
characters which she cannot read well. What do you do to fix this in
dbaccess? Does it inv= olve
with setting the environment for that dbaccess session with DB=5FL=
OCALE variable
or something? and how?
Thank you.
******=
**********************************************************************
*** <= br> Forum Note: Use "Reply" to post a response in the
discussion= forum.
=
In my own experience, you must set the environment variable SERVER_LOCALE and
DB_LOCALE.
The last one must set the spanish locale, and the SERVER_LOCALE must set to a
destination locale. CLIENT_LOCALE doesn't not apply to the dbaccess program.
Regards.
Francisco Gaspar López
Dtor. Tecnología
SISTEL
Servicios Informáticos de Software y Telecomunicaciones
Avd. Los Jarales, 4 (03010) ALICANTE
Tlf. 965930080 - Fax. 901021558
http://www.sistel.es/
Por favor recuerda tu responsabilidad medioambiental antes de imprimir este
e-mail. / Please consider your environmental responsibility before printing
this e-mail.
----- Mensaje original -----
De: "Kern Doe" <kern_doe@yahoo.com>
Para: ids@iiug.org
Enviados: Viernes, 15 de Febrero 2013 18:48:54
Asunto: Problem with displaying Spanish names ... plea.... [29518]
My customer queries a table in MSSQL Server Management Studio (Windows) which
returns a Spanish name, and it appears OK. But when she runs the same query
from dbaccess, part of that Spanish name now shows "special" characters which
she cannot read well. What do you do to fix this in dbaccess? Does it involve
with setting the environment for that dbaccess session with DB_LOCALE variable
or something? and how?
Thank you.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Again, my customer displays the column fine with her SQL Server Management
Studio, but we cannotdisplay correctly with dbaccess --> Banco Ita£ BBA S.A.
and when I unload this field to a file, this is how it looks --> Banco Ita\\\\243
BBA S.A.
I set: export DB_LOCALE=es_es.8859-1
then run dbaccess, but it still doesn't work!!!
Thank you for your help in advance.
Kern --
________________________________
From: Francisco Gaspar López <pgaspar@sistel.es>
To: ids@iiug.org
Sent: Saturday, February 16, 2013 9:30 AM
Subject: Re: Problem with displaying Spanish names ... .... [29521]
In my own experience, you must set the environment variable SERVER_LOCALE and
DB_LOCALE.
The last one must set the spanish locale, and the SERVER_LOCALE must set to a
destination locale. CLIENT_LOCALE doesn't not apply to the dbaccess program.
Regards.
Francisco Gaspar López
Dtor. Tecnología
SISTEL
Servicios Informáticos de Software y Telecomunicaciones
Avd. Los Jarales, 4 (03010) ALICANTE
Tlf. 965930080 - Fax. 901021558
http://www.sistel.es/
Por favor recuerda tu responsabilidad medioambiental antes de imprimir este
e-mail. / Please consider your environmental responsibility before printing
this e-mail.
----- Mensaje original -----
De: "Kern Doe" <kern_doe@yahoo.com>
Para: ids@iiug.org
Enviados: Viernes, 15 de Febrero 2013 18:48:54
Asunto: Problem with displaying Spanish names ... plea.... [29518]
My customer queries a table in MSSQL Server Management Studio (Windows) which
returns a Spanish name, and it appears OK. But when she runs the same query
from dbaccess, part of that Spanish name now shows "special" characters which
she cannot read well. What do you do to fix this in dbaccess? Does it involve
with setting the environment for that dbaccess session with DB_LOCALE variable
or something? and how?
Thank you.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Are you sourcing all three of these environment variables prior to running the
dbaccess command?
export DB_LOCALE=es_es.8859-1
export CLIENT_LOCALE=es_es.8859-1export SERVER_LOCALE=es_es.8859-1
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe
Sent: Tuesday, February 19, 2013 2:21 PM
To: ids@iiug.org
Subject: NOT RESOLVED!!! Re: Problem with displaying Sp.... [29533]
Again, my customer displays the column fine with her SQL Server Management
Studio, but we cannotdisplay correctly with dbaccess --> Banco Ita£ BBA S.A.
and when I unload this field to a file, this is how it looks --> Banco Ita\\\\243
BBA S.A.
I set: export DB_LOCALE=es_es.8859-1
then run dbaccess, but it still doesn't work!!!
Thank you for your help in advance.
Kern --
________________________________
From: Francisco Gaspar López <pgaspar@sistel.es>
To: ids@iiug.org
Sent: Saturday, February 16, 2013 9:30 AM
Subject: Re: Problem with displaying Spanish names ... .... [29521]
In my own experience, you must set the environment variable SERVER_LOCALE and
DB_LOCALE.
The last one must set the spanish locale, and the SERVER_LOCALE must set to a
destination locale. CLIENT_LOCALE doesn't not apply to the dbaccess program.
Regards.
Francisco Gaspar López
Dtor. Tecnología
SISTEL
Servicios Informáticos de Software y Telecomunicaciones Avd. Los Jarales, 4
(03010) ALICANTE
Tlf. 965930080 - Fax. 901021558
http://www.sistel.es/
Por favor recuerda tu responsabilidad medioambiental antes de imprimir este
e-mail. / Please consider your environmental responsibility before printing
this e-mail.
----- Mensaje original -----
De: "Kern Doe" <kern_doe@yahoo.com>
Para: ids@iiug.org
Enviados: Viernes, 15 de Febrero 2013 18:48:54
Asunto: Problem with displaying Spanish names ... plea.... [29518]
My customer queries a table in MSSQL Server Management Studio (Windows) which
returns a Spanish name, and it appears OK. But when she runs the same query
from dbaccess, part of that Spanish name now shows "special" characters which
she cannot read well. What do you do to fix this in dbaccess? Does it involve
with setting the environment for that dbaccess session with DB_LOCALE variable
or something? and how?
Thank you.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
try this:SERVER_LOCALE=es_es.8859-1
CLIENT_LOCALE=es_ES.819
DB_LOCALE=es_es.8859-1> To: ids@iiug.org
> From: kern_doe@yahoo.com
> Subject: NOT RESOLVED!!! Re: Problem with displaying Sp.... [29533]
> Date: Tue, 19 Feb 2013 15:20:39 -0500
>
> Again, my customer displays the column fine with her SQL Server Management
> Studio, but we cannotdisplay correctly with dbaccess --> Banco Ita£ BBA S.A.
> and when I unload this field to a file, this is how it looks --> Banco
Ita\\\\243
> BBA S.A.
>
> I set: export DB_LOCALE=es_es.8859-1
> then run dbaccess, but it still doesn't work!!!
>
> Thank you for your help in advance.
> Kern --
>
> ________________________________
> From: Francisco Gaspar López <pgaspar@sistel.es>
> To: ids@iiug.org
> Sent: Saturday, February 16, 2013 9:30 AM
> Subject: Re: Problem with displaying Spanish names ... .... [29521]
>
> In my own experience, you must set the environment variable SERVER_LOCALE and
> DB_LOCALE.
>
> The last one must set the spanish locale, and the SERVER_LOCALE must set to a
> destination locale. CLIENT_LOCALE doesn't not apply to the dbaccess program.
>
> Regards.
>
> Francisco Gaspar López
> Dtor. Tecnología
>
> SISTEL
>
> Servicios Informáticos de Software y Telecomunicaciones
> Avd. Los Jarales, 4 (03010) ALICANTE
>
> Tlf. 965930080 - Fax. 901021558
> http://www.sistel.es/
>
> Por favor recuerda tu responsabilidad medioambiental antes de imprimir este
> e-mail. / Please consider your environmental responsibility before printing
> this e-mail.
>
> ----- Mensaje original -----
>
> De: "Kern Doe" <kern_doe@yahoo.com>
> Para: ids@iiug.org
> Enviados: Viernes, 15 de Febrero 2013 18:48:54
> Asunto: Problem with displaying Spanish names ... plea.... [29518]
>
> My customer queries a table in MSSQL Server Management Studio (Windows) which
> returns a Spanish name, and it appears OK. But when she runs the same query
> from dbaccess, part of that Spanish name now shows "special" characters which
> she cannot read well. What do you do to fix this in dbaccess? Does it involve
> with setting the environment for that dbaccess session with DB_LOCALE
variable
> or something? and how?
> Thank you.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>