IDS Forum

Re: How to change default locale to UTF8 under IDS 9.3 Win2K ?

Posted By:
Date:

Hi Bernard,

Quick test,
Launch the cmd shell that you normally run sql statements in.

hold down the Alt key and in the numeric keypad type 171 (do not use the=20
main keyboard) and release the alt key.
repeat with Alt 172 and Alt 173.

If this displays as 1/2 1/4 and upside-down ! then you font is a OEM font=20
and you should set CLIENT=5FLOCALE to en=5Fus.cp850. and mode con cp=20
select=3D850.

It is possible that neither font supplied by windows for your operating=20
system is going to display cp1252 data correctly.

You can use the same test for the other applications that you use to enter =

and retrieve data to determine the CLIENT=5FLOCALE that you should use for =

that connection to the IDS server.

Let me know if you have further problems.

Gerry.

Kam Bernard <bernard=5Fkam2002@yahoo.com> wrote on 03/26/2003 11:29:11 PM:

> Hi Gerald Cousins,=20
> New locale setting seems better but it still have some problems when
> it could not display correctly some special characters such as =AB, =AC,=
=A8=20
..,
> i supposed that locale en=5Fus.utf8 may be not encoding correctly=20
> these chars ?, thus to display the characters as above, according=20
> you what is underlying locales that support ?.=20
> Best regards.=20
> Bernard.=20
>=20
>=20
> Gerald Cousins <gcousins@us.ibm.com> wrote:=20
>=20
> Hi Bernard,=20
>=20
> You might want to try setting=20
> CLIENT=5FLOCALE=3Den=5Fus.cp1252=20
> DB=5FLOCALE=3Den=5Fus.utf8=20
> and mode con cp select=3D1252=20
>=20
> If you are using a cmd shell, I would also suggest not using "Raster
> Fonts" as they don't seem to display cp1252 characters correctly (i=20
> think it is a cp437 font).=20
>=20
> Good Luck,=20
> Gerry=20
>=20
> forum.subscriber@iiug.org wrote on 03/25/2003 02:40:14 AM:
>=20
> >=20
> > Hi Everybody.
> >=20
> > I have been running IDS 9.3 under Win2K with default locale en=5Fus.
> > 8859-1, now i'm expecting to migrate my databases to enable=20
> > UTF8/Unicode locale, in order to store all data in UTF8/Unicode=20
format.
> >=20
> >=20
> >=20
> > Does Informix support Unicode?
> >=20
> > I checked with GLS munaul and gls files in gls directory,=20
> >=20
> > the only thing related to utf8
> >=20
> > and unicode are
> >=20
> >=20
> >=20
> > Filename: lc11/en=5Fus/e005.lco
> >=20
> > Language: English
> >=20
> > Territory: United States
> >=20
> > Code Set: unicode
> >=20
> > Locale Name: en=5Fus.unicode
> >=20
> > Filename: lc11/en=5Fus/e01c.lco
> >=20
> > Language: English
> >=20
> > Territory: United States
> >=20
> > Code Set: utf8
> >=20
> > Locale Name: en=5Fus.utf8
> >=20
> >=20
> >=20
> > I tested this as the following
> >=20
> > I've set CLIENT=5FLOCALE, DB=5FLOCALE, SERVER=5FLOCALE to en=5Fus.UTF8,=
then
> > i ran SQl statements via SQl edt as the below
> >=20
> > create database test=5Futf8
> >=20
> > select * from systables where tabid=3D9
> >=20
> > the columns SITE in line GL=5FCOLLATE has value en=5Fus.57372 (57372=20
> means utf8 )
> >=20
> > This means that my database test=5Futf8 is using UTF8 Locale ?, i also
> > tried to create one table
> >=20
> > inside test=5Futf8 with clolumns with varchar & nvarchar data type,=20
> > and then insert characters other than english chars as k=FD, =E9.., the=
=20
> > statement failed with error megs "An illegal character has been=20
> > found in the statement", but it's no problem when i use default=20
> > locale en=5Fus.8859-1 to insert signed semilar chars as above.
> >=20
> > In other word that it seems like only for english
> >=20
> > Any experienced about this problem, pls help me to correct it.
> >=20
> > Best regards
> >=20
> > Bernard
> >=20
> >=20
> >=20
> > ---------------------------------
> > Do you Yahoo!?
> > Yahoo! Platinum - Watch CBS' NCAA March Madness, live on yourr=20
desktop!
> >=20
>=20
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

Messages In This Thread

• How to change default locale to UTF8 under IDS 9.3 Win2K ?
  Kam Bernard -- Tuesday, 25 March 2003, at 3:40 a.m.
  • Re: How to change default locale to UTF8 under IDS 9.3 Win2K ?
    Gerald Cousins -- Tuesday, 25 March 2003, at 10:51 a.m.
  • Re: How to change default locale to UTF8 under IDS 9.3 Win2K ?
    Gerald Cousins -- Thursday, 27 March 2003, at 3:43 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.