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

Hi Everybody. I have been running IDS 9.3 under Win2K with default locale en_us.8859-1, now i'm expecting to migrate my databases to enable UTF8/Unicode locale, in order to store all data in UTF8/Unicode format. Does Informix support Unicode? I checked with GLS munaul and gls files in gls directory, the only thing related to utf8 and unicode are Filename: lc11/en_us/e005.lco Language: English Territory: United States Code Set: unicode Locale Name: en_us.unicode Filename: lc11/en_us/e01c.lco Language: English Territory: United States Code Set: utf8 Locale Name: en_us.utf8 I tested this as the following I've set CLIENT_LOCALE, DB_LOCALE, SERVER_LOCALE to en_us.UTF8, then i ran SQl statements via SQl edt as the below create database test_utf8 select * from systables where tabid=9 the columns SITE in line GL_COLLATE has value en_us.57372 (57372 means utf8 ) This means that my database test_utf8 is using UTF8 Locale ?, i also tried to create one table inside test_utf8 with clolumns with varchar & nvarchar data type, and then insert characters other than english chars as ký, é.., the statement failed with error megs "An illegal character has been found in the statement", but it's no problem when i use default locale en_us.8859-1 to insert signed semilar chars as above. In other word that it seems like only for english Any experienced about this problem, pls help me to correct it. Best regards Bernard --------------------------------- Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

Hi Bernard, You might want to try setting=20 CLIENT=5FLOCALE=3Den=5Fus.cp1252 DB=5FLOCALE=3Den=5Fus.utf8 and mode con cp select=3D1252 If you are using a cmd shell, I would also suggest not using "Raster=20 Fonts" as they don't seem to display cp1252 characters correctly (i think=20 it is a cp437 font). Good Luck, Gerry forum.subscriber@iiug.org wrote on 03/25/2003 02:40:14 AM: >=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 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, t= hen > 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 mean= s=20 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 your desktop! >=20

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!