Kylix - Kylix + Firebird + CHARSET=ASCII

Author

Kylix + Firebird + CHARSET=ASCII

Gustavo Agudelo Frias

2005-09-09, 7:04 pm

Hy everyone

I post here because I think the problem involve our ancient Kylix or my
scarce knowledge of GNU/Linux.

I did a very little test with Kylix 3 to access a 3 row table, like this
one:
INSERT INTO APP_CFG (NOMBRE, VALOR) VALUES('TEST01', 'NAME01');
INSERT INTO APP_CFG (NOMBRE, VALOR) VALUES('TEST02', 'LLLLLL');
INSERT INTO APP_CFG (NOMBRE, VALOR) VALUES('TEST03', 'ÑÑÑÑÑÑÑ');

The last row is my problem.

As a side note: If you can't see it, it is the letter that we, Spanish
spoken people, use and English people don't. As in the name of the
language: 'espaÑol'.
ASCII values in decimal: 164 or 165.

I did a console and GUI test to see that field value, but the only thing
that I see in the Kylix IDE while debugging
was:'#$D1#$D1#$D1#$D1#$D1#$D1#$D1'. And the GUI application running only
shows: '???????'.

If anyone have a clue of what I need to configure, please tell me.

The GUI was tested with the components:
FIBPlus
dbExpress
Zeos
IBX
and the console with dbExpress. I think only miss the IBObject beta for
Kylix. I don't have it.

In Delphi7 everything works as expected.

The project can be found here:
http://espanol.f1.pg.briefcase.yahoo.com/ggaaaff
http://espanol.briefcase.yahoo.com/bc/ggaaaff

under the directory PUBLIC. If you can't see it, give me other method and
I gladly send the project to you.

Thanks for the help

Gustavo AF

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Ryan Mills

2005-09-10, 7:02 pm

Hi Gustavo,

I believe that the problem your having with with the character set(s).

Firebird itself controls the character settings not delphi. So when you configure/
create your firebird database you have to expressly tell the database what your
character set for the gdb file is going to be. So I think that you should post this
question over on the Firebird support group as you'll probably find more information
over there.

http://groups.yahoo.com/groups/firebird-support

Or at the very least they should be able to point you in the right direction.

Ryan.

On Fri, 09 Sep 2005 16:53:23 -0500, "Gustavo Agudelo Frias" <GGAAAFF@yahoo.com> wrote:

>
>I post here because I think the problem involve our ancient Kylix or my
>scarce knowledge of GNU/Linux.

<snip>

Gustavo Agudelo Frias

2005-09-12, 7:02 pm

Hy

Thanks Ryan for taking the time to write to me.

Anyone give me a second chance review. For this reason:
I did the test (which I put in Yahoo briefcase) in Kylix 3 that doesn't
show the right charset, but that very same test runs perfectly in Delphi 7.

So this is the reason I post here and not in firebird-support. Besides,
they said in its description:
Questions that pertain to the use of third-party client development tools,
e.g. Delphi, Java, PHP, Python, ODBC, .NET, etc., are not welcome. There
are dedicated lists for these questions.

I KNOW that my question seems very very trivial but I'm with Delphi since
version 3 and the same with Interbase. And then switch to Firebird. So
I've been using DB components a long time in windows. And now for 4 months
I've been playing in Linux with the same distro (Redhat9) and this problem
have just arise.

Thanks for read

Gustavo Agudelo Frias

2005-09-15, 7:04 pm

PROBLEM SOLVED

Just add the line:
export LANG=es_ES

To the script that start the Delphi IDE in Kylix:
/kylix3/bin/startdelphi

I found what was happening because I started the script in console mode
and there it complain in this way:
[root@GAAF-RH9 root]# /usr/local/kylix3/bin/startdelphi
For language 'es_ES.UTF-8' several language ids were found:
es_ES - 040A; es_ES - 0C0A;
Instead of using the first entry in the list, it is suggested that you
define your LANG environment variable like this: LANG=es_ES

Thanks a lot to the people that let that warning message float to the
surface. :-)

Bye.

--

Gustavo AF
Cartagena de Indias, Colombia.

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Sponsored Links