iBase.ru Forum

Firebird 1. How to be able to enter Russian characters from Delphi programs?

Firebird is installed with default options. I have not set any language for database. I tried command DEFAULT CHARACTER SET UNICODE_FSS
but it gave error message.

so I added a field into table with definition
create table mytable (
myfield_RU VARCHAR(60) CHARACTER SET CYRL
)

I have English and Russian keyboard installed. I am able to enter Russian language text from IBExpert.

But Delphi applications and SQL Explorer only shows guestion marks (??????).

I have tried BDE, IBX, FIBPlus.

In my application I need to store only some VARCHAR and BLOB fields data in Russian, but in same table I also need to store English in other fields.
for example
Product_name_eng
Product_name_ru

Is it possible? How to do this?

thank you.

Is it possible?

http://www.ibase.ru/devinfo/ibrusfaq.htm

SQL Explorer

It is very old program. Do not use it.

thank you for reply.

I tried the methods in the article, but I still have problems.
I created database with character set WIN1251.

I also tried to creata database with character set UNICODE_FSS

and I tried a database without defining character set and defining only one field. for example:
create table mytable (
productname varchar (50),
productname_ru varchar(50) character set WIN1251
);

and I tried
productname_ru varchar(50) character set cyrl;


but in every way when I enter data in IBExpert while entering data everything is OK. After I click Post data becomes ?????????

why?

I also tried trial version of Gemini driver but from Delphi side I only see ????????


all ideas are welcome.

There are no russian characters in fonts, installed in your Windows. may be... Try to install fonts from russian version of Windows.
And try this:
Start->Settings->Control Panel->Regional Settings
in first tab "regional settings" in my windows is "russian".
In my windows nt4 server eng (not russian!) I do not see same problem.

Delphi_coder писал(а): create table mytable (
productname varchar (50),
productname_ru varchar(50) character set WIN1251
);

but in every way when I enter data in IBExpert while entering data everything is OK. After I click Post data becomes ?????????

why?

Did you used character set WIN1251 as connection parameter too? Note: this parameter should be set _before_ connect, not within it's context.

if there are ???? instead of русских букв, than you have not installed russian fonts (character set) in Windows.

kdv писал(а):if there are ???? instead of русских букв, than you have not installed russian fonts (character set) in Windows.

He said text is OK until Post. Maybe different fonts on edit and browse modes and one of used fonts is cyrillic and another not?

>kdv

Delphi_coder писал(а):I have English and Russian keyboard installed. I am able to enter Russian language text from IBExpert.

thank you for replies.

I have only Windows XP/2000 in English - and because of that only English fonts. Unfortunately I don't have Russian version of Windows CD

Could somebody send me the Russian language fonts?

Packed by rar folder with fonts "C:\windows\fonts" is 36 Mb...

Maybe you need not all of them, but only some. Delphi by default used courier font, for example. Tell me what fonts you need and I'll send you them.

Походу дела шрифты были совсем нерусские, я сбросил коллеге delphi_coder русифицированные шрифты, вроде наладилось.