SEO

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!

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!
>
>
>
>
>
>

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!
>>
>>
>>
>>
>>

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,

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.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,
>