How to enter iso-8859-2 characters through command line client?

Fraser Campbell

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

Jul 19 '05 #1

Subscribe Reply

3130

Similar topics

476

ISO C89 and ISO C99

by: jrefactors | last post by:

When people say C programming language, they mean ISO C89? The latest C is ISO C99, but I heard this is not commonly used. What's the differences between ISO C89 and ISO C99? Please advise. Thanks

C / C++

20986

Press enter to continue

by: junk mail | last post by:

My friend is trying to code a small c program where he wants to force the user to press enter and only enter to continue. Currently he is using getchar() with a loop but you can type any number of characters, which are echoed to screen before you have to press enter. For example:- do { /* Begin loop */

C / C++

1941

Useful libraries in ISO C

by: Sensei | last post by:

Hi! I'm looking for useful libraries that are strictly ISO C. Any kind of library, from lists, stacks, to trees, searching tools, sorting tools... really *any* kind. Do you have any idea? :) -- Sensei <senseiwa@mac.com>

C / C++

4080

Reason for ISO ; warning

by: pemo | last post by:

ISO C does not allow extra ';' outside of a function int n;; int main(void) { .... } Anyone care to enlighten me as to why ISO C does not allow this, but

C / C++

2039

ISO 9660 Images

by: John Daly | last post by:

Hope this is the right place to post this. I recently downloaded iso disc imsges, however my new pc did not come with burning software, and i can not find my old discs. I tried to use the Burning Wizzard built into Windows XP but it jsut copied the ISO file as is. Now for some assumptions on my part. I am assuming an .iso file is similar in nature to a zip file in that the directory strucutre and the files are packed into 1 larger file....

.NET Framework

2650

ISO IEC C++ standard specification 14882:2003

by: Alok | last post by:

Hi, I want to purchase the ISO C++ standard ISO/IEC 14882:2003 specification for reference. The ANSI store sells the PDF or CD-ROM of the document for $30 http://webstore.ansi.org/ansidocstore/product.asp?sku=INCITS%2FISO%2FIEC+14882-2003, but the ISO store sells the seemingly same document for CHF 352 ( or over $281.82 http://www.google.com/search?q=352+chf+in+usd )...

C / C++

1565

FAQ Topic - How do I convert a Number into a String with exactly 2 decimal places?

by: FAQ server | last post by:

----------------------------------------------------------------------- FAQ Topic - How do I convert a Number into a String with exactly 2 decimal places? ----------------------------------------------------------------------- When formatting money for example, to format 6.57634 to 6.58, 6.5 to 6.50, and 6 to 6.00? Rounding of x.xx5 is uncertain, as such numbers are not represented exactly.

Javascript

2671

Open a file within an ISO in python.

by: danikar | last post by:

Is there a way to open a file that is inside of an ISO in python? Say I have an ISO file, danikars.iso and on the iso there is a file called information.txt I want to be able to do something like this. iso_h = openiso("danikars.iso") file_h = iso_h.extract("information.txt")

Python

2232

Buying the ISO 14882-2003 Standard

by: ManicQin | last post by:

Hi, I was about to buy the Standard but then I found this link http://www.usatlas.bnl.gov/~dladams/cpp/INCITS+ISO+IEC+14882-2003.pdf Hmmmm... ... The link seems legit so ... what gives? Thanks...

C / C++

1974

boot .iso

by: scotter86 | last post by:

Hi everyone, I'm trying to "burn","mount" what ever you want to call it, an .iso file to a hard disk partition. What I'm trying to do is get this iso on a partition and boot it much like I would a cd. I saw a couple examples where it was able to work using a boot loader, and just pointing to the iso, but i want to do it with out using a boot loader. The iso is just a linux live cd, but I was curious weather or not this is actually possible. ...

General

10437

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10164

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9042

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7538

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6780

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5437

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5563

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4113

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2920

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General