Informix Dynamic server - how to se Croatian language characters

Hi, Im Informix noob, who needs to enable Croatian language to work fine inside Informix (yeey). I got DS 9.40v T1, everything works fine. I figured that I need to download language pack. I dowloaded International Language suplement, version 340 ( newest). I run setup.exe, run GLS setup, choose GLS locales, found Serbo-Croatian, selected all codepages (852,8859-2,1250,utf8), Under "CODE SET CONVERSION FILES" I didnt know what to choose so I didnt choose anything, under "OS EQUIVALENT LOCALES" I didnt have anything wise to choose so I clicked finish, he said that he put files in gls\\lc11\\sh_hr\\.... So I installed only GLS locales. I also figured that I need to modify my ol_test.cmd file, but I got no clue what to put for variables so I put (by some common logic looking at original US file) : set INFORMIXDIR=C:\\PROGRA~1\\Informix set INFORMIXSERVER=ol_test set ONCONFIG=ONCONFIG.ol_test set PATH=C:\\PROGRA~1\\Informix\\bin;%PATH%set CLASSPATH=%INFORMIXDIR%\\extend\\krakatoa\\krakatoa.jar;%INFORMIXDIR%\\extend\\krakatoa\\jdbc.jar;%CLASSPATH% set DBTEMP=C:\\PROGRA~1\\Informix\\infxtmp set CLIENT_LOCALE=sh_hr.CP1250 set DB_LOCALE=sh_hr.8859-2set SERVER_LOCALE=sh_hr.CP1250 set DBLANG=sh_hr.CP1250 mode con codepage select=852 Now I got very big problem because I dont know is this ok or not. First of all I dont know how to put data inside table ( i know how to use dbacces to crate table but dont know how to put data) so Im using Aqua Data Studio 4.5.2 to import some data inside table I created. Im using 1250 standard to import, but when I select * from ttt; using dbaccess Im not seeing Croatian characters but some crap. Maybe this is ok but because I didnt set ol_test.cmd properly so I cannot see it right. Please help me and tell me is my ol_test.cmd file set correcty or am I missing something. thank you very much!

Bok, One thing you should check is what DB_LOCALE is set to on the server. Look in the registry at HKEY_LOCAL_MACHINE/Software/Informix/Online/ol_test/Environment and check the server environment variables match up with your ol_test.cmd file, and make sure however you're inserting the data (if you can create a table but you're not sure how to insert data with dbaccess look up INSERT and LOAD in the Informix Guide to SQL) you set the locale variables to match the server. Guy Hisoka wrote: > Hi, > Im Informix noob, who needs to enable Croatian language to work fine inside > Informix (yeey). > I got DS 9.40v T1, everything works fine. I figured that I need to download > language pack. > I dowloaded International Language suplement, version 340 ( newest). > I run setup.exe, run GLS setup, choose GLS locales, found Serbo-Croatian, > selected all codepages (852,8859-2,1250,utf8), > Under "CODE SET CONVERSION FILES" I didnt know what to choose so I didnt > choose anything, under "OS EQUIVALENT LOCALES" I didnt have anything wise to > choose so I clicked finish, he said that he put files in gls\\lc11\\sh_hr\\.... > So I installed only GLS locales. > I also figured that I need to modify my ol_test.cmd file, but I got no clue > what to put for variables so I put (by some common logic looking at original > US file) : > > set INFORMIXDIR=C:\\PROGRA~1\\Informix > set INFORMIXSERVER=ol_test > set ONCONFIG=ONCONFIG.ol_test > set PATH=C:\\PROGRA~1\\Informix\\bin;%PATH%> set > CLASSPATH=%INFORMIXDIR%\\extend\\krakatoa\\krakatoa.jar;%INFORMIXDIR%\\extend\\krakatoa\\jdbc.jar;%CLASSPATH% > set DBTEMP=C:\\PROGRA~1\\Informix\\infxtmp > set CLIENT_LOCALE=sh_hr.CP1250 > set DB_LOCALE=sh_hr.8859-2> set SERVER_LOCALE=sh_hr.CP1250 > set DBLANG=sh_hr.CP1250 > mode con codepage select=852 > > Now I got very big problem because I dont know is this ok or not. First of > all I dont know how to put data inside table ( i know how to use dbacces to > crate table but dont know how to put data) so Im using Aqua Data Studio > 4.5.2 to import some data inside table I created. Im using 1250 standard to > import, but when I select * from ttt; using dbaccess Im not seeing Croatian > characters but some crap. Maybe this is ok but because I didnt set > ol_test.cmd properly so I cannot see it right. > > Please help me and tell me is my ol_test.cmd file set correcty or am I > missing something. > > > thank you very much! > > > > > >

Hi & tnx for reply but I need more help I guess.... I checked registry and settings there are : client locale : en_us.cp1252 db_locale : en_us.8859-1 dblang:en_us.cp1252 .... So everything is english. You suggest to change those values with my values, that match my country settings. Well the problem is that Im not sure are my values correct, I dont know what exacty to put there because I cannot find it documented anywhere. I need someone to verify what I wrote in my first post. But thank you for pointing me to informix env varibales inside registry!!! I will try to put my values but I doubt they are correct... regards "Guy Bowerman" <gbowerman@yahoo.com> wrote in message news:xdMhg.6259$td6.4714@trnddc02... > Bok, One thing you should check is what DB_LOCALE is set to on the server. > Look in the registry at > HKEY_LOCAL_MACHINE/Software/Informix/Online/ol_test/Environment and check > the server environment variables match up with your ol_test.cmd file, and > make sure however you're inserting the data (if you can create a table but > you're not sure how to insert data with dbaccess look up INSERT and LOAD > in the Informix Guide to SQL) you set the locale variables to match the > server. > > Guy > > Hisoka wrote: >> Hi, >> Im Informix noob, who needs to enable Croatian language to work fine >> inside Informix (yeey). >> I got DS 9.40v T1, everything works fine. I figured that I need to >> download language pack. >> I dowloaded International Language suplement, version 340 ( newest). >> I run setup.exe, run GLS setup, choose GLS locales, found Serbo-Croatian, >> selected all codepages (852,8859-2,1250,utf8), >> Under "CODE SET CONVERSION FILES" I didnt know what to choose so I didnt >> choose anything, under "OS EQUIVALENT LOCALES" I didnt have anything wise >> to choose so I clicked finish, he said that he put files in >> gls\\lc11\\sh_hr\\.... So I installed only GLS locales. >> I also figured that I need to modify my ol_test.cmd file, but I got no >> clue what to put for variables so I put (by some common logic looking at >> original US file) : >> >> set INFORMIXDIR=C:\\PROGRA~1\\Informix >> set INFORMIXSERVER=ol_test >> set ONCONFIG=ONCONFIG.ol_test >> set PATH=C:\\PROGRA~1\\Informix\\bin;%PATH%>> set >> CLASSPATH=%INFORMIXDIR%\\extend\\krakatoa\\krakatoa.jar;%INFORMIXDIR%\\extend\\krakatoa\\jdbc.jar;%CLASSPATH% >> set DBTEMP=C:\\PROGRA~1\\Informix\\infxtmp >> set CLIENT_LOCALE=sh_hr.CP1250 >> set DB_LOCALE=sh_hr.8859-2>> set SERVER_LOCALE=sh_hr.CP1250 >> set DBLANG=sh_hr.CP1250 >> mode con codepage select=852 >> >> Now I got very big problem because I dont know is this ok or not. First >> of all I dont know how to put data inside table ( i know how to use >> dbacces to crate table but dont know how to put data) so Im using Aqua >> Data Studio 4.5.2 to import some data inside table I created. Im using >> 1250 standard to import, but when I select * from ttt; using dbaccess Im >> not seeing Croatian characters but some crap. Maybe this is ok but >> because I didnt set ol_test.cmd properly so I cannot see it right. >> >> Please help me and tell me is my ol_test.cmd file set correcty or am I >> missing something. >> >> >> thank you very much! >> >> >> >> >>

Hisoka wrote: > Hi & tnx for reply but I need more help I guess.... > > I checked registry and settings there are : > client locale : en_us.cp1252 > db_locale : en_us.8859-1 > dblang:en_us.cp1252 > .... > So everything is english. You suggest to change those values with my values, > that match my country settings. > Well the problem is that Im not sure are my values correct, I dont know what > exacty to put there because I cannot find it documented anywhere. I need > someone to verify what I wrote in my first post. > But thank you for pointing me to informix env varibales inside registry!!! I > will try to put my values but I doubt they are correct... > > regards > > > > > "Guy Bowerman" <gbowerman@yahoo.com> wrote in message > news:xdMhg.6259$td6.4714@trnddc02... > > Bok, One thing you should check is what DB_LOCALE is set to on the server. > > Look in the registry at > > HKEY_LOCAL_MACHINE/Software/Informix/Online/ol_test/Environment and check > > the server environment variables match up with your ol_test.cmd file, and > > make sure however you're inserting the data (if you can create a table but > > you're not sure how to insert data with dbaccess look up INSERT and LOAD > > in the Informix Guide to SQL) you set the locale variables to match the > > server. > > > > Guy > > > > Hisoka wrote: > >> Hi, > >> Im Informix noob, who needs to enable Croatian language to work fine > >> inside Informix (yeey). > >> I got DS 9.40v T1, everything works fine. I figured that I need to > >> download language pack. > >> I dowloaded International Language suplement, version 340 ( newest). > >> I run setup.exe, run GLS setup, choose GLS locales, found Serbo-Croatian, > >> selected all codepages (852,8859-2,1250,utf8), > >> Under "CODE SET CONVERSION FILES" I didnt know what to choose so I didnt > >> choose anything, under "OS EQUIVALENT LOCALES" I didnt have anything wise > >> to choose so I clicked finish, he said that he put files in > >> gls\\lc11\\sh_hr\\.... So I installed only GLS locales. > >> I also figured that I need to modify my ol_test.cmd file, but I got no > >> clue what to put for variables so I put (by some common logic looking at > >> original US file) : > >> > >> set INFORMIXDIR=C:\\PROGRA~1\\Informix > >> set INFORMIXSERVER=ol_test > >> set ONCONFIG=ONCONFIG.ol_test > >> set PATH=C:\\PROGRA~1\\Informix\\bin;%PATH%> >> set > >> CLASSPATH=%INFORMIXDIR%\\extend\\krakatoa\\krakatoa.jar;%INFORMIXDIR%\\extend\\krakatoa\\jdbc.jar;%CLASSPATH% > >> set DBTEMP=C:\\PROGRA~1\\Informix\\infxtmp > >> set CLIENT_LOCALE=sh_hr.CP1250 > >> set DB_LOCALE=sh_hr.8859-2> >> set SERVER_LOCALE=sh_hr.CP1250 > >> set DBLANG=sh_hr.CP1250 > >> mode con codepage select=852 > >> > >> Now I got very big problem because I dont know is this ok or not. First > >> of all I dont know how to put data inside table ( i know how to use > >> dbacces to crate table but dont know how to put data) so Im using Aqua > >> Data Studio 4.5.2 to import some data inside table I created. Im using > >> 1250 standard to import, but when I select * from ttt; using dbaccess Im > >> not seeing Croatian characters but some crap. Maybe this is ok but > >> because I didnt set ol_test.cmd properly so I cannot see it right. > >> > >> Please help me and tell me is my ol_test.cmd file set correcty or am I > >> missing something. > >> > >> > >> thank you very much! > >> > >> > >> > >> > >> hello, your environment seems good. put DB_LOCALE, SERVER_LOCALE, CLIENT_LOCALE as environment variables in system ->advanced tab then start ids service or launch ol_xxxx.cmd and start /b oninit as informix. to see the right characters in dbaccess right clic on the window title ->properties->font and choose lucida console. regards,

