Informix Multi-language support (GLS)

Posted in 2003

Summary

Lloyd asked how to store multi-language (e.g. Japanese, German, French) data in IDS 9.4 on Windows 2000 with DB_LOCALE=en_us.utf8. Gerald Cousins advised setting CLIENT_LOCALE per language/code set at insert time (e.g. ja_jp.sjis, de_de.1252), noting the server needs matching UTF-8 locales installed via the International Language Supplement (ILS 3.30), and that UTF-8 data can be inserted directly with CLIENT_LOCALE=en_us.utf8. He also suggested checking the source page's charset and that display fonts/encoding may cause '?' characters. Lloyd got French data loading but still saw '?' for Shift-JIS Japanese; the thread ends with his follow-up questions unanswered, so no final resolution is recorded. (Several replies were garbled base64.)

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Server Administration, Internationalization & Character Sets, Versions, Editions & End-of-Life

LLOYD — Fri, 05 Dec 2003 13:24:12 — source: IIUG Forums & Mailing Lists

Dear All, I have IDS 9.4 on win, 2000. I want to have multi-language support for my database. I have set my DB_LOCALE variable to en_us.utf8, I also created a new database and a table but cannot proceed further. Now how do i insert multi-language data in it. How do i insert data thru dbaccess and what other settings i need to do to insert data thru client machines. Maybe you people in US/Europe may be in a better position to help me as you might be using more than one language in your database. Please advice... Best Regards, Lloyd

↪ replying to LLOYD

Gerald Cousins — Fri, 05 Dec 2003 16:30:48 — source: IIUG Forums & Mailing Lists

Hi Lloyd, here is the answer I gave you the last time you posed this question, I am not what type (language, code set) of data as an example I have used the windows code set and three random languages set CLIENT_LOCALE to ja_jp.sjis Insert Japanese data set CLIENT_LOCALE to ru_ru.1253 insert Russian data set CLIENT_LOCALE to de_de.1252 insert German data. To use the locale combination DB_LOCALE en_us.utf8 CLIENT_LOCALE de_de.1252 you need to have 3 locales on your server, en_us.utf8, de_de.utf8 and de_de.1252, de_de.utf8 is not installed by default and will need to be installed via the ILS. (International Language Supplement) current version is 3.30. This file would be installed to $INFORMIXDIR/gls/lc11/de_de/e01c.lco (utf8 locales are always called e01c.lco) I want to add if you have data already in the utf8 code set you can set CLIENT_LOCALE to en_us.utf8 and insert the data without reconverting it. Gerry. "LLOYD " <lloyd_s@rediffmail.com> Sent by: forum.subscriber@iiug.org 2003/12/05 ¤W¤È 07:24 To ids@iiug.org cc Subject Informix Multi-language support (GLS) [2298] Dear All, I have IDS 9.4 on win, 2000. I want to have multi-language support for my database. I have set my DB_LOCALE variable to en_us.utf8, I also created a new database and a table but cannot proceed further. Now how do i insert multi-language data in it. How do i insert data thru dbaccess and what other settings i need to do to insert data thru client machines. Maybe you people in US/Europe may be in a better position to help me as you might be using more than one language in your database. Please advice... Best Regards, Lloyd

↪ replying to Gerald Cousins

Obnoxio The Clown — Fri, 05 Dec 2003 18:05:46 — source: IIUG Forums & Mailing Lists

Easy for you to say! -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "Necrophilia means never having to say ... well, anything!" - Captain Pedantic "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco From: "Gerald Cousins " <gcousins@us.ibm.com> > >Hi Lloyd, > >here is the answer I gave you the last time you posed this question, > >I am not what type (language, code set) of data as an example I have used >the windows code set and three random languages > >set CLIENT_LOCALE to ja_jp.sjis> Insert Japanese data >set CLIENT_LOCALE to ru_ru.1253> insert Russian data >set CLIENT_LOCALE to de_de.1252> insert German data. > > >To use the locale combination >DB_LOCALE en_us.utf8 >CLIENT_LOCALE de_de.1252 > >you need to have 3 locales on your server, >en_us.utf8, de_de.utf8 and de_de.1252, >de_de.utf8 is not installed by default and will need to be installed via >the ILS. (International Language Supplement) current version is 3.30. >This file would be installed to $INFORMIXDIR/gls/lc11/de_de/e01c.lco (utf8 > >locales are always called e01c.lco) > >I want to add if you have data already in the utf8 code set you can set >CLIENT_LOCALE to en_us.utf8 and insert the data without reconverting it. > >Gerry. > > > > >"LLOYD " <lloyd_s@rediffmail.com> >Sent by: forum.subscriber@iiug.org >2003/12/05 ¤W¤È 07:24 > >To >ids@iiug.org >cc > >Subject >Informix Multi-language support (GLS) [2298] > > > > > > >Dear All, > >I have IDS 9.4 on win, 2000. I want to have multi-language support for my >database. I have set my DB_LOCALE variable to en_us.utf8, I also created a >new database and a table but cannot proceed further. Now how do i insert >multi-language data in it. How do i insert data thru dbaccess and what >other settings i need to do to insert data thru client machines. Maybe you >people in US/Europe may be in a better position to help me as you might be >using more than one language in your database. Please advice... > >Best Regards, > >Lloyd > _________________________________________________________________ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger

