Kylix, ZeosDBO and PostgreSQL

amos · Post by **amos** » 13.10.2005, 20:34

Hello

I searched, and searched but i can't find solution...
Problem no.1:
I have postgresql server on gentoo 2005.1, where every thing works.
Programing is done on separate computer with Red Hat 7.2.
There is no problem if i use only us characters, but if i use croatian character (šđčćž - these one

) i get "?" symbol instead of them. If i connect to postgresql with psql, inserting data with croatian letters works fine (those one kylix can't display correctly also!);(server, develop comp and postgresql use latin2) , so i assume that server configuration is ok!
How can i set correct encoding in ZeosDBO and/or Kylix???

Problem no.2:
When i install zeosdbo, it work (almost) fine. But when i close kylix and open it again, it writes:
"can't load package /path/to/myhome/components/zeos/packages/kylix3/bplZComponent.so bplZDbc.so cannot open shared object file: No such file or directory." When i click "yes" kylix loads but without Zeos pallete. Then i need to open bplZComponents and install it. What is the problem. Permission are ok, i checked that first!

Thanks in advance for any help!

P.S. I appologise on my bad english...

--
That's all from Amos Sam

zeljko · Post by **zeljko** » 14.10.2005, 06:54

I searched, and searched but i can't find solution...
Problem no.1:
I have postgresql server on gentoo 2005.1, where every thing works.
Programing is done on separate computer with Red Hat 7.2.
There is no problem if i use only us characters, but if i use croatian character (šđčćž - these one Smile ) i get "?" symbol instead of them. If i connect to postgresql with psql, inserting data with croatian letters works fine (those one kylix can't display correctly also!);(server, develop comp and postgresql use latin2) , so i assume that server configuration is ok!
How can i set correct encoding in ZeosDBO and/or Kylix???

postgresql.conf should contain hr_HR in LC_XX part, db must run with LATIN2 encoding.I'm using same settings for years and everything is fine , even on 8.03 (WinXP, native installation) it uses Latin2 , and works like a charm.

Problem no.2:
When i install zeosdbo, it work (almost) fine. But when i close kylix and open it again, it writes:
"can't load package /path/to/myhome/components/zeos/packages/kylix3/bplZComponent.so bplZDbc.so cannot open shared object file: No such file or directory." When i click "yes" kylix loads but without Zeos pallete. Then i need to open bplZComponents and install it. What is the problem. Permission are ok, i checked that first!

Open install.html and take a look at section 3. (order of components when installing ZEOS).

amos · Post by **amos** » 14.10.2005, 08:27

zeljko wrote:
(cut) db must run with LATIN2 encoding.(cut)

It does contains hr_HR, and initdb was created with hr_HR, but i'm not sure about above. where and how do i set that?
and client_encoding is set to hr_HR !!

Thx

--
That's all from Amos Sam

zeljko · Post by **zeljko** » 14.10.2005, 12:32

client_encoding CANNOT be hr_HR or en_US or similar.
take a look here for proper encodings
http://k12linux.mesd.k12.or.us/docs/pos ... ibyte.html

my databases on linux uses sql_ascii per default, but WinXP db's uses LATIN2, because of multiplatform client apps and letter encodings (yes, I don't use unicode yet).

amos · Post by **amos** » 14.10.2005, 12:48

zeljko wrote:client_encoding CANNOT be hr_HR or en_US or similar.
take a look here for proper encodings
http://k12linux.mesd.k12.or.us/docs/pos ... ibyte.html

my databases on linux uses sql_ascii per default, but WinXP db's uses LATIN2, because of multiplatform client apps and letter encodings (yes, I don't use unicode yet).

Ok, my mistake. I recheked valute and it is latin2. Sorry. I even tried to set a unicode encoding, comment uot whole line, and nothing happened. (At every change I restarted postgresql)!

In my opinion server and client configurations are ok, beacuse as i said, when i remotly connect to postgres with psql client, everything is ok (except lines that i inserted with Zeos&Kylix)!
Is there a way to insert data with sqlquery component with setting correct encoding?
Or maybe is problem with kylix and his unicode support? Do I have any solution if that is the problem?
I didn't tried with lazarus, becuase I don't like it. I mean, it's good but it's too unstable for me to use it!! And i don't wont to program it on windows!!

Thx

--
That's all from Amos Sam

zeljko · Post by **zeljko** » 14.10.2005, 16:40

hm, what is result of command echo $LANG on your machine ??

amos · Post by **amos** » 14.10.2005, 19:30

On postgresql server output is empty single line, on red hat printout is en_US.

amos · Post by **amos** » 15.10.2005, 15:25

i think i'm gona go crazy!!!
I installed delphi on winxp computer and zeos 6.1.5 stable, and it have same problem!!!
Croatian letters are not correctly inserted in database!!

Where is the problem?!? I don't have any more ideas!!

Thx

--
That's all from Amos Sam

aperger · Post by **aperger** » 15.10.2005, 17:56

Hello,

When you create the DB set encoding / characterset!!!

Attila

zeljko · Post by **zeljko** » 16.10.2005, 09:44

On postgresql server output is empty single line, on red hat printout is en_US.

This should be hr_HR so, env vars are not correct on your machines.

amos · Post by **amos** » 16.10.2005, 15:37

aperger wrote: When you create the DB set encoding / characterset!!!
Attila

Yes, I did!

I will try to do like Zeljko said.

amos · Post by **amos** » 16.10.2005, 16:16

OK, i set LANG variable to hr_HR, but it's same!!

zeljko · Post by **zeljko** » 17.10.2005, 13:43

OK, i set LANG variable to hr_HR, but it's same!!

It cannot be the same. I have more than 400 postgresql installations (mostly redhat based) and few debian's, and everything is correct.
Maybe you should drop your db now, and make again initdb ,so it will create template0 and template1 with hr_HR.
I've never seen such problem.