Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Paul, DBI doesn't read the config file, DBD::mysql does. Erm, yep, I meant that, too :-) It's not expensive at all. Why do you think it's expensive? As the file must be read and parsed at each ->connect(...) invocation. It would be nicer if DBD could read the config file during the "use phase" (f

Re: setting character sets "permanently"

2005-04-24 Thread Paul DuBois
At 0:49 +0200 4/25/05, Fagyal Csongor wrote: Harald, Perhaps the following excerpt from "perldoc DBD::mysql" is relevant for you: mysql_read_default_file mysql_read_default_group These options can be used to read a config file like /etc/my.cnf or ~/.my.cnf. By default MySQL's C client

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Harald, Perhaps the following excerpt from "perldoc DBD::mysql" is relevant for you: mysql_read_default_file mysql_read_default_group These options can be used to read a config file like /etc/my.cnf or ~/.my.cnf. By default MySQL's C client library doesn't use any config files unl

Re: setting character sets "permanently"

2005-04-24 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Fagyal Csongor <[EMAIL PROTECTED]> writes: mysql> show variables like 'character%'; >> +--+ >> -+ >> | Variable_name| Value >> | >> +--+--

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Hmmm, strange... From the mysql client I see: mysql> show variables like "%char%"; +--+-+ | Variable_name| Value | +

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Mathias, 2 other things : 1. what is your character set when you install the mysql server ? I used the binaries from mysql.com. I think that has latin1/swedish as a default. But anyways, I really don't like the idea to recompile MySQL just to get my character sets work all right. 2. what cha

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Mathias, And you can add all those variables to the ini file : character_set_client=latin2 character_set_connection=latin2 character_set_database=latin2 character_set_results=latin2 character_set_server=latin2 No, I can not. MySQL won't start. More precisely, "character_set_results" is not recog

RE: setting character sets "permanently"

2005-04-24 Thread mathias fatene
- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 22:59 To: 'mathias fatene'; 'Fagyal Csongor' Cc: mysql@lists.mysql.com Subject: RE: setting character sets "permanently" And you can add all those variables to the ini file : character_se

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Mathias, [...] I changed my.ini (.my.cnf) like this : [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 log-bin = "C:/Program Files/MySQL/MySQL Server 4.1/Data/binlog" #Path to installation directory. All paths are usually resolved relative to this. basedir="C:/Program Files/MySQ

RE: setting character sets "permanently"

2005-04-24 Thread mathias fatene
:47 To: 'Fagyal Csongor' Cc: mysql@lists.mysql.com Subject: RE: setting character sets "permanently" Hi, Look at this : mysql> show variables like 'character%'; +--+ -+ |

RE: setting character sets "permanently"

2005-04-24 Thread mathias fatene
_dir | C:\Program Files\MySQL\MySQL Server 4.1\share\charsets/ | +--+ -+ That's all. Mathias -Original Message- From: Fagyal Csongor [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 22:33 To: mysql@lists.mysql.com Subject: s

setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
HI, I am using MySQL 4.1.11 on FC3, and I have trouble reading back latin2 characters. No wonder, as character_set_client, character_set_connection and character_set_results are all set to latin1. The problem is that I cannot set them to latin2 _permanently_, I mean every time I connect to the