↪ replying to Gerald Cousins

Darrell Murphy — Fri, 05 Dec 2003 18:40:49 — source: IIUG Forums & Mailing Lists

Although I found your choice of a Phoenician dialect not used since the 4th century an interesting way to illustrate multi-language concepts, I'm not sure the general population would decipher your lucid insights in the form presented here. :) Darrell Murphy (rather punchy on a Friday) -----Original Message----- From: Gerald Cousins [mailto:gcousins@us.ibm.com] Sent: Friday, December 05, 2003 11:31 AM To: ids@iiug.org Subject: Re: Informix Multi-language support (GLS) [2300] Hi Lloyd, here is the answer I gave you the last time you posed this question, I am not what type (language, code set) of data as an example I have used the windows code set and three random languages set CLIENT_LOCALE to ja_jp.sjis Insert Japanese data set CLIENT_LOCALE to ru_ru.1253 insert Russian data set CLIENT_LOCALE to de_de.1252 insert German data. To use the locale combination DB_LOCALE en_us.utf8 CLIENT_LOCALE de_de.1252 you need to have 3 locales on your server, en_us.utf8, de_de.utf8 and de_de.1252, de_de.utf8 is not installed by default and will need to be installed via the ILS. (International Language Supplement) current version is 3.30. This file would be installed to $INFORMIXDIR/gls/lc11/de_de/e01c.lco (utf8 locales are always called e01c.lco) I want to add if you have data already in the utf8 code set you can set CLIENT_LOCALE to en_us.utf8 and insert the data without reconverting it. Gerry. "LLOYD " <lloyd_s@rediffmail.com> Sent by: forum.subscriber@iiug.org 2003/12/05 ¤W¤È 07:24 To ids@iiug.org cc Subject Informix Multi-language support (GLS) [2298] Dear All, I have IDS 9.4 on win, 2000. I want to have multi-language support for my database. I have set my DB_LOCALE variable to en_us.utf8, I also created a new database and a table but cannot proceed further. Now how do i insert multi-language data in it. How do i insert data thru dbaccess and what other settings i need to do to insert data thru client machines. Maybe you people in US/Europe may be in a better position to help me as you might be using more than one language in your database. Please advice... Best Regards, Lloyd ------_=_NextPart_001_01C3BB5E.BC484A40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: Informix Multi-language support (GLS) [2300] </TITLE> </HEAD> <BODY> Although I found your choice of a Phoenician dialect = not used since the 4th century an interesting way to illustrate = multi-language concepts, I'm not sure the general population would = decipher your lucid insights in the form presented here.  = :) Darrell Murphy (rather punchy on a Friday)  -----Original Message----- From:   Gerald Cousins  [<A = HREF=3D"mailto:gcousins@us.ibm.com">mailto:gcousins@us.ibm.com</A>] = Sent:   Friday, December 05, 2003 11:31 = AM To:     ids@iiug.org Subject:        = Re: Informix Multi-language support (GLS)   [2300] SGkgTGxveWQsDQoNCmhlcmUgaXMgdGhlIGFuc3dlciBJIGdhdmUgeW91IHRoZSB= sYXN0IHRpbWUg eW91IHBvc2VkIHRoaXMgcXVlc3Rpb24sDQoNCkkgYW0gbm90IHdoYXQgdHlwZSA= obGFuZ3VhZ2Us IGNvZGUgc2V0KSBvZiBkYXRhIGFzIGFuIGV4YW1wbGUgSSBoYXZlIHVzZWQgDQp= 0aGUgd2luZG93 cyBjb2RlIHNldCBhbmQgdGhyZWUgcmFuZG9tIGxhbmd1YWdlcw0KDQpzZXQgQ0x= JRU5UX0xPQ0FM RSB0byBqYV9qcC5zamlzDQogICAgICAgIEluc2VydCBKYXBhbmVzZSBkYXRhDQp= zZXQgQ0xJRU5U X0xPQ0FMRSB0byBydV9ydS4xMjUzDQogICAgICAgIGluc2VydCBSdXNzaWFuIGR= hdGENCnNldCAg Q0xJRU5UX0xPQ0FMRSB0byBkZV9kZS4xMjUyDQogICAgICAgIGluc2VydCBHZXJ= tYW4gZGF0YS4N Cg0KDQpUbyB1c2UgdGhlIGxvY2FsZSBjb21iaW5hdGlvbg0KREJfTE9DQUxFIGV= uX3VzLnV0ZjgN CkNMSUVOVF9MT0NBTEUgZGVfZGUuMTI1Mg0KDQp5b3UgbmVlZCB0byBoYXZlIDM= gbG9jYWxlcyBv biB5b3VyIHNlcnZlciwNCmVuX3VzLnV0ZjgsIGRlX2RlLnV0ZjggYW5kIGRlX2R= lLjEyNTIsDQpk ZV9kZS51dGY4IGlzIG5vdCBpbnN0YWxsZWQgYnkgZGVmYXVsdCBhbmQgd2lsbCB= uZWVkIHRvIGJl IGluc3RhbGxlZCB2aWEgDQp0aGUgSUxTLiAoSW50ZXJuYXRpb25hbCBMYW5ndWF= nZSBTdXBwbGVt ZW50KSBjdXJyZW50IHZlcnNpb24gaXMgMy4zMC4NClRoaXMgZmlsZSB3b3VsZCB= iZSBpbnN0YWxs ZWQgdG8gJElORk9STUlYRElSL2dscy9sYzExL2RlX2RlL2UwMWMubGNvICh1dGY= 4IA0KDQpsb2Nh bGVzIGFyZSBhbHdheXMgY2FsbGVkIGUwMWMubGNvKQ0KDQpJIHdhbnQgdG8gYWR= kIGlmIHlvdSBo YXZlIGRhdGEgYWxyZWFkeSBpbiB0aGUgdXRmOCBjb2RlIHNldCB5b3UgY2FuIHN= ldCANCkNMSUVO VF9MT0NBTEUgdG8gZW5fdXMudXRmOCBhbmQgaW5zZXJ0IHRoZSBkYXRhIHdpdGh= vdXQgcmVjb252 ZXJ0aW5nIGl0Lg0KDQpHZXJyeS4NCg0KDQoNCg0KIkxMT1lEICAiIDxsbG95ZF9= zQHJlZGlmZm1h aWwuY29tPiANClNlbnQgYnk6IGZvcnVtLnN1YnNjcmliZXJAaWl1Zy5vcmcNCjI= wMDMvMTIvMDUg pFekyCAwNzoyNA0KDQpUbw0KaWRzQGlpdWcub3JnDQpjYw0KDQpTdWJqZWN0DQp= JbmZvcm1peCBN dWx0aS1sYW5ndWFnZSBzdXBwb3J0IChHTFMpICBbMjI5OF0NCg0KDQoNCg0KDQo= NCkRlYXIgQWxs LA0KDQpJIGhhdmUgSURTIDkuNCBvbiB3aW4sIDIwMDAuIEkgd2FudCB0byBoYXZ= lIG11bHRpLWxh bmd1YWdlIHN1cHBvcnQgZm9yIG15IA0KZGF0YWJhc2UuIEkgaGF2ZSBzZXQgbXk= gREJfTE9DQUxF IHZhcmlhYmxlIHRvIGVuX3VzLnV0ZjgsIEkgYWxzbyBjcmVhdGVkIGEgDQpuZXc= gZGF0YWJhc2Ug YW5kIGEgdGFibGUgYnV0IGNhbm5vdCBwcm9jZWVkIGZ1cnRoZXIuIE5vdyBob3c= gZG8gaSBpbnNl cnQgDQptdWx0aS1sYW5ndWFnZSBkYXRhIGluIGl0LiBIb3cgZG8gaSBpbnNlcnQ= gZGF0YSB0aHJ1 IGRiYWNjZXNzIGFuZCB3aGF0IA0Kb3RoZXIgc2V0dGluZ3MgaSBuZWVkIHRvIGR= vIHR

