Hi,
We're trying enter polish language into mysql. My understanding is that
polish language uses iso-8859-2 character set. I am cutting and pasting
polish text from a web browser (Konqueror) into the mysql command line client
running in a terminal window (konsole). MySQL server is version 4.0.12
running on a remote Linux server that I have connected to with ssh.
When I paste polish characters into the command line client using a very
simple insert statement a lot of characters are being lost or converted to a
question mark (?) ... I believe this is happening to all non-ascii
characters. The database server must support both English and Polish so
anything that we do must be specific to the individual database (at the
most).
I have tried passing various options to the command line client, here is an
example (line split for readability):
mysql --character-sets-dir=/usr/share/mysql/charsets
--default-character-set=latin2 -u user -p database
I have also tried playing with Linux locale settings by starting mysql like
this:
LC_ALL=polish mysql --character-sets-dir=/usr/share/mysql/charsets
--default-character-set=latin2 -u user -p database
Nothing quite seems to work. What does work fine is inserting the characters
through a web interface. As well as in my purely Linux environment, we also
need this to work when on a Microsoft Windows based desktop.
Any ideas appreciated, I'm shooting in the dark still even after hours of
documentation reading and Internet searching.
Thanks,
--
Fraser Campbell <fr****@wehave.net> http://www.wehave.net/
Halton Hills, Ontario, Canada Debian GNU/Linux
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw