On 08-Jun-99 Stanislav Malyshev a.k.a Frodo wrote:
BNM Do any one know or done a port of Hebrew Access to MySQL ?
What do you mean "port of Access to MySQL"? Access is the DB engine (in
fact, it's Microsoft Jet, IIRC) plus the form builder. Form builder can
work with any DB that talks ODBC (including MySQL). DB engine data can
be exported to MySQL (via text tab-delimited or alike format).
Yes. One caveat, however:
Ordering will not work with Hebrew using the default MySQL
setup. For example, doing a SELECT...ORDER BY will not correctly sort
Hebrew.
Fortunately, there is an easy solution: MySQL support many languages,
including Hebrew, as compilation-time options.
The MySQL manual explain exactly how to change the default language (which
is Latin-1). After doing this and recompiling, Hebrew sorting will work
fine.
Gavrie.
--
Gavrie Philipson
Netmor Applied Modeling Research Ltd.
Bnei Brak, Israel.