vomaringo@yahoo.com wrote: > your environment seems good. > put DB_LOCALE, SERVER_LOCALE, CLIENT_LOCALE as environment variables > in system ->advanced tab then start ids service or launch ol_xxxx.cmd > and start /b oninit as informix. If you start IDS with: start /b oninit I guess it has the advantage of giving you a UNIX look and feel, but the oninit process will not get its environment variables from the HKEY_LOCAL_MACHINE/Software/Informix/Online/ol_test/Environment key when you do this. Instead it will get them from the user's environment - maybe some people prefer that. It also has the disadvantage that you need to log on to the console as informix or use runas or ixsu to start a command window as informix. The recommended and documented way to start IDS on Windows is to start the service with the starts utility, e.g.: starts ol_test or use an OS command to start the service like: net start ol_test Then you don't need to set your environment or become informix. Guy vomaringo@yahoo.com wrote: > Hisoka wrote: >> Hi & tnx for reply but I need more help I guess.... >> >> I checked registry and settings there are : >> client locale : en_us.cp1252 >> db_locale : en_us.8859-1 >> dblang:en_us.cp1252 >> .... >> So everything is english. You suggest to change those values with my values, >> that match my country settings. >> Well the problem is that Im not sure are my values correct, I dont know what >> exacty to put there because I cannot find it documented anywhere. I need >> someone to verify what I wrote in my first post. >> But thank you for pointing me to informix env varibales inside registry!!! I >> will try to put my values but I doubt they are correct... >> >> regards >> >> >> >> >> "Guy Bowerman" <gbowerman@yahoo.com> wrote in message >> news:xdMhg.6259$td6.4714@trnddc02... >>> Bok, One thing you should check is what DB_LOCALE is set to on the server. >>> Look in the registry at >>> HKEY_LOCAL_MACHINE/Software/Informix/Online/ol_test/Environment and check >>> the server environment variables match up with your ol_test.cmd file, and >>> make sure however you're inserting the data (if you can create a table but >>> you're not sure how to insert data with dbaccess look up INSERT and LOAD >>> in the Informix Guide to SQL) you set the locale variables to match the >>> server. >>> >>> Guy >>> >>> Hisoka wrote: >>>> Hi, >>>> Im Informix noob, who needs to enable Croatian language to work fine >>>> inside Informix (yeey). >>>> I got DS 9.40v T1, everything works fine. I figured that I need to >>>> download language pack. >>>> I dowloaded International Language suplement, version 340 ( newest). >>>> I run setup.exe, run GLS setup, choose GLS locales, found Serbo-Croatian, >>>> selected all codepages (852,8859-2,1250,utf8), >>>> Under "CODE SET CONVERSION FILES" I didnt know what to choose so I didnt >>>> choose anything, under "OS EQUIVALENT LOCALES" I didnt have anything wise >>>> to choose so I clicked finish, he said that he put files in >>>> gls\\lc11\\sh_hr\\.... So I installed only GLS locales. >>>> I also figured that I need to modify my ol_test.cmd file, but I got no >>>> clue what to put for variables so I put (by some common logic looking at >>>> original US file) : >>>> >>>> set INFORMIXDIR=C:\\PROGRA~1\\Informix >>>> set INFORMIXSERVER=ol_test >>>> set ONCONFIG=ONCONFIG.ol_test >>>> set PATH=C:\\PROGRA~1\\Informix\\bin;%PATH%>>>> set >>>> CLASSPATH=%INFORMIXDIR%\\extend\\krakatoa\\krakatoa.jar;%INFORMIXDIR%\\extend\\krakatoa\\jdbc.jar;%CLASSPATH% >>>> set DBTEMP=C:\\PROGRA~1\\Informix\\infxtmp >>>> set CLIENT_LOCALE=sh_hr.CP1250 >>>> set DB_LOCALE=sh_hr.8859-2>>>> set SERVER_LOCALE=sh_hr.CP1250 >>>> set DBLANG=sh_hr.CP1250 >>>> mode con codepage select=852 >>>> >>>> Now I got very big problem because I dont know is this ok or not. First >>>> of all I dont know how to put data inside table ( i know how to use >>>> dbacces to crate table but dont know how to put data) so Im using Aqua >>>> Data Studio 4.5.2 to import some data inside table I created. Im using >>>> 1250 standard to import, but when I select * from ttt; using dbaccess Im >>>> not seeing Croatian characters but some crap. Maybe this is ok but >>>> because I didnt set ol_test.cmd properly so I cannot see it right. >>>> >>>> Please help me and tell me is my ol_test.cmd file set correcty or am I >>>> missing something. >>>> >>>> >>>> thank you very much! >>>> >>>> >>>> >>>> >>>> > hello, > > your environment seems good. > put DB_LOCALE, SERVER_LOCALE, CLIENT_LOCALE as environment variables in > system ->advanced tab then start ids service or launch ol_xxxx.cmd and > start /b oninit as informix. > to see the right characters in dbaccess right clic on the window title > ->properties->font and choose lucida console. > regards, >