View Single Post

   
  #4 (permalink)  
Old 04-20-2008, 11:18 AM
vomaringo@yahoo.com
 
Posts: n/a
Default Re: Informix Dynamic server - how to se Croatian language characters

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.j ar;%INFORMIXDIR%\extend\krakatoa\jdbc.jar;%CLASSPA TH%
> >> 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,

Reply With Quote