OS : (KOREAN) Windows95
DELPHI : 3.0 C/S

I made some database program using SQL search,
By the way the program must be available to "Cyril (Russian)" charactor.

I can write in the Input Component in Cyril,(Append to Windows
Cyrill Keyboard in Control and Using Cyril Font in Delphi Component)
Edit too. But I can't search using SQL.

It just only abvailable to use table access function,
example FINDNEAREST an so on.. but not in SQL

But Why not in SQL?
Is it any solution ? (I guess it is somewhare to change SQL
language driver or....)

song jong kil skrev i meddelelsen
<355668FE.32435...@hyowon.cc.pusan.ac.kr>...

As a scandinavian user we have some general problems too, but changhing the
language driver solve this. At least for the entering the language specific
characters. I have not testet seach for that until now, but I think this
will work there too :) ??

regards
Jorn Johanesson Beekeeper since 1970
EDBi = Beekeeping software since 1986
homepages http://wn.com.au/apimo
                      http://home4.inet.tele.dk/apimo
e-mail             ap...@post4.tele.dk

I forgot : The language driver must also be altered in IDAPI(32).CFG

Jorn Johanesson skrev i meddelelsen <6j82km$jh...@news-inn.inet.tele.dk>...

Do you understand for sure how Russian characters are being mapped in the
character set your Windows system is using? From that you can figure out how
your database indexes these characters. There are several character mapping
schemes commonly used for Russian. The two most common ones are Win1251
(used for Windows95 Multilanguage Support component) and KOI8, an early Web
standard.

E.g. KOI8 fonts map Russian letter "Ya" as follows:
  Upper: 0241
  Lower: 0209

Win1251 fonts map the same letter:
  Upper: 0223
  Lower: 0225

(There can be other low-level things such as system font and keyboard
drivers on Russian systems that affect keyboard input but I'm not really up
on these as I don't really speak or write Russian.)

I didn't see what DB you are using... assuming Paradox since this is Desktop
forum. I don't know if there is any verison of Paradox or BDE that
specifically supports Russian. (Server DBs like MS SQL Server do for sure).
Consequently, your database is probably indexing Cyrillic characters in the
extended range as if they were Western characters (or maybe in your case
Korean?). Keyboard input in your query string may be different from values
in the index.

The best I can suggest is to test to make sure you know how your Curillic
keyboard input is mapped,  stored, and indexed. Possibly you may have to
write some code to parse and interpret keyboard input  when querying and or
writing data. (That's probably a hack... the best solution is probably a
Russian version of your database.)

Good luck...
_________________________________________
Robert Palomo
Object International Software, Ltd.
rob...@oisoft.ru

Hi!

Robert Palomo ??? a ???? <35581FD2.7240E...@oisoft.ru> ...

There are some other code pages used in Russia but these most useful.

What a problem with SQL?
Song what is your database?

Hi, I'm Song J.K.

Most of all, very much thank to all who try answer
my question.
I solve that Russia problem by helping of them.

Solution.

1. Table Language driver : PDOX ANSI CYRRILLIC
2. BDE       PARADOX dirvier:  ""

Attention.

Don't USE Upper or uppercase function in SQL

that's it

Thanks~

song jong kil ???: