Re: Cyrillic handling in MySQL - bug?

[Steven Mitchell]

>What is your client program you use to input character? Is it "mysql.exe" ?
Or some GUI tool?

I am using a script for both input and output that is:
- running on Apache2 (on Debian).
- written in PHP (4.3).
- using the PEAR DB library.

I am also viewing data using the client mysql program through a PuTTY terminal session (displaying in UTF-8). When I input data using the mysql client I still have random errors.

>"SHOW VARIABLES LIKE 'character_set%'";

- character_set_client: latin1
- character_set_connection: latin1
- character_set_database: utf8
- character_set_results: latin1
- character_set_server: latin1
- character_set_system: utf8
- character_sets_dir: /usr/share/mysql/charsets/

Any ideas? Thanks in advance.



Edited 1 time(s). Last edit at 04/21/2005 09:21PM by Steven Mitchell.