↪ replying to Gerald Cousins

Support Informix — Mon, 08 Dec 2003 07:40:28 — source: IIUG Forums & Mailing Lists

Dear ggbkvqopGGGGG:) I GxveWQsDQoNCmhlcmUgaXMgdGhlIGFuc3dlciBJIGdhdmUgeW91IHRoZSBsYXN0IHRpbWUg eW91IHBvc2VkIHRoaXMgcXVlc3Rpb24sDQoNCkkgYW0gbm90IHdoYXQgdHlwZSAobGFuZ3VhZ2Us IGNvZGUgc2V0KSBvZiBkYXRhIGFzIGFuIGV4YW1wbGU Bye -----Original Message----- From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] Sent: 05 December 2003 17:31 To: ids@iiug.org Subject: Re: Informix Multi-language support (GLS) [2300] Hi Lloyd, here is the answer I gave you the last time you posed this question, I am not what type (language, code set) of data as an example I have used the windows code set and three random languages set CLIENT_LOCALE to ja_jp.sjis Insert Japanese data set CLIENT_LOCALE to ru_ru.1253 insert Russian data set CLIENT_LOCALE to de_de.1252 insert German data. To use the locale combination DB_LOCALE en_us.utf8 CLIENT_LOCALE de_de.1252 you need to have 3 locales on your server, en_us.utf8, de_de.utf8 and de_de.1252, de_de.utf8 is not installed by default and will need to be installed via the ILS. (International Language Supplement) current version is 3.30. This file would be installed to $INFORMIXDIR/gls/lc11/de_de/e01c.lco (utf8 locales are always called e01c.lco) I want to add if you have data already in the utf8 code set you can set CLIENT_LOCALE to en_us.utf8 and insert the data without reconverting it. Gerry. "LLOYD " <lloyd_s@rediffmail.com> Sent by: forum.subscriber@iiug.org 2003/12/05 ¤W¤È 07:24 To ids@iiug.org cc Subject Informix Multi-language support (GLS) [2298] Dear All, I have IDS 9.4 on win, 2000. I want to have multi-language support for my database. I have set my DB_LOCALE variable to en_us.utf8, I also created a new database and a table but cannot proceed further. Now how do i insert multi-language data in it. How do i insert data thru dbaccess and what other settings i need to do to insert data thru client machines. Maybe you people in US/Europe may be in a better position to help me as you might be using more than one language in your database. Please advice... Best Regards, Lloyd ------_=_NextPart_001_01C3BD5C.57A248C0 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>RE: Informix Multi-language support (GLS) [2300] </TITLE> </HEAD> <BODY> Dear ggbkvqopGGGGG:) I GxveWQsDQoNCmhlcmUgaXMgdGhlIGFuc3dlciBJIGdhdmUgeW91IHRoZSBsYXN0IHRpbWUg eW91IHBvc2VkIHRoaXMgcXVlc3Rpb24sDQoNCkkgYW0gbm90IHdoYXQgdHlwZSAobGFuZ3VhZ 2Us IGNvZGUgc2V0KSBvZiBkYXRhIGFzIGFuIGV4YW1wbGU Bye -----Original Message----- From: nobody@ace.iiug.org [<A HREF="mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>] Sent: 05 December 2003 17:31 To: ids@iiug.org Subject: Re: Informix Multi-language support (GLS) [2300] SGkgTGxveWQsDQoNCmhlcmUgaXMgdGhlIGFuc3dlciBJIGdhdmUgeW91IHRoZSBsYXN0IHRpb WUg eW91IHBvc2VkIHRoaXMgcXVlc3Rpb24sDQoNCkkgYW0gbm90IHdoYXQgdHlwZSAobGFuZ3VhZ 2Us IGNvZGUgc2V0KSBvZiBkYXRhIGFzIGFuIGV4YW1wbGUgSSBoYXZlIHVzZWQgDQp0aGUgd2luZ G93 cyBjb2RlIHNldCBhbmQgdGhyZWUgcmFuZG9tIGxhbmd1YWdlcw0KDQpzZXQgQ0xJRU5UX0xPQ 0FM RSB0byBqYV9qcC5zamlzDQogICAgICAgIEluc2VydCBKYXBhbmVzZSBkYXRhDQpzZXQgQ0xJR U5U X0xPQ0FMRSB0byBydV9ydS4xMjUzDQogICAgICAgIGluc2VydCBSdXNzaWFuIGRhdGENCnNld CAg Q0xJRU5UX0xPQ0FMRSB0byBkZV9kZS4xMjUyDQogICAgICAgIGluc2VydCBHZXJtYW4gZGF0Y S4N Cg0KDQpUbyB1c2UgdGhlIGxvY2FsZSBjb21iaW5hdGlvbg0KREJfTE9DQUxFIGVuX3VzLnV0Z jgN CkNMSUVOVF9MT0NBTEUgZGVfZGUuMTI1Mg0KDQp5b3UgbmVlZCB0byBoYXZlIDMgbG9jYWxlc yBv biB5b3VyIHNlcnZlciwNCmVuX3VzLnV0ZjgsIGRlX2RlLnV0ZjggYW5kIGRlX2RlLjEyNTIsD Qpk ZV9kZS51dGY4IGlzIG5vdCBpbnN0YWxsZWQgYnkgZGVmYXVsdCBhbmQgd2lsbCBuZWVkIHRvI GJl IGluc3RhbGxlZCB2aWEgDQp0aGUgSUxTLiAoSW50ZXJuYXRpb25hbCBMYW5ndWFnZSBTdXBwb GVt ZW50KSBjdXJyZW50IHZlcnNpb24gaXMgMy4zMC4NClRoaXMgZmlsZSB3b3VsZCBiZSBpbnN0Y Wxs ZWQgdG8gJElORk9STUlYRElSL2dscy9sYzExL2RlX2RlL2UwMWMubGNvICh1dGY4IA0KDQpsb 2Nh bGVzIGFyZSBhbHdheXMgY2FsbGVkIGUwMWMubGNvKQ0KDQpJIHdhbnQgdG8gYWRkIGlmIHlvd SBo YXZlIGRhdGEgYWxyZWFkeSBpbiB0aGUgdXRmOCBjb2RlIHNldCB5b3UgY2FuIHNldCANCkNMS UVO VF9MT0NBTEUgdG8gZW5fdXMudXRmOCBhbmQgaW5zZXJ0IHRoZSBkYXRhIHdpdGhvdXQgcmVjb 252 ZXJ0aW5nIGl0Lg0KDQpHZXJyeS4NCg0KDQoNCg0KIkxMT1lEICAiIDxsbG95ZF9zQHJlZGlmZ m1h aWwuY29tPiANClNlbnQgYnk6IGZvcnVtLnN1YnNjcmliZXJAaWl1Zy5vcmcNCjIwMDMvMTIvM DUg pFekyCAwNzoyNA0KDQpUbw0KaWRzQGlpdWcub3JnDQpjYw0KDQpTdWJqZWN0DQpJbmZvcm1pe CBN dWx0aS1sYW5ndWFnZSBzdXBwb3J0IChHTFMpICBbMjI5OF0NCg0KDQoNCg0KDQoNCkRlYXIgQ Wxs LA0KDQpJIGhhdmUgSURTIDkuNCBvbiB3aW4sIDIwMDAuIEkgd2FudCB0byBoYXZlIG11bHRpL Wxh bmd1YWdlIHN1cHBvcnQgZm9yIG15IA0KZGF0YWJhc2UuIEkgaGF2ZSBzZXQgbXkgREJfTE9DQ UxF IHZhcmlhYmxlIHRvIGVuX3VzLnV0ZjgsIEkgYWxzbyBjcmVhdGVkIGEgDQpuZXcgZGF0YWJhc 2Ug YW5kIGEgdGFibGUgYnV0IGNhbm5vdCBwcm9jZWVkIGZ1cnRoZXIuIE5vdyBob3cgZG8gaSBpb nNl cnQgDQptdWx0aS1sYW5ndWFnZSBkYXRhIGluIGl0LiBIb3cgZG8gaSBpbnNlcnQgZGF0YSB0a HJ1 IGRiYWNjZXNzIGFuZCB3aGF0IA0Kb3RoZXIgc2V0dGluZ3MgaSBuZWVkIHRvIGRvIHRvIGluc 2Vy dCBkYXRhIHRocnUgY2xpZW50IG1hY2hpbmVzLiBNYXliZSB5b3UgDQpwZW9wbGUgaW4gVVMvR XVy b3BlIG1heSBiZSBpbiBhIGJldHRlciBwb3NpdGlvbiB0byBoZWxwIG1lIGFzIHlvdSBtaWdod CBi ZSANCnVzaW5nIG1vcmUgdGhhbiBvbmUgbGFuZ3VhZ2UgaW4geW91ciBkYXRhYmFzZS4gUGxlY XNl

↪ replying to LLOYD

LLOYD — Wed, 10 Dec 2003 03:41:36 — source: IIUG Forums & Mailing Lists

Hi Gerry, Thanks for your feedback, Can you give me the link where i can download ILS 3.0. I did try the steps mentioned by you. Since i did not have the e01c locale file in japanese dir, i copied it from en_us dir. I set my DB_LOCALE=en_us.utf8 and CLIENT_LOCALE=ja_jp.sjis and created a database &table. Then i tried inserting junk data thru 'Alt 171, 172 keys' in to the table, i could, but this works in default setting too. But when i try to insert japanese data, i.e. i tried to copy some data from japanese site and paste it over here, the data comes as "?????????????". I am still not sure whether my database supports multi-lingual data. How do i insert data. I even tried setting both DB_LOCALE & CLIENT_LOCALE to en_us.utf8 as well as ja_jp.sjis, but no luck. Can you please let me know whether i have missed something. Please advice. Also do i have to change my CLIENT_LOCALE again and again if i need to insert some other language. For. eg. In one record i need to insert japanese data, in second german data, and so on. So what would be my setting for DB_LOCALE & CLIENT_LOCALE. Please advice. Best Regards, Lloyd

↪ replying to LLOYD

LLOYD — Wed, 10 Dec 2003 09:54:28 — source: IIUG Forums & Mailing Lists

Hi Gerry, I even download ILS 3.30 from IBM and tried the setting DB_LOCALE & CLIENT_LOCALE to ja_jp.sjis. Now how to insert japanese data into it. I tried to copy/paste from goole but it stores as "????". Please advice. Regards, Lloyd

↪ replying to LLOYD

Gerald Cousins — Wed, 10 Dec 2003 20:54:58 — source: IIUG Forums & Mailing Lists

Hi Lloyd, I can think of two potential causes, One, you inserted the data using an incorrect value of CLIENT_LOCALE. Did you check the code set of the data that you where copying? In IE, Menu option view source, <META HTTP-EQUIV="content-type" CONTENT="text/html;charset=UTF-8"> This indicates the code set of the data. CLIENT_LOCALE should use an equilivant code set. The second cause could be that your application that is displaying the text uses a font that will not support utf8, Unload your data to a text file and view it with IE (after loading the file select the menu option view -> encoding -> UNICODE (utf-8)). Gerry. "LLOYD " <lloyd_s@rediffmail.com> Sent by: forum.subscriber@iiug.org 2003-12-10 03:54 To ids@iiug.org cc Subject Re: Informix Multi-language support (GLS) [2329] Hi Gerry, I even download ILS 3.30 from IBM and tried the setting DB_LOCALE & CLIENT_LOCALE to ja_jp.sjis. Now how to insert japanese data into it. I tried to copy/paste from goole but it stores as "????". Please advice. Regards, Lloyd

↪ replying to Gerald Cousins

LLOYD — Fri, 12 Dec 2003 13:26:00 — source: IIUG Forums & Mailing Lists

Hi Gerry, Thanks for your prompt feedback, I have set both DB_LOCALE & CLIENT_LOCALE to utf8. I could load some french data to my database. Then I tried to load japanense data but they are in shift-jis codeset, when i tried to encode it in unicode format it stores "?????". When i try to change my locales to shift-jis it gives me an error. Then how do i take care of it. Also is it possible to load multi-language data simultenously with locales set to utf8 or i need to set it to their respective locales. For eg. 1 record i need to load in german, the other in french, do i have to change my client_locale again and again or the utf8 codeset will take care of it. I have also downloaded ILS 3.30. How do i proceed further. Please advice. Thanks in advance, have a nice day. Best Regards, Lloyd

Informix Multi-language support (GLS)

Related threads

Glossary

Your privacy choices