Re: Informix Dynamic server - how to se Croatian language characters

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!






.

Relevant Pages

  • Re: no emails in exchange activesync
    ... > Rich R wrote: ... >> didnt have active or background scanning enabled on the private store. ... then check the following registry key exists on the server ...
    (microsoft.public.windows.server.sbs)
  • Re: ipf and ipnat stopped working, no routing between nics.
    ... But no, I didnt check that. ... And after I was looking at some sysctls ... ran ettercap on the server to diagnose why our servers wouldnt link. ... Launch ettercap again and exit "cleanly" after telling it to stop sniffing. ...
    (freebsd-questions)
  • RE: OWA problems after installing exchange 2003 sp1
    ... Actually in the 2nd post i stated server could not be found that was ... because the workstation i setup didnt have the correct dns server, ...
    (microsoft.public.exchange.setup)