Informix Dynamic server - how to se Croatian language characters

Informix Dynamic server - how to se Croatian language characters

Post by Hisok » Thu, 08 Jun 2006 23:42:16


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!
 
 
 

Informix Dynamic server - how to se Croatian language characters

Post by Guy Bowerm » Fri, 09 Jun 2006 11:47:57

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

 
 
 

Informix Dynamic server - how to se Croatian language characters

Post by Hisok » Fri, 09 Jun 2006 16:45:21

i & 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" < XXXX@XXXXX.COM > wrote in message
news:xdMhg.6259$td6.4714@trnddc02...

 
 
 

Informix Dynamic server - how to se Croatian language characters

Post by vomaring » Sat, 10 Jun 2006 19:46:18

isoka wrote:
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,

 
 
 

Informix Dynamic server - how to se Croatian language characters

Post by Guy Bowerm » Sun, 11 Jun 2006 08:56:42

XXXX@XXXXX.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

XXXX@XXXXX.COM wrote: