Re: What charset to use for greek character Β?
Hi, I just realized that the problem is that I also need to specify charset for load data. Once the utf8 is specified for 'load data', then the problem is solved. Please ignore my previous email. Thanks! ~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ cat main.sql use test CREATE TEMPORARY TABLE test ( name VARCHAR(255) character set utf8 ); LOAD DATA LOCAL INFILE 'table.txt' INTO TABLE test CHARACTER SET utf8; SELECT * FROM test; ~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ cat table.txt βΒ ~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ cat main.sh #!/usr/bin/env bash mysql -t -hlocalhost -uxxx < main.sql ~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ ./main.sh +--+ | name | +--+ | βΒ | +--+ 2011/10/16 Peng Yu : > Hi, > > I have the greek character "Β" (not that it is different from the > English character "B", although they look similar. Copy both of them > and type in google search box, you will see different search > suggestion pop up). > > utf8 in mysql seems doesn't work. I'm wondering what charset I should > for this greek letter. > > -- > Regards, > Peng > -- Regards, Peng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
What charset to use for greek character Β?
Hi, I have the greek character "Β" (not that it is different from the English character "B", although they look similar. Copy both of them and type in google search box, you will see different search suggestion pop up). utf8 in mysql seems doesn't work. I'm wondering what charset I should for this greek letter. -- Regards, Peng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Chinese sorting and filtering on an table with charset utf-8
Hello there! I'm trying to get some software ready to work with Chinese/Hanzi characters/graphems/sinograms. My tables, using mysql 5.x, use UTF-8 for all text data. It is not an option to change that for a local Chinese installation. Storing data works quite nicely. That's what I like about UTF-8. But sorting does not work. And, related to that, comparisons neither. I'm getting the hopefully silly notion that there is no collation for CHARSET=UTF-8 that could sort according to the rules of GB2312 (which, if it was true, would probably an interesting story to explain why). This leads me to fear that I might have to use a Pinyin translation library (like pinyin4j, which only translates character by character and is not bijective), store that in a separate column and sort that. Which would only give approximate results since without a huge dictionary backing, the lack of bijective mapping between Hanzi and Pinyin will result in a lack of information. Or I could create a separate column with GB2312 as encoding and sort by this using the collation I want (gb2312_chinese_ci most likely). The latter would provider better sorting than the former, but require me to do the same thing for other countries, too (I assume there'd be people interested in having big5 and that is still the same language...). Or I could do it one level above the database layer - which is possible, but I assume any code I could write would be less sophisticated (and thereby slower) than what the database can do. Previous research: I've seen the threads "Chinese order by with utf8" and "Chinese and MySQL / UTF8 and versions" which are a bit older than I'd like and also don't seem conclusive. So what are my options here? I'm not married to the idea of using GB2312 - I would be willing to use any other Chinese collation, as long as it is better than the default one (which sorts by number value). Thanks in advance, Tierlieb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
building mysql 5.5.8 with default charset
Hello, is it a bug or a feature that if building mysql 5.5.8 from source with the options 'cmake . -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci' the charset in include/config.h remains latin1: #define MYSQL_DEFAULT_CHARSET_NAME "latin1" #define MYSQL_DEFAULT_COLLATION_NAME "latin1_swedish_ci" Probably there are some other places as well. As a result, if php is built against this mysql installation, it assumes the default charset to be latin1, so that many old php applications require adding the explicit connection settings (set names utf8) to work correctly. The amazing thing is that in the 5.1 branch it works the other way - replaces everywhere to utf8, so 'set names utf8' is not needed. Is there any way to make it so in 5.5.8? Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)718-3322, 718-3115(fax) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: help about the charset
On Wed, Feb 3, 2010 at 6:33 PM, Thiyaghu CK wrote: > Hi Moli, > > I hope this is because there is spelling mistake. It should be > '--with-extra-charsets=all', but you have given > '--with-extral-charsets=all'. That's why only the utf8 has been installed > and not the other charsets. > Thanks a lot Thiyaghu. I really inputed the wrong compiling arguments by mistake. Now I adjust it and recompile mysql, all goes fine. Thanks. -- moli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: help about the charset
Hi Moli, I hope this is because there is spelling mistake. It should be * '--with-extra-charsets=all'*, but you have given '--with-*extral*-charsets=all'. That's why only the utf8 has been installed and not the other charsets. Regards, Thiyaghu CK www.mafiree.com On Wed, Feb 3, 2010 at 2:26 PM, wrote: > Hello, > > I have a strange problem on the charset on mysql. > I'm using mysql-5.0.45, compiled from the source, and enabled: > '--with-charset=utf8' '--with-extral-charsets=all' > when compiling it. > > My default charset in my.cnf is utf8: > character-set-server=utf8 > > OK I logined into mysql and run: > > mysql> set names 'gbk'; > ERROR 1115 (42000): Unknown character set: 'gbk' > > The error shows as above. > > These were the 'show' command's output: > > mysql> show variables like 'character%'; > +--++ > | Variable_name| Value | > +--++ > | character_set_client | utf8 | > | character_set_connection | utf8 | > | character_set_database | utf8 | > | character_set_filesystem | binary | > | character_set_results| utf8 | > | character_set_server | utf8 | > | character_set_system | utf8 | > | character_sets_dir | /var/mysql5.0.45/share/mysql/charsets/ | > +--++ > 8 rows in set (0.00 sec) > > mysql> show charset like 'utf8'; > +-+---+---++ > | Charset | Description | Default collation | Maxlen | > +-+---+---++ > | utf8| UTF-8 Unicode | utf8_general_ci | 3 | > +-+---+---++ > 1 row in set (0.01 sec) > > mysql> show charset like 'gbk'; > Empty set (0.00 sec) > > > Since I have enabled --with-extral-charsets=all why can't I use gbk > charset? > How to resolve it? > > Thanks. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=theyaho...@gmail.com > >
help about the charset
Hello, I have a strange problem on the charset on mysql. I'm using mysql-5.0.45, compiled from the source, and enabled: '--with-charset=utf8' '--with-extral-charsets=all' when compiling it. My default charset in my.cnf is utf8: character-set-server=utf8 OK I logined into mysql and run: mysql> set names 'gbk'; ERROR 1115 (42000): Unknown character set: 'gbk' The error shows as above. These were the 'show' command's output: mysql> show variables like 'character%'; +--++ | Variable_name| Value | +--++ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results| utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /var/mysql5.0.45/share/mysql/charsets/ | +--+----+ 8 rows in set (0.00 sec) mysql> show charset like 'utf8'; +-+---+---++ | Charset | Description | Default collation | Maxlen | +-+---+---++ | utf8| UTF-8 Unicode | utf8_general_ci | 3 | +-+---+---++ 1 row in set (0.01 sec) mysql> show charset like 'gbk'; Empty set (0.00 sec) Since I have enabled --with-extral-charsets=all why can't I use gbk charset? How to resolve it? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ENGINE=InnoDB DEFAULT CHARSET=latin1;
Hello, I am getting an error #HY000Incorrect string value: '\xE9l\xE9tra...' for column ' Not quite sure why. hex E9 is a lower case e acute found in CP1252 and googling seems to tell me that the latin1 charset that I have set for the table should display this OK. mysql V 5.0.54a on Redhat 5.2 mysql> SHOW CHARACTER SET LIKE 'latin%'; +-+-+---++ | Charset | Description | Default collation | Maxlen | +-+-+---++ | latin1 | cp1252 West European| latin1_swedish_ci | 1 Any thoughts? TIA Syd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
About charset
Hello list, I have a table whose 'default charset=utf8'. I insert a record into it with non-utf8 charset,like GBK.Then I select this record,it print GBK characters correctly. Then I insert a utf8 record into it,and read this record in scripts and decode it with utf8_decode,the result is also correct. So I think,for table (or column) with utf8 charset,I could insert it with any characters like GBK,gb2312,iso8859-1.Mysql doesn't convert them to utf8 characters automaticly. Am I right? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5 et les charset sur debian etch
Hello, Je peux lire des Français, mais l'écriture qu'il n'est pas comme facile. Ainsi j'emploie des poissons de Babel pour traduire ceci d'anglais-français. Ainsi, mes excuses s'il la grammaire est totalement erroné. Très intéressant. Je devinerais que le problème s'est produit dans le transfert des données à partir d'une base de données à l'autre. Comment avez-vous copié les données ? Vous pourriez examiner insérer de nouvelles données dans chaque base de données et voir si elle semble correcte. Bill Gilles MISSONNIER wrote: Hello, j'ai 2 machines Linux debian etch, avec MySQL 5.0.32 J'ai un problème d'affichage sur l'une des machines : j'ai créé la même table et chargé le même fichier data dans une base sur chaque machine, et l'affichage est différent. Je ne vois pas oú est la différence... my.cnf idem locale idem mysql> select @@character_set_server,@@collation_server,@@character_set_connection; +---+++ | @@character_set_server | @@collation_server | @@character_set_connection +++---+ | utf8 | utf8_general_ci| utf8 +++---+ mysql> select nom,id from t; +--++ | nom | id | +--++ | aàb | 1 | | été | 2 | | cçoôeêeèeëi | 3 | | EÉEÈEË | 4 | | c'est tout | 5 | +--++ sur l'autre machine, l'affichage n'est pas bon. mysql> select @@character_set_server,@@collation_server,@@character_set_connection; ++++ | @@character_set_server | @@collation_server | @@character_set_connection ++++ | utf8 | utf8_general_ci| utf8 ++++ mysql> select nom,id from t; +++ | nom| id | +++ | aà b | 1 | | été | 2 | | cçoôeêeèeëi | 3 | | EÉEÈEË | 4 | | c'est tout | 5 | +++ mais si je fais : mysql> charset latin1; les accents sont là oú il faut, mais pas l'alignement des colones... mysql> select nom,id from t; +--+--+ | nom | id | +--+--+ | aàb |1 | | été|2 | | cçoôeêeèeëi |3 | | EÉEÈEË|4 | | c'est tout |5 | +--+--+ si quelqu'un peut reproduire la chose et m'expliquer le problème... voici la commande de création de la table : mysql> CREATE TABLE `t` ( `id` int(10) unsigned NOT NULL auto_increment, `nom` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ; ensuite on rentre les données : mysql> load data infile '/le_repertoire/t' into table t fields terminated by ':'; et le fichier t contient : 1:aàb 2:été 3:cçoôeêeèeëi 4:EÉEÈEË 5:c'est tout _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5 et les charset sur debian etch
Hello, j'ai 2 machines Linux debian etch, avec MySQL 5.0.32 J'ai un problème d'affichage sur l'une des machines : j'ai créé la même table et chargé le même fichier data dans une base sur chaque machine, et l'affichage est différent. Je ne vois pas oú est la différence... my.cnf idem locale idem mysql> select @@character_set_server,@@collation_server,@@character_set_connection; +---+++ | @@character_set_server | @@collation_server | @@character_set_connection +++---+ | utf8 | utf8_general_ci| utf8 +++---+ mysql> select nom,id from t; +--++ | nom | id | +--++ | aàb | 1 | | été | 2 | | cçoôeêeèeëi | 3 | | EÉEÈEË | 4 | | c'est tout | 5 | +--++ sur l'autre machine, l'affichage n'est pas bon. mysql> select @@character_set_server,@@collation_server,@@character_set_connection; ++++ | @@character_set_server | @@collation_server | @@character_set_connection ++++ | utf8 | utf8_general_ci| utf8 ++++ mysql> select nom,id from t; +++ | nom| id | +++ | aà b | 1 | | été | 2 | | cçoôeêeèeëi | 3 | | EÉEÈEË | 4 | | c'est tout | 5 | +----++ mais si je fais : mysql> charset latin1; les accents sont là oú il faut, mais pas l'alignement des colones... mysql> select nom,id from t; +--+--+ | nom | id | +--+--+ | aàb |1 | | été|2 | | cçoôeêeèeëi |3 | | EÉEÈEË|4 | | c'est tout |5 | +--+--+ si quelqu'un peut reproduire la chose et m'expliquer le problème... voici la commande de création de la table : mysql> CREATE TABLE `t` ( `id` int(10) unsigned NOT NULL auto_increment, `nom` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ; ensuite on rentre les données : mysql> load data infile '/le_repertoire/t' into table t fields terminated by ':'; et le fichier t contient : 1:aàb 2:été 3:cçoôeêeèeëi 4:EÉEÈEË 5:c'est tout _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: charset
Hi, Try the format below: ALTER DATABASE mybase DEFAULT CHARACTER SET = latin1; ALTER DATABASE mybase DEFAULT COLLATE = latin1_swedish_ci; HTH ... - Original Message - From: "Mário Gamito" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Monday, April 09, 2007 4:19 PM Subject: charset Hi, I have this database with utf-8 charset. How can i change it to latin1 ? I've seen the MySQL pages and run in the MySQL prompt: ALTER DATABASE telbit CHARACTER SET latin1 COLLATE latin1_swedish_ci; but i get an error saying that i have an error in my syntax. Any help would be appreciated. Warm Regards -- :wq! Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
charset
Hi, I have this database with utf-8 charset. How can i change it to latin1 ? I've seen the MySQL pages and run in the MySQL prompt: ALTER DATABASE telbit CHARACTER SET latin1 COLLATE latin1_swedish_ci; but i get an error saying that i have an error in my syntax. Any help would be appreciated. Warm Regards -- :wq! Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CONCAT(int_col, string_col) and charset and collation problems
Hi, I know about CONVERT but I wanted to check character set of 'tt' column and this result use in CONVERT. Something like CONVERT(id USING CHARSET(Name)) which doesn't work. It wont. the syntax is -- CONVERT(expr USING transcoding_name); its the name of the transcode and not an expr. I just wonder why CONCAT(1, ',', Name) works OK even if CHARSET(1) is binary string and CONCAT(id, ',', Name) doesn't It does. mysql> select concat(1,',',tt) from test; +--+ | concat(1,',',tt) | +--+ | 1,a | | 1,b | | 1,c | +--+ 3 rows in set (0.00 sec) mysql> select concat(id,',',tt) from test; +---+ | concat(id,',',tt) | +---+ | 1,a | | 2,b | | 3,c | +---+ 3 rows in set (0.00 sec) Thanks ViSole DB Team. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CONCAT(int_col, string_col) and charset and collation problems
I know about CONVERT but I wanted to check character set of 'tt' column and this result use in CONVERT. Something like CONVERT(id USING CHARSET(Name)) which doesn't work. I just wonder why CONCAT(1, ',', Name) works OK even if CHARSET(1) is binary string and CONCAT(id, ',', Name) doesn't Thanks, Dusan ViSolve DB Team napsal(a): Hi, It is that, what you think a binary is ,...is indeed a binary. As per the manual, If a string input or function result is a binary string, the string has no character set or collation. so the resultant 'binary' is expected. if u want the resultant as: mysql> select charset(concat(tt,CONVERT(id USING latin1))) from test; Thanks ViSolve DB Team - Original Message - From: "Dušan Pavlica" <[EMAIL PROTECTED]> To: "list mysql" Sent: Wednesday, January 31, 2007 5:31 PM Subject: CONCAT(int_col, string_col) and charset and collation problems Hi, I'm using MySQL 4.1.15, WinXP and my problem is that SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable; always returns charset 'binary' and I need resulting charset to be same as a charset of a string_column because I don't want to look for charset of a column whenever I have to call CONCAT function. Do you have any tips how to achieve it? In my opinion, results of concatenating string and numeric columns should always have charset of string column(s) and not binary charset. Thanks in advance for any response Dusan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CONCAT(int_col, string_col) and charset and collation problems
Hi, It is that, what you think a binary is ,...is indeed a binary. As per the manual, If a string input or function result is a binary string, the string has no character set or collation. so the resultant 'binary' is expected. if u want the resultant as: mysql> select charset(concat(tt,CONVERT(id USING latin1))) from test; Thanks ViSolve DB Team - Original Message - From: "Dušan Pavlica" <[EMAIL PROTECTED]> To: "list mysql" Sent: Wednesday, January 31, 2007 5:31 PM Subject: CONCAT(int_col, string_col) and charset and collation problems Hi, I'm using MySQL 4.1.15, WinXP and my problem is that SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable; always returns charset 'binary' and I need resulting charset to be same as a charset of a string_column because I don't want to look for charset of a column whenever I have to call CONCAT function. Do you have any tips how to achieve it? In my opinion, results of concatenating string and numeric columns should always have charset of string column(s) and not binary charset. Thanks in advance for any response Dusan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CONCAT(int_col, string_col) and charset and collation problems
Hi, I'm using MySQL 4.1.15, WinXP and my problem is that SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable; always returns charset 'binary' and I need resulting charset to be same as a charset of a string_column because I don't want to look for charset of a column whenever I have to call CONCAT function. Do you have any tips how to achieve it? In my opinion, results of concatenating string and numeric columns should always have charset of string column(s) and not binary charset. Thanks in advance for any response Dusan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Charset for SELECT ... INTO OUTFILE
Hi, User can also specify character set during the SELECT operation also with CHARACTER SET or charset. Use mysql>charset utf 8 before issuing SELECT query. For Instance: If you do not say SET NAMES or SET CHARACTER SET, then for SELECT column1 FROM t, the server sends back all the values for column1 using the character set that the client specified when it connected, specified in the cnf file. On the other hand, if you say SET NAMES 'latin1' or SET CHARACTER SET latin1 before issuing the SELECT statement, the server converts the latin2 values to latin1 just before sending results back. Conversion may be lossy if there are characters that are not in both character sets. Ref: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html Thanks ViSolve DB Team. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, October 09, 2006 2:23 PM Subject: Charset for SELECT ... INTO OUTFILE > Hi, > > I have a database where the database character set is utf-8 and some rows > are ascii. > > I want to save the results of some queries, and SELECT ... INTO OUTFILE > looks like an easy way to do it. But I need the output in ucs-2. Is there > any way to specify the charset for SELECT ... INTO OUTFILE, or is it always > uses the database character set? > > Thx. > > ImRe > > P.S.: Ver 5.0.24a-community-log > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >
Charset for SELECT ... INTO OUTFILE
Hi, I have a database where the database character set is utf-8 and some rows are ascii. I want to save the results of some queries, and SELECT ... INTO OUTFILE looks like an easy way to do it. But I need the output in ucs-2. Is there any way to specify the charset for SELECT ... INTO OUTFILE, or is it always uses the database character set? Thx. ImRe P.S.: Ver 5.0.24a-community-log -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
utf8 charset question
Hi all, I'm fairly new to character sets and I'm trying to get a better understanding of how mysql deals with them. I hope someone out there can shed some light on a behavior that I am seeing. We're using mysql 4.1.12 with clustered tables. I have a table with a varchar and a text field where the table has been defined to use : ENGINE=ndbcluster DEFAULT CHARSET=latin1 Now, through my php user interface, I find that I can update/insert Korean characters into the database table and successfully retrieve them from the database. I'm using microsoft's Korean input system (ms-ime2002) So, I'm wondering how can this be? If the charset is using latin1, then I would expect that I am using 1 byte for storage but the Korean character sets would need 2. - am I just getting lucky and not using the characters that require 2 bytes ? - is there something special about clustered tables in that it treats all char data as utf8 charsets ? - is my test invalid in that the Microsoft encoding for the Korean characters only needs 1 byte ? Thanks for any replies, Yong.
Re: Charset questions
Yes Ryan, Shawn is wright... this is dark art... and few are experimenting it ! I did some dark art because of my need to get into *latin2 (latin2_general_ci)*. Even though is adark art I do still there are people who know to answer you... but i believe you were to vague... Please be *more* specific on your problem. What is the server default charset and collation ? What is the database default charset and collation ? What charsets and collations are the tables and/ or even the columns you were talking about ? Finally I didn't found any ColdFusion secific connector... so I assume ODBC ! Have you searched for ODBC related issues ? Maybe is ODBC's fault. What server version do you use ? 4 or 5 ? Please specify minor also ! What about connection charset and/or collation ? Have you set them ? so... ?:) -- Gabriel PREDA Senior Web Developer
RE: Charset questions
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 03/09/2006 09:59:32 AM: > Are my emails not coming through? Or is this question way too 'newbie' > and no one wants to touch it? > > -Ryan > > Ryan Stille wrote: > > I'm still hoping someone can else can share their input on this. > > > > What do other people usually do as far as the collation setting? > > > > Thanks, > > -Ryan > > > > Ryan Stille wrote: > >> When we migrated to MySQL from MS SQL, I left everything set to the > >> default as far as collations - latin1_swedish_ci. > >> This was based on digging through the manual and google. But now I am > >> migrating the application to a newer version of ColdFusion and am > >> running into some issues with charsets on some ColdFusion functions. > >> I am wondering if my database charset has anything to do with it. > >> > >> What do other people usually do as far as the collation setting? > >> > >> We are in the US, but do have a few sites that make use of German > >> and Spanish characters. > >> > >> Thanks, > >> -Ryan > > I don't think that your question was too newbie. I believe that within the world of MySQL that changing charsets and collations is still something of a dark art. Not many users need something other than the default settings and those that do experiment with the various charsets and collations until they find one that works for them. There have been frequent posts on this list looking for help in setting up a character set or trying to resolve why certain characters no longer "appear" as they were when they went into the database. The basic thing to remember is that each and every communications channel can have it's OWN charset setting. If you are pushing data in using utf-8 and you are pulling data out through a connection using UCS-2, you may run into a few translation errors (that was just an example, I don't know if they are incompatible or not) I think that the default charset and collation covers most or all of the european alphabets so you may not need to use anything but the defaults for English, Spanish, Italian, Portuguese, French, German, and the Nordic languages (I can't name them all, sorry to those who live there). I have to admit that I haven't had to delve deeply into this subject so I cannot speak from deep experience but that's basically what I have gathered by lurking on the other posts dealing with this topic. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
RE: Charset questions
Are my emails not coming through? Or is this question way too 'newbie' and no one wants to touch it? -Ryan Ryan Stille wrote: > I'm still hoping someone can else can share their input on this. > > What do other people usually do as far as the collation setting? > > Thanks, > -Ryan > > Ryan Stille wrote: >> When we migrated to MySQL from MS SQL, I left everything set to the >> default as far as collations - latin1_swedish_ci. >> This was based on digging through the manual and google. But now I am >> migrating the application to a newer version of ColdFusion and am >> running into some issues with charsets on some ColdFusion functions. >> I am wondering if my database charset has anything to do with it. >> >> What do other people usually do as far as the collation setting? >> >> We are in the US, but do have a few sites that make use of German >> and Spanish characters. >> >> Thanks, >> -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Charset questions
I'm still hoping someone can else can share their input on this. What do other people usually do as far as the collation setting? Thanks, -Ryan Ryan Stille wrote: > When we migrated to MySQL from MS SQL, I left everything set > to the default as far as collations - latin1_swedish_ci. > This was based on digging through the manual and google. But > now I am migrating the application to a newer version of > ColdFusion and am running into some issues with charsets on > some ColdFusion functions. I am wondering if my database > charset has anything to do with it. > > What do other people usually do as far as the collation setting? > > We are in the US, but do have a few sites that make use of > German and Spanish characters. > > Thanks, > -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset questions
When we migrated to MySQL from MS SQL, I left everything set to the default as far as collations - latin1_swedish_ci. This was based on digging through the manual and google. But now I am migrating the application to a newer version of ColdFusion and am running into some issues with charsets on some ColdFusion functions. I am wondering if my database charset has anything to do with it. What do other people usually do as far as the collation setting? We are in the US, but do have a few sites that make use of German and Spanish characters. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: charset
Hello. mysqld has a --default-character-set=name command line option. Put latin5 instead of 'name'. It should be possible to specify this variable through the configuration file or environment variable. You can check if your server supports latin5 with: show variables like 'character_sets'; statement. OKAN ARI wrote: > yes it is mysql 4.0 how can I set i to latin 5 or how can I set the > server to latin 5? > > os: centos 4.2 > > Thank you > - Original Message - From: "Gleb Paharenko" > <[EMAIL PROTECTED]> > To: > Sent: Tuesday, January 31, 2006 1:40 PM > Subject: Re: charset > > >> Hello. >> >> In case mysql4 is mysql4.0 there should be a server system variable >> default_character_set. If it is 4.1 see: >> http://dev.mysql.com/doc/refman/4.1/en/charset-syntax.html >> http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html >> >> >> OKAN ARI wrote: >> >>> How can I set the characterset to latin5 for mysq4 in linux? >>> >>> OKAN >> >> >> >> -- >> For technical support contracts, goto https://order.mysql.com/?ref=ensita >> This email is sponsored by Ensita.NET http://www.ensita.net/ >> __ ___ ___ __ >> / |/ /_ __/ __/ __ \/ /Gleb Paharenko >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET >> <___/ www.mysql.com >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: charset
yes it is mysql 4.0 how can I set i to latin 5 or how can I set the server to latin 5? os: centos 4.2 Thank you - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 31, 2006 1:40 PM Subject: Re: charset Hello. In case mysql4 is mysql4.0 there should be a server system variable default_character_set. If it is 4.1 see: http://dev.mysql.com/doc/refman/4.1/en/charset-syntax.html http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html OKAN ARI wrote: How can I set the characterset to latin5 for mysq4 in linux? OKAN -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: charset
Hello. In case mysql4 is mysql4.0 there should be a server system variable default_character_set. If it is 4.1 see: http://dev.mysql.com/doc/refman/4.1/en/charset-syntax.html http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html OKAN ARI wrote: > How can I set the characterset to latin5 for mysq4 in linux? > > OKAN -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
charset
How can I set the characterset to latin5 for mysq4 in linux? OKAN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.1.16 shell atl charset input problem
Privet! MySQL 4.1 and 5.0 should work fine with koi8-r and may other character sets. Please, read : http://dev.mysql.com/doc/refman/5.0/en/charset.html in case you haven't done this yet. And if you don't solve you problems, send to the list output of the following statements: show variables like '%char%'; show character set; Kirill Sapelkin wrote: > Hello, > > The mysql 4.1.16 shell does not accept alternate character set (koi8r - > russian) keyboard input. It accepts koi8r input fine in non interactive > mode as: > mysql our_database < our_command.sql > > and it displays both english and koi8r fine on screen. > > It was comiled: configure --with-charset=koi8r > > mysq 5.0.16 acts the same. 4.0 and earlier always worked fine. > > Is there a way to disable the utf-i in 4.1.16? > > Thanks for any help or direction. > > Kirill > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 4.1.16 shell atl charset input problem
Hello, The mysql 4.1.16 shell does not accept alternate character set (koi8r - russian) keyboard input. It accepts koi8r input fine in non interactive mode as: mysql our_database < our_command.sql and it displays both english and koi8r fine on screen. It was comiled: configure --with-charset=koi8r mysq 5.0.16 acts the same. 4.0 and earlier always worked fine. Is there a way to disable the utf-i in 4.1.16? Thanks for any help or direction. Kirill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setting charset
For Archivum My destination was: Changing default latin1 charset to latin2 and the default collation to latin2_hungarian_ci. I tried to configure accross my.cnf, but all of my effort failed. I installed mysql-administrator, use startup paramters in. Change mysqldump . Took changes and it works. Joe - Yahoo! Model Search - Could you be the next catwalk superstar? Check out the competition now
Charset issue
Hi, I've installed MySQL 4.1.10 and phpMyAdmin-2.6.4-rc1 on a RHEL4 box. And I found that phpMyAdmin forces the character set of pages utf-8. Though I knew that phpMyAdmin-2.5.7 can work well with gb2312, I want to make phpMyAdmin work well too. Anybody knows that how to make phpMyAdmin work with non-utf8 encoding ? Thanks. -- Best regards, Huisi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
回复: Charset issue
no,you do not need to modify anything,it just because utf8 which phpmyadmin2.6 default setting conflict with mysql's latin1,so just copy a set of phpmyadmin 2.5.5,and install the mysql 4.1 as default,and every will be ok,that's all. 王静 <[EMAIL PROTECTED]> 写道:hi all. Here is the suituation. i've installed mysql 4.1.12 on WinXP plantform, it seems not to support Chinese by its default configuration, say, Chinese can't be displayer propely. as far as i know, what i need to do is modify the charset(server, connection, client...)concerned, but i'm not so sure and is there anything else i should do and howto? 3x. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - 雅虎免费G邮箱-中国第一绝无垃圾邮件骚扰超大邮箱 雅虎助手-搜索、杀毒、防骚扰
Re: Charset issue
Hello. > Chinese can't be displayer propely. What client do you use to connect to MySQL Server? Check that it supports Chinese. I don't know Chinese and can't suggest what character to use. But, certainly, you should choose one from: http://dev.mysql.com/doc/mysql/en/charset-asian-sets.html Check that SHOW VARIABLES LIKE '%char%' returns this charset for all variables except charset_system, which is always utf8. çé wrote: > hi all. > Here is the suituation. i've installed mysql 4.1.12 on WinXP > plantform, it seems not to support Chinese by its default > configuration, say, Chinese can't be displayer propely. as far as i > know, what i need to do is modify the charset(server, connection, > client...)concerned, but i'm not so sure and is there anything else i > should do and howto? > 3x. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset issue
hi all. Here is the suituation. i've installed mysql 4.1.12 on WinXP plantform, it seems not to support Chinese by its default configuration, say, Chinese can't be displayer propely. as far as i know, what i need to do is modify the charset(server, connection, client...)concerned, but i'm not so sure and is there anything else i should do and howto? 3x. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Charset problems (utf-8 -> latin1)
Also the good way of doing conversion itself is mysqldump table structure, then import the dump, launch mysql command line utility (or use phpmyadmin for that) and alter encoding on database and all needed tables and columns, then mysqldump the first database using utf8 charset (without dropping tables), and import this dump into second database. -- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Charset problems (utf-8 -> latin1)
First, check if actual data in your tables after this conversion is really properly encoded. Launch your mysql command line client, execute SET NAMES latin1; and do some selects on your table data to see if it's readable. If it is, then all you need is to make PHP use latin1 when reading data from db server. One way to do this is to issue 'SET NAMES latin1' query after establishing a connection. There are also some ways to set this as global option for all websites if you can't modify scripts. -- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset problems (utf-8 -> latin1)
Hi, I'm trying to migrate an old system to a newer - while doing that I have to move the database. The old database i UTF-8 encoded, and the new one is Latin-1. To move the data I'm doing something similar to: INSERT INTO new_db.table (new_db.field) SELECT CONVERT(old_db.field USING latin1) FROM old_db.table; When doing a SELECT CHARSET(field) FROM new_db.table; It returns "latin1", so everthings seems to be A-Okay - but since I'm posting this message you could prolly guess that it didn't - and right, it failed... Using SSH to the mysql-server, and using `mysql` it always returns the data as UTF-8 (when setting the encoding to anything else it trashes the special-chars). I don't know if this is normal - I might be, so I continued my work on the migration. I then reloaded the webpage (yes, it's for a PHP driven CMS), and no - the problem still existed. All data was returned as UTF-8 (when running a utf8_decode() in PHP on the db-output the output was corrected and the speciel-chars showed up. But - this isn't normal. Normally you can just enter the data as latin1, and display the output on the webpage (assuming that content-type has a charset og iso-8859-1). And this works everywhere else on the website. SO, my question is: How the heck do you actually transfer data from the utf8-table to a latin1-table and properly re-encoding the text so that the latin1-table wouldn't contain raw utf8-data (because that my friends - sucks) Below are som excerps from SHOW VARIABLES - tell if your wan't more info... just included a few of the lines: +-+---+ | Variable_name | Value| +-+---+ | back_log| 50| | basedir | /pack/mysql-4.1.13/| | binlog_cache_size | 32768| | bulk_insert_buffer_size | 8388608| | character_set_client| latin1| | character_set_connection| latin1| | character_set_database | latin1| | character_set_results | latin1| | character_set_server| latin1| | character_set_system| utf8| | version | 4.1.13-log| +-+---+ Regards Morten Fangel // fangel
Re: Replication, charset / collations Problem
Hello. > `key` varchar(255) character set utf8 collate utf8_bin NOT NULL All your character_set_xxx variables have a 'latin1' value, while the `key` column has utf8. In my opinion, this is the root of the problem. Marco P$hler <[EMAIL PROTECTED]> wrote: >> Please, send the output of the following statement executed both on >> master and slave: >> >> show variables like '%char%'; > > mysql> show global variables like 'c%'; > +--++ > | Variable_name| Value | > +--++ > | character_set_client | latin1 | > | character_set_connection | latin1 | > | character_set_database | latin1 | > | character_set_results| latin1 | > | character_set_server | latin1 | > | character_set_system | utf8 | > | character_sets_dir | /usr/share/mysql/charsets/ | > | collation_connection | latin1_swedish_ci | > | collation_database | latin1_swedish_ci | > | collation_server | latin1_swedish_ci | > | concurrent_insert| ON | > | connect_timeout | 5 | > +--++ > 12 rows in set (0.00 sec) > > The output is identical on both servers. > >> Send the definition of your table as well: >> >> SHOW CREATE TABLE sum_day_key_requests; > > mysql> SHOW CREATE TABLE sum_day_key_requests \G > *** 1. row *** > Table: sum_day_key_requests > Create Table: CREATE TABLE `sum_day_key_requests` ( > `day` date NOT NULL default '-00-00', > `type` varchar(50) character set latin1 collate latin1_bin NOT NULL > default '', > `client` varchar(16) character set latin1 collate latin1_bin NOT NULL > default '', > `channel` varchar(16) character set latin1 collate latin1_bin NOT NULL > default '', > `campaign` varchar(100) character set latin1 collate latin1_bin NOT > NULL default '', > `grouping` varchar(64) character set latin1 collate latin1_bin NOT > NULL default '', > `key` varchar(255) character set utf8 collate utf8_bin NOT NULL > default '', > `afftraf` varchar(5) character set latin1 collate latin1_bin NOT NULL > default '', > `sum` int(10) unsigned NOT NULL default '1', > PRIMARY KEY > (`day`,`type`,`client`,`channel`,`campaign`,`grouping`,`key`,`afftraf`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 > 1 row in set (1.05 sec) > > The create statements are identical on both servers. > > I have no more ideas. Should I try to reproduce the error with a smaller > example ? > > Marco > --- > http://www.tuxoo.org > http://www.kontaktlinsen-preisvergleich.de > > > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication, charset / collations Problem
> Please, send the output of the following statement executed both on > master and slave: > > show variables like '%char%'; mysql> show global variables like 'c%'; +--++ | Variable_name| Value | +--++ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_results| latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | concurrent_insert| ON | | connect_timeout | 5 | +--++ 12 rows in set (0.00 sec) The output is identical on both servers. > Send the definition of your table as well: > > SHOW CREATE TABLE sum_day_key_requests; mysql> SHOW CREATE TABLE sum_day_key_requests \G *** 1. row *** Table: sum_day_key_requests Create Table: CREATE TABLE `sum_day_key_requests` ( `day` date NOT NULL default '-00-00', `type` varchar(50) character set latin1 collate latin1_bin NOT NULL default '', `client` varchar(16) character set latin1 collate latin1_bin NOT NULL default '', `channel` varchar(16) character set latin1 collate latin1_bin NOT NULL default '', `campaign` varchar(100) character set latin1 collate latin1_bin NOT NULL default '', `grouping` varchar(64) character set latin1 collate latin1_bin NOT NULL default '', `key` varchar(255) character set utf8 collate utf8_bin NOT NULL default '', `afftraf` varchar(5) character set latin1 collate latin1_bin NOT NULL default '', `sum` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`day`,`type`,`client`,`channel`,`campaign`,`grouping`,`key`,`afftraf`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (1.05 sec) The create statements are identical on both servers. I have no more ideas. Should I try to reproduce the error with a smaller example ? Marco --- http://www.tuxoo.org http://www.kontaktlinsen-preisvergleich.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication, charset / collations Problem
Hello. Please, send the output of the following statement executed both on master and slave: show variables like '%char%'; Send the definition of your table as well: SHOW CREATE TABLE sum_day_key_requests; Marco P$hler <[EMAIL PROTECTED]> wrote: > Hi, > > I try to replicate an existing database to a new server and run into > trouble with collations. Maybe somebody can help me. > > Existing DB-Server (Master): > MySQL Version 4.1.12 > ca. 100 GB Database size. > > New DB-Server (Slave): > MySQL Version 4.1.12 > > Here is what I did to get the replication up and running: > > - Shutdown MySQL on the Master > - Copy the MySQL datadir from the Master to the Slave (approx. 4 > hours :-) > - Startup the Master again and execute RESET MASTER to delete the > existing binlogs. > - Startup the Slave > > The Slave starts the replication, as I can see using SHOW PROCESSLIST on > the Slave. Afer a while the following error occured listed in > the .err-file. > > 050808 10:41:25 mysqld started > 050808 10:41:27 InnoDB: Started; log sequence number 70 1628293808 > /usr/sbin/mysqld: ready for connections. > Version: '4.1.12-standard-log' socket: '/var/lib/mysql/mysql.sock' > port: 3306 MySQL Community Edition - Standard (GPL) > 050808 10:42:11 [Note] Slave SQL thread initialized, starting > replication in log 'FIRST' at position 0, relay log > './HAL2006-relay-bin.01' position: 4 > 050808 10:42:11 [Note] Slave I/O thread: connected to master > '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at > position 4 > 050808 11:49:23 [ERROR] Slave: Error 'Illegal mix of collations > (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='' > on query. Default database: 'report'. Query: 'UPDATE > sum_day_key_requests SET sum = sum + 1 WHERE day = '2005-7-30' AND type > = 'redirect' AND client = '7865' AND channel = '78' AND campaign = 'DE > Conversion' AND grouping = 'Flirt- und Kontaktb$rse' AND `key` = 'Flirt > Kontakte' AND afftraf = 'NULL'', Error_code: 1267 > 050808 11:49:23 [ERROR] Error running query, slave SQL thread aborted. > Fix the problem, and restart the slave SQL thread with "SLAVE START". We > stopped at log 'HAL2005-bin.03' position 27769229 > > The only idea, which came into my mind, is that the server use different > default charsets or collations. I checked the configurations and can't > find a difference. Is there a possibility to check the default charsets > and collations on the running server ? > > thanks in advance > > Marco > > --- > http://www.tuxoo.de > http://www.kontaktlinsen-preisvergleich.de > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication, charset / collations Problem
Am Dienstag, den 09.08.2005, 17:57 +0400 schrieb Alexey Polyakov: > If charsets/collations are not set explicitly in my.cnf, server could > be using ones specified during compilation. > To check charsets and collations on the running server do: > show global variables like 'c%'; Thanks. I executed the statement on both servers and got identical results! So no diffenrence exists between the server configuration, right ? How can it be that I get the collation error ? Following the statement results: On the Master: -- HAL2005:~ # mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1803 to server version: 4.1.12-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show global variables like 'c%'; +--++ | Variable_name| Value | +--++ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_results| latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | concurrent_insert| ON | | connect_timeout | 5 | +--++ 12 rows in set (0.00 sec) On the Slave: - HAL2006:/var/lib/mysql # mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.1.12-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show global variables like 'c%'; +--++ | Variable_name| Value | +--++ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_results| latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | concurrent_insert| ON | | connect_timeout | 5 | +--++ 12 rows in set (0.07 sec) Any ideas ?! Marco --- http://www.tuxoo.de http://www.kontaktlinsen-preisvergleich.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication, charset / collations Problem
> The only idea, which came into my mind, is that the server use different > default charsets or collations. I checked the configurations and can't > find a difference. Is there a possibility to check the default charsets > and collations on the running server ? If charsets/collations are not set explicitly in my.cnf, server could be using ones specified during compilation. To check charsets and collations on the running server do: show global variables like 'c%'; -- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication, charset / collations Problem
Hi, I try to replicate an existing database to a new server and run into trouble with collations. Maybe somebody can help me. Existing DB-Server (Master): MySQL Version 4.1.12 ca. 100 GB Database size. New DB-Server (Slave): MySQL Version 4.1.12 Here is what I did to get the replication up and running: - Shutdown MySQL on the Master - Copy the MySQL datadir from the Master to the Slave (approx. 4 hours :-) - Startup the Master again and execute RESET MASTER to delete the existing binlogs. - Startup the Slave The Slave starts the replication, as I can see using SHOW PROCESSLIST on the Slave. Afer a while the following error occured listed in the .err-file. 050808 10:41:25 mysqld started 050808 10:41:27 InnoDB: Started; log sequence number 70 1628293808 /usr/sbin/mysqld: ready for connections. Version: '4.1.12-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) 050808 10:42:11 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './HAL2006-relay-bin.01' position: 4 050808 10:42:11 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 050808 11:49:23 [ERROR] Slave: Error 'Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='' on query. Default database: 'report'. Query: 'UPDATE sum_day_key_requests SET sum = sum + 1 WHERE day = '2005-7-30' AND type = 'redirect' AND client = '7865' AND channel = '78' AND campaign = 'DE Conversion' AND grouping = 'Flirt- und Kontaktbörse' AND `key` = 'Flirt Kontakte' AND afftraf = 'NULL'', Error_code: 1267 050808 11:49:23 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'HAL2005-bin.03' position 27769229 The only idea, which came into my mind, is that the server use different default charsets or collations. I checked the configurations and can't find a difference. Is there a possibility to check the default charsets and collations on the running server ? thanks in advance Marco --- http://www.tuxoo.de http://www.kontaktlinsen-preisvergleich.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL charset
Privet! Yogesh wrote: HI, I have a client that runs php+mysql application and it has a problem with "ORDER BY some_varchar_field" sql expression. The DB is in russian cp1251 encoding and "order by" doesnt produce an alphabetically ordered result. our mysql server default charset is latin1 and I don't know of any way to change it. I had similar problem. The only solution i'd found then was change encoding of my data on the fly. But it's not applicable if your table is rather big. Our version is MySQL 4.0.24 Is it possible to change charset fo a database in this version? I guess not. Default charset for database supported only since 4.1 Regards Yogesh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL charset
HI, I have a client that runs php+mysql application and it has a problem with "ORDER BY some_varchar_field" sql expression. The DB is in russian cp1251 encoding and "order by" doesnt produce an alphabetically ordered result. our mysql server default charset is latin1 and I don't know of any way to change it. Our version is MySQL 4.0.24 Is it possible to change charset fo a database in this version? Regards Yogesh
Re: Charset and collation question
Hello. Similar question has been asked already. See: http://lists.mysql.com/mysql/179154 "Stephane Savage" <[EMAIL PROTECTED]> wrote: > Hi all, > > Which charset and collatio would be the most suitable for a french / > english system? > > Thanks > > Stephane > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset and collation question
Hi all, Which charset and collatio would be the most suitable for a french / english system? Thanks Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.0 to 4.1 migration and charset problems
Hello. It is not clear from you message what's the problem. From your calculations I can see that the length of int field in a flat file row (BTW please send a piece of your file) is different in mysqldump programs with different versions? How is the length of integer fields related to character set? Please provide more information about the problem and if it is possible send a test case. Vivian Wang <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: us-ascii, 132 lines --] > > the version is 4.1.12. > show variables like this, > > | character_set_client| > latin1 > | character_set_connection| > latin1 > | character_set_database | > latin1 > | character_set_results | latin1 > | character_set_server| > latin1 > | character_set_system| > utf8 > | character_sets_dir | > /usr/share/mysql/charsets/ > | collation_connection| > latin1_swedish_ci > | collation_database | > latin1_swedish_ci > | collation_server| latin1_swedish_ci > > If the table is like test(name char(30), id1 int(4), id2 int(4)) > When I use mysqldump mysql version 3.23.??, l have the flat file row > length is 30+4+4=38. > When I use mysqldump mysql verson 4.1.12, I have the flat file row > length is 30+11+11=52. > > I tried mysqldump --set-charset=latin2, I still got a row length=52. > > What I should do? > > > Gleb Paharenko wrote: > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.0 to 4.1 migration and charset problems
the version is 4.1.12. show variables like this, | character_set_client| latin1 | character_set_connection| latin1 | character_set_database | latin1 | character_set_results | latin1 | character_set_server| latin1 | character_set_system| utf8 | character_sets_dir | /usr/share/mysql/charsets/ | collation_connection| latin1_swedish_ci | collation_database | latin1_swedish_ci | collation_server| latin1_swedish_ci If the table is like test(name char(30), id1 int(4), id2 int(4)) When I use mysqldump mysql version 3.23.??, l have the flat file row length is 30+4+4=38. When I use mysqldump mysql verson 4.1.12, I have the flat file row length is 30+11+11=52. I tried mysqldump --set-charset=latin2, I still got a row length=52. What I should do? Gleb Paharenko wrote: Hello. I've tested your solution. It doesn't work for users which have SUPER privilege. This mentioned at: http://dev.mysql.com/doc/mysql/en/server-system-variables.html However, it works with with ordinary users which don't have SUPER privilege. Here are pieces of my my.cnf (the init_connect is one big string without line breaks): [client] default_character_set=latin1 [mysqld] default_character_set=latin2 init_connect='SET @lchar = IF(@@session.character_set_client = _utf8"latin1", @@global.character_set_client, @@session.character_set_client); set @@[EMAIL PROTECTED]; set @@[EMAIL PROTECTED]; set @@[EMAIL PROTECTED]; ' When root user connects init_connect doesn't execute and we see: mysql> show variables like '%char%'; +--+---+ | Variable_name| Value | +--+---+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin2 | | character_set_results| latin1 | | character_set_server | latin2 | | character_set_system | utf8 | | When user without SUPER privilege connects we see: | Variable_name| Value | +--+---+ | character_set_client | latin2 | | character_set_connection | latin2 | | character_set_database | latin2 | | character_set_results| latin2 | | character_set_server | latin2 | | character_set_system | utf8 | So it works for me. http://dev.mysql.com/doc/mysql/en/mysqldump.html Dump & restore was done properly. dump on 4.0, add set names latin2; load i= nto=20 4.1. The problem is that by default connections from client are as latin1, = db=20 is latin2 so servers needs to do conversion from latin2->latin1 which can't= =20 be done and thus I'm getting '?' characters instead of latin2 characters. The thing I need is how to force default latin2 in all client connections e= ven=20 if client won't request latin2 by using set names. Tried doing things like in mysqld.conf: init-connect =3D SET @lchar =3D IF(@@session.character_set_client =3D _utf8= "latin1",=20 @@global.character_set_client, @@session.character_set_client); SET=20 character_set_client =3D @lchar; SET character_set_results =3D @lchar; SET= =20 character_set_connection =3D @lchar; but that doesn't work unfortunately from init-connect (works from mysql=20 cmdline client) ;-( =2D-=20 Arkadiusz Mi=B6kiewiczPLD/Linux Team http://www.t17.ds.pwr.wroc.pl/~misiek/ http://ftp.pld-linux.org/
Re: mysql 4.0 to 4.1 migration and charset problems
Hello. > Any possible problems with this approach? It is good, if it solved your problems. >> So it works for me. > > I've ended doing this in a different way. I've created a patch which forces= > a=20 > file to be read - /etc/mysql/mysql-client.conf (which is the same as .my.cn= > f)=20 > at mysql_init() time. All clients that use libmysqlclient.so should read it= > =20 > now. > > http://cvs.pld-linux.org/cgi-bin/cvsweb/SOURCES/mysql-client-config.patch?r= > ev=3D1.1 > > Now I can put defaults in that global config: > > [EMAIL PROTECTED] ~]$ more /etc/mysql/mysql-client.conf > [client] > default-character-set=3Dlatin2 > > Now all my clients connect with latin2 as default. > > Any possible problems with this approach? > > =2D-=20 > Arkadiusz Mi=B6kiewiczPLD/Linux Team > http://www.t17.ds.pwr.wroc.pl/~misiek/ http://ftp.pld-linux.org/ > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.0 to 4.1 migration and charset problems
On Monday 11 of July 2005 16:24, Gleb Paharenko wrote: > Hello. > > I've tested your solution. It doesn't work for users which have SUPER > privilege. This mentioned at: > http://dev.mysql.com/doc/mysql/en/server-system-variables.html > > However, it works with with ordinary users which don't have SUPER > privilege. Here are pieces of my my.cnf (the init_connect is one big string > without line breaks): > > [client] > > default_character_set=latin1 > > [mysqld] > default_character_set=latin2 > init_connect='SET @lchar = IF(@@session.character_set_client = > _utf8"latin1", @@global.character_set_client, > @@session.character_set_client); set > @@[EMAIL PROTECTED]; set > @@[EMAIL PROTECTED]; set > @@[EMAIL PROTECTED]; ' [...] > So it works for me. I've ended doing this in a different way. I've created a patch which forces a file to be read - /etc/mysql/mysql-client.conf (which is the same as .my.cnf) at mysql_init() time. All clients that use libmysqlclient.so should read it now. http://cvs.pld-linux.org/cgi-bin/cvsweb/SOURCES/mysql-client-config.patch?rev=1.1 Now I can put defaults in that global config: [EMAIL PROTECTED] ~]$ more /etc/mysql/mysql-client.conf [client] default-character-set=latin2 Now all my clients connect with latin2 as default. Any possible problems with this approach? -- Arkadiusz MiśkiewiczPLD/Linux Team http://www.t17.ds.pwr.wroc.pl/~misiek/ http://ftp.pld-linux.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.0 to 4.1 migration and charset problems
Hello. I've tested your solution. It doesn't work for users which have SUPER privilege. This mentioned at: http://dev.mysql.com/doc/mysql/en/server-system-variables.html However, it works with with ordinary users which don't have SUPER privilege. Here are pieces of my my.cnf (the init_connect is one big string without line breaks): [client] default_character_set=latin1 [mysqld] default_character_set=latin2 init_connect='SET @lchar = IF(@@session.character_set_client = _utf8"latin1", @@global.character_set_client, @@session.character_set_client); set @@[EMAIL PROTECTED]; set @@[EMAIL PROTECTED]; set @@[EMAIL PROTECTED]; ' When root user connects init_connect doesn't execute and we see: mysql> show variables like '%char%'; +--+---+ | Variable_name| Value | +--+---+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin2 | | character_set_results| latin1 | | character_set_server | latin2 | | character_set_system | utf8 | | When user without SUPER privilege connects we see: | Variable_name| Value | +--+---+ | character_set_client | latin2 | | character_set_connection | latin2 | | character_set_database | latin2 | | character_set_results| latin2 | | character_set_server | latin2 | | character_set_system | utf8 | So it works for me. >> http://dev.mysql.com/doc/mysql/en/mysqldump.html > Dump & restore was done properly. dump on 4.0, add set names latin2; load i= > nto=20 > 4.1. The problem is that by default connections from client are as latin1, = > db=20 > is latin2 so servers needs to do conversion from latin2->latin1 which can't= > =20 > be done and thus I'm getting '?' characters instead of latin2 characters. > > The thing I need is how to force default latin2 in all client connections e= > ven=20 > if client won't request latin2 by using set names. > > Tried doing things like in mysqld.conf: > > init-connect =3D SET @lchar =3D IF(@@session.character_set_client =3D _utf8= > "latin1",=20 > @@global.character_set_client, @@session.character_set_client); SET=20 > character_set_client =3D @lchar; SET character_set_results =3D @lchar; SET= > =20 > character_set_connection =3D @lchar; > > but that doesn't work unfortunately from init-connect (works from mysql=20 > cmdline client) ;-( > =2D-=20 > Arkadiusz Mi=B6kiewiczPLD/Linux Team > http://www.t17.ds.pwr.wroc.pl/~misiek/ http://ftp.pld-linux.org/ > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.0 to 4.1 migration and charset problems
On Thursday 07 of July 2005 00:16, Gleb Paharenko wrote: > Hello. > > > For a pity, I could give explanations only for your query about > selecting @@global.xxx variables. I think server returns correct > results, because you're selecting global variables, while > character_set_client, character_set_connection, character_set_results > are session variables. And with SET NAMES you're setting > @@character_xxx variables which are synonym for @@session.character_xxx. I see. > In what way have you done your upgrade? If you haven't used mysqldump > you could get some problems. Make the dump, and restore it setting > the correct connection variables for mysql program. Be aware of that > mysqldump could put SET NAMES at the beginning of the dump file. Use > set-names=latin2 for it. See: > http://dev.mysql.com/doc/mysql/en/mysqldump.html Dump & restore was done properly. dump on 4.0, add set names latin2; load into 4.1. The problem is that by default connections from client are as latin1, db is latin2 so servers needs to do conversion from latin2->latin1 which can't be done and thus I'm getting '?' characters instead of latin2 characters. The thing I need is how to force default latin2 in all client connections even if client won't request latin2 by using set names. Tried doing things like in mysqld.conf: init-connect = SET @lchar = IF(@@session.character_set_client = _utf8"latin1", @@global.character_set_client, @@session.character_set_client); SET character_set_client = @lchar; SET character_set_results = @lchar; SET character_set_connection = @lchar; but that doesn't work unfortunately from init-connect (works from mysql cmdline client) ;-( -- Arkadiusz MiśkiewiczPLD/Linux Team http://www.t17.ds.pwr.wroc.pl/~misiek/ http://ftp.pld-linux.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.0 to 4.1 migration and charset problems
Hello. For a pity, I could give explanations only for your query about selecting @@global.xxx variables. I think server returns correct results, because you're selecting global variables, while character_set_client, character_set_connection, character_set_results are session variables. And with SET NAMES you're setting @@character_xxx variables which are synonym for @@session.character_xxx. In what way have you done your upgrade? If you haven't used mysqldump you could get some problems. Make the dump, and restore it setting the correct connection variables for mysql program. Be aware of that mysqldump could put SET NAMES at the beginning of the dump file. Use set-names=latin2 for it. See: http://dev.mysql.com/doc/mysql/en/mysqldump.html Arkadiusz Miskiewicz <[EMAIL PROTECTED]> wrote: > Hi, > > I have mysql 4.0 db with configuration: > set-variable =3D default-character-set=3Dlatin2 > set-variable =3D character-set=3Dlatin2 > > now I'm trying to migrate to mysql 4.1.12 My current config is: > character-set-server=3Dlatin2 > collation-server=3Dlatin2_general_ci > > The problem is connection/reply/client-character set. mysql 4.1 by default= > =20 > uses 'latin1' so in all queries (from previously latin2 mysql 4.0 database)= > I=20 > don't have latin2 characters just '?' chars. That's obvious because due to= > =20 > default latin1 in 4.1. > > SET NAMES 'latin2' from client side of coruse cures whole problem but... I= > =20 > can't fix every possible application that my users have installed (and if=20 > there are thousands of users this is simply impossible). > > What's the proper way of dealing with this problem? I've tried to use some= > =20 > nasty hacks like init-connect=3D"SET NAMES latin2" and this half-works - I = > see=20 > latin2 characters in server responses... but it breaks for example phpmyadm= > in=20 > (characters are broken in results; when I drop init-connect hack phpmyadmin= > =20 > works nicely). So init-connect isn't usable. > > Now when connecting with mysql command line client then I by default get=20 > latin1 but can change easily to latin2 using=20 > [mysql] > default-character-set=3Dlatin2 > in .my.cnf file. That's great but this works only for mysql cmd line client= > =20 > _only_ while my primary concern is php. > > Now is the funny part, there is no .my.cnf file, I connect with mysql cmdli= > ne. > mysql> \s > =2D- > mysql Ver 14.7 Distrib 4.1.12, for pld-linux-gnu (powerpc) using readline = > 4.3 > > Connection id: 2 > Current database: > Current user: [EMAIL PROTECTED] > SSL:Not in use > Current pager: stdout > Using outfile: '' > Using delimiter:; > Server version: 4.1.12-log > Protocol version: 10 > Connection: Localhost via UNIX socket > Server characterset:latin2 > Db characterset:latin2 > Client characterset:latin1 > Conn. characterset:latin1 > UNIX socket:/var/lib/mysql/mysql.sock > Uptime: 34 min 35 sec > > Threads: 1 Questions: 12 Slow queries: 0 Opens: 11 Flush tables: 1 Ope= > n=20 > tables: 0 Queries per second avg: 0.006 > =2D- > > mysql> show variables like '%char%'; > +--++ > | Variable_name| Value | > +--++ > | character_set_client | latin1 | > | character_set_connection | latin1 | > | character_set_database | latin2 | > | character_set_results| latin1 | > | character_set_server | latin2 | > | character_set_system | utf8 | > | character_sets_dir | /usr/share/mysql/charsets/ | > +--++ > 7 rows in set (0.00 sec) > > As you can see client/connection/results are latin1 BUT: > > mysql> select @@global.character_set_client,=20 > @@global.character_set_connection, @@global.character_set_database,=20 > @@global.character_set_results, @@global.character_set_results,=20 > @@global.character_set_server; > +---+---+--= > =2D--++= > =2D---+---+ > | @@global.character_set_client | @@global.character_set_connection |=20 > @@global.character_set_database | @@global.character_set_results |=20 > @@global.character_set_results | @@global.character_set_server | > +---+---+--= > =2D--++= > =2D---+---+ > |
mysql 4.0 to 4.1 migration and charset problems
Hi, I have mysql 4.0 db with configuration: set-variable = default-character-set=latin2 set-variable = character-set=latin2 now I'm trying to migrate to mysql 4.1.12 My current config is: character-set-server=latin2 collation-server=latin2_general_ci The problem is connection/reply/client-character set. mysql 4.1 by default uses 'latin1' so in all queries (from previously latin2 mysql 4.0 database) I don't have latin2 characters just '?' chars. That's obvious because due to default latin1 in 4.1. SET NAMES 'latin2' from client side of coruse cures whole problem but... I can't fix every possible application that my users have installed (and if there are thousands of users this is simply impossible). What's the proper way of dealing with this problem? I've tried to use some nasty hacks like init-connect="SET NAMES latin2" and this half-works - I see latin2 characters in server responses... but it breaks for example phpmyadmin (characters are broken in results; when I drop init-connect hack phpmyadmin works nicely). So init-connect isn't usable. Now when connecting with mysql command line client then I by default get latin1 but can change easily to latin2 using [mysql] default-character-set=latin2 in .my.cnf file. That's great but this works only for mysql cmd line client _only_ while my primary concern is php. Now is the funny part, there is no .my.cnf file, I connect with mysql cmdline. mysql> \s -- mysql Ver 14.7 Distrib 4.1.12, for pld-linux-gnu (powerpc) using readline 4.3 Connection id: 2 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: stdout Using outfile: '' Using delimiter:; Server version: 4.1.12-log Protocol version: 10 Connection: Localhost via UNIX socket Server characterset:latin2 Db characterset:latin2 Client characterset:latin1 Conn. characterset:latin1 UNIX socket:/var/lib/mysql/mysql.sock Uptime: 34 min 35 sec Threads: 1 Questions: 12 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 0 Queries per second avg: 0.006 -- mysql> show variables like '%char%'; +--++ | Variable_name| Value | +--++ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin2 | | character_set_results| latin1 | | character_set_server | latin2 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--++ 7 rows in set (0.00 sec) As you can see client/connection/results are latin1 BUT: mysql> select @@global.character_set_client, @@global.character_set_connection, @@global.character_set_database, @@global.character_set_results, @@global.character_set_results, @@global.character_set_server; +---+---+-+++---+ | @@global.character_set_client | @@global.character_set_connection | @@global.character_set_database | @@global.character_set_results | @@global.character_set_results | @@global.character_set_server | +---+---+-+++---+ | latin2| latin2| latin2 | latin2 | latin2 | latin2 | +---+---+-+++---+ 1 row in set (0.00 sec) now it tells me that these are latin2!? Anyway primary question is how to deal with characters in mysql 4.0->4.1 conversion (how to get latin2 as default in client connections)? I've talked with few people on #mysql on freenode but we haven't seen any solution. -- Arkadiusz MiśkiewiczPLD/Linux Team http://www.t17.ds.pwr.wroc.pl/~misiek/ http://ftp.pld-linux.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: default connection charset - SOLVED
Hi, Luckily I already found the solution, may be it'll be usefull for someone else. All that was needed was adding the following line to my.cnf file: [mysqld] init-connect="SET NAMES koi8r" Regards Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)718-3322, 718-3115(fax) On Wed, 29 Jun 2005, Gleb Paharenko wrote: Privet. As I know, PHP usually takes the character set from the server. Please send part of your configuration file related to character sets. Varshavchick Alexander <[EMAIL PROTECTED]> wrote: Hi, I have mysql 4.1.12 started with the default charset 'koi8r' and I have the following problem: when connecting from PHP, the default results and connection charsets become latin1, so all not-latin characters get lost (they are displayed as ?). Of cause, if I explicitely set these charsets to koi8r in the PHP scripts after the mysql_connect statement, it starts working correctly, but the problem is, there are so many php scripts calling mysql_connect function that I cannot change them all. I tried adding the default-character-set options into my.cnf in the [mysql] section and it workso for mysql command line but not for the php. So is there any way of setting the default connection charset which will work from php? Or the only way is downgrading to mysql 4.0 to make the existing php script work? Regards Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)718-3322, 718-3115(fax) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: default connection charset
Privet. As I know, PHP usually takes the character set from the server. Please send part of your configuration file related to character sets. Varshavchick Alexander <[EMAIL PROTECTED]> wrote: > Hi, > > I have mysql 4.1.12 started with the default charset 'koi8r' and I have > the following problem: when connecting from PHP, the default > results and connection charsets become latin1, so all not-latin characters > get lost (they are displayed as ?). Of cause, if I explicitely set these > charsets to koi8r in the PHP scripts after the mysql_connect statement, it > starts working correctly, but the problem is, there are so many php > scripts calling mysql_connect function that I cannot change them all. > > I tried adding the default-character-set options into my.cnf in the > [mysql] section and it workso for mysql command line but not for the php. > > So is there any way of setting the default connection charset which will > work from php? Or the only way is downgrading to mysql 4.0 to make the > existing php script work? > > Regards > > > Alexander Varshavchick, Metrocom Joint Stock Company > Phone: (812)718-3322, 718-3115(fax) > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
default connection charset
Hi, I have mysql 4.1.12 started with the default charset 'koi8r' and I have the following problem: when connecting from PHP, the default results and connection charsets become latin1, so all not-latin characters get lost (they are displayed as ?). Of cause, if I explicitely set these charsets to koi8r in the PHP scripts after the mysql_connect statement, it starts working correctly, but the problem is, there are so many php scripts calling mysql_connect function that I cannot change them all. I tried adding the default-character-set options into my.cnf in the [mysql] section and it workso for mysql command line but not for the php. So is there any way of setting the default connection charset which will work from php? Or the only way is downgrading to mysql 4.0 to make the existing php script work? Regards Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)718-3322, 718-3115(fax) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Charset and LOAD DATA INFILE problem - solved
Finally I found the solution. Just short note for everybody who has problem with LOAD DATA INFILE and correct charset of the file. Loaded file must have SAME charset as DATABASE which contains target table of LOAD DATA command. Target table charset doesn't matter. I didn't find any note about it in manual but I think it is useful to know it. Dusan - Original Message - From: "Dušan Pavlica" <[EMAIL PROTECTED]> To: "list mysql" Sent: Monday, April 11, 2005 10:52 AM Subject: Charset and LOAD DATA INFILE problem Hello, I'm trying to convert tables from Paradox DBs to MySQL and I have a big problem with setting correct character set. I created small application which generates csv files which are in cp1250 (I can't change it, it's charset ofmy Paradox DBs). My databases and tables in MySQL are in latin2. I tried in MySQL client command SET NAMES cp1250 and then LOAD DATA INFILE but that didn't help. Some chars were screwed up. If I create SQL script from part of csv file and load it by command SOURCE 'script.sql' then everything is OK. So, does anybody know the way how to import files from CSV directly by LOAD DATA INFILE without difficult manual conversions to sql scripts? Thanks in advance for any help or ideas. Dusan Pavlica -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset and LOAD DATA INFILE problem
Hello, I'm trying to convert tables from Paradox DBs to MySQL and I have a big problem with setting correct character set. I created small application which generates csv files which are in cp1250 (I can't change it, it's charset ofmy Paradox DBs). My databases and tables in MySQL are in latin2. I tried in MySQL client command SET NAMES cp1250 and then LOAD DATA INFILE but that didn't help. Some chars were screwed up. If I create SQL script from part of csv file and load it by command SOURCE 'script.sql' then everything is OK. So, does anybody know the way how to import files from CSV directly by LOAD DATA INFILE without difficult manual conversions to sql scripts? Thanks in advance for any help or ideas. Dusan Pavlica
Re: configuring Mysql Query Browser with charset latin5
Hello. The general way to order a MySQL client to use some encoding is to execute SET NAMES 'encoding'. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html But, as said at: http://bugs.mysql.com/bug.php?id=6982 Query Browser starts a new session for every new query, except when you start a transaction. And your previous SET NAMES doesn't have an effect. So, you may start a transaction, and then execute SET NAMES. During all transaction your character_set_xxx variables should have the same values. Nagehan Sahin <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: us-ascii, 8 lines --] > > How can I configure Mysql Query Browser with charset latin5? > > Thanks.. > > > - > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
configuring Mysql Query Browser with charset latin5
How can I configure Mysql Query Browser with charset latin5? Thanks.. - Do you Yahoo!? Yahoo! Small Business - Try our new resources site!
Re: Importing a separated file into mysql, national charset problem??
Original Message From: "Oddvar Kragseth" <[EMAIL PROTECTED]> To: ; <[EMAIL PROTECTED]> Sent: Sunday, February 13, 2005 3:35 PM Subject: Importing a separated file into mysql, national charset problem?? > I'm importing a file into mysql. > > Most work fien, but numbers are given like this : > `487,90`116,40`4467,00` > > This creates a problem, as the decimal numbers are NOT read... i.e i > get 487.00 , 116.00 in my database. > > Is this a "national" problem as we use komma as a decimal seperator > in Norway? > > Do i set this in windows or in LOAD DATA INFILE statement?? > We have this problem too in Czech Republic :-) I resolve this problem using this method: 1) I create temporary table with identical tructure except decimal, real, double, float and numeric fields. All this fields (eg. NUMERIC(6,2) ) I define as VARCHAR with the same length. 2) I load data into temporary table using LOAD DATA INFILE 3) I convert all "numeric" values using UPDATE TABLE temptable SET numeric_field=REPLACE(numeric_field, ',' , '.') 4) I load (or append) data from temporary table into main table. Petr Vileta http://www.zivnosti.cz http://www.practisoft.cz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Importing a separated file into mysql, national charset problem??
I'm importing a file into mysql. Most work fien, but numbers are given like this : `487,90`116,40`4467,00` This creates a problem, as the decimal numbers are NOT read... i.e i get 487.00 , 116.00 in my database. Is this a "national" problem as we use komma as a decimal seperator in Norway? Do i set this in windows or in LOAD DATA INFILE statement?? Oddvar Kragseth
Charset problem
Hi, sometime ago my boss imported a dump into a base using Cocoa MySQL on Mac. Unfortunatly he switch the charset from ISO-8859-1 to something wrong, probably UTF-8. From this time we have such weird characters in our fields : FerrandiËre instead of Ferrandière, CitÈ instead of Citée and so on. The other problem is that he noticed mistake a few days after the import and he had trashed the correctly encoded dump in the meantime. So now we have only a base with wrongly encoded fields values. What is the way to fix that please ? Thanks in advance. Jean-Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: charset latin1_de removed in 4.1.4?
At 18:13 +0200 9/15/04, Marten Lehmann wrote: Hello, in 4.0.20 I was happy that German Umlauts are sorted correctly (ä -> ae, ö -> oe, ü -> ue). With 4.1.4 the configuration stops: checking "character sets"... configure: error: Charset 'latin1_de' not available. (Available are: binary ascii armscii8 ascii big5 cp1250 cp1251 cp1256 cp1257 cp850 cp852 cp866 dec8 euckr gb2312 gbk geostd8 greek hebrew hp8 keybcs2 koi8r koi8u latin1 latin2 latin5 latin7 macce macroman sjis swe7 tis620 ucs2 ujis utf8). See the Installation chapter in the Reference Manual. Is latin1 in 4.1.4 able to sort correctly? What happens to clients that are using latin1_de as default-character set, but the server is only able to handle latin1? Will they receive errors? In 4.1, character set and collation are separate. You want character set latin1 and collation latin1_german1_ci or latin1_german2_ci. The differences are described here: http://dev.mysql.com/doc/mysql/en/Charset-we-sets.html ./configure --help will show you the relevant configuration options to use. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
charset latin1_de removed in 4.1.4?
Hello, in 4.0.20 I was happy that German Umlauts are sorted correctly (ä -> ae, ö -> oe, ü -> ue). With 4.1.4 the configuration stops: checking "character sets"... configure: error: Charset 'latin1_de' not available. (Available are: binary ascii armscii8 ascii big5 cp1250 cp1251 cp1256 cp1257 cp850 cp852 cp866 dec8 euckr gb2312 gbk geostd8 greek hebrew hp8 keybcs2 koi8r koi8u latin1 latin2 latin5 latin7 macce macroman sjis swe7 tis620 ucs2 ujis utf8). See the Installation chapter in the Reference Manual. Is latin1 in 4.1.4 able to sort correctly? What happens to clients that are using latin1_de as default-character set, but the server is only able to handle latin1? Will they receive errors? Regards Marten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.x charset
It's possibly due to your ssh connection but I couldn't answer you about this because I only use mysql with phpmyadmin. Regards Yves wrote: Thanks, As it turns out, I was trying show variables like -- And had a syntax mistake Does SHOW VARIABLES only show a certain number of lines? When I ran this command, character_set was not listed... the list seemed cut off just before it. Unless it is an issue with SSH only showing x amount of lines.. thanks, Yves A --- Jean-Marc PULVAR <[EMAIL PROTECTED]> wrote: You can see it by executing the "SHOW VARIABLES" query on your server. You will find the used charset in the 'character_set' variable. You can also use the query "SHOW VARIABLES LIKE 'character_set'" which will directly match what you want. Yves wrote: Hello, How can I see what char set is being used as the default char set on the server or database? Also, is there a way to change the default setting? Thanks, Yves __ Post your free ad now! http://personals.yahoo.ca -- --- ___ _ __ / __\ ___ ___ _ __ | |_ _ _ (__) /__\/// _ \ / _ \| '_ \| __| | | | || / \/ \ (_) | (_) | | | | |_| |_| | || \_/\___/ \___/|_| |_|\__|\__, | ___|""|__.._ |___/ /\ \/~~~ Jean-Marc PULVAR (Web Programmer) Boonty SA 4 bis villa du mont tonnerre 75015 PARIS --- __ Post your free ad now! http://personals.yahoo.ca -- --- ___ _ __ / __\ ___ ___ _ __ | |_ _ _ (__) /__\/// _ \ / _ \| '_ \| __| | | | || / \/ \ (_) | (_) | | | | |_| |_| | || \_/\___/ \___/|_| |_|\__|\__, | ___|""|__.._ |___/ /\ \/~~~ Jean-Marc PULVAR (Web Programmer) Boonty SA 4 bis villa du mont tonnerre 75015 PARIS --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.x charset
Thanks, As it turns out, I was trying show variables like -- And had a syntax mistake Does SHOW VARIABLES only show a certain number of lines? When I ran this command, character_set was not listed... the list seemed cut off just before it. Unless it is an issue with SSH only showing x amount of lines.. thanks, Yves A --- Jean-Marc PULVAR <[EMAIL PROTECTED]> wrote: > You can see it by executing the "SHOW VARIABLES" > query on your server. > You will find the used charset in the > 'character_set' variable. > > You can also use the query "SHOW VARIABLES LIKE > 'character_set'" which > will directly match what you want. > > Yves wrote: > > > Hello, > > > > How can I see what char set is being used as the > > default char set on the server or database? > > > > Also, is there a way to change the default > setting? > > > > Thanks, > > > > Yves > > > > > __ > > > Post your free ad now! http://personals.yahoo.ca > > > > -- > --- > ___ _ > __ / __\ ___ ___ _ __ | |_ _ _ > (__) /__\/// _ \ / _ \| '_ \| __| | | | > || / \/ \ (_) | (_) | | | | |_| |_| | > || \_/\___/ \___/|_| |_|\__|\__, | > ___|""|__.._ |___/ > /\ > \/~~~ Jean-Marc PULVAR (Web > Programmer) >Boonty SA >4 bis villa du mont tonnerre >75015 PARIS > --- > __ Post your free ad now! http://personals.yahoo.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.x charset
You can see it by executing the "SHOW VARIABLES" query on your server. You will find the used charset in the 'character_set' variable. You can also use the query "SHOW VARIABLES LIKE 'character_set'" which will directly match what you want. Yves wrote: Hello, How can I see what char set is being used as the default char set on the server or database? Also, is there a way to change the default setting? Thanks, Yves __ Post your free ad now! http://personals.yahoo.ca -- --- ___ _ __ / __\ ___ ___ _ __ | |_ _ _ (__) /__\/// _ \ / _ \| '_ \| __| | | | || / \/ \ (_) | (_) | | | | |_| |_| | || \_/\___/ \___/|_| |_|\__|\__, | ___|""|__.._ |___/ /\ \/~~~ Jean-Marc PULVAR (Web Programmer) Boonty SA 4 bis villa du mont tonnerre 75015 PARIS --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.x charset
Hello, How can I see what char set is being used as the default char set on the server or database? Also, is there a way to change the default setting? Thanks, Yves __ Post your free ad now! http://personals.yahoo.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Current server charset?
Hi Tobias, > On Tue, 6 Jan 2004, Martijn Tonies wrote: > > > Hi, > > > > In MySQL 4.1, is there a function to know what the > > current default server-wide characterset is? > > You can find all those with: > SHOW VARIABLES LIKE 'character_set%' Thanks, that'll do the trick. Is there any reason why variable "character-sets-dir" is with "-" instead of "_"s? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Current server charset?
On Tue, 6 Jan 2004, Martijn Tonies wrote: > Hi, > > In MySQL 4.1, is there a function to know what the > current default server-wide characterset is? You can find all those with: SHOW VARIABLES LIKE 'character_set%' cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Current server charset?
Hi, In MySQL 4.1, is there a function to know what the current default server-wide characterset is? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ALTER Charset/collation for columns/tables
Hi, Is altering a table and column supported for the characterset/collation? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with MySQL 4.1.1 and german charset
Hi! I compiled mysql 4.1.1 today and used the following config: #v+ --with-character-set=latin1 \ --with-collation=latin1_german1_ci \ --with-extra-charsets=all #v- ./configure and make worked fine, but make test failed: #v+ cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/share/english/ 031218 17:57:19 COLLATION 'latin1_german1_ci' is not valid for CHARACTER SET 'latin1' 031218 17:57:19 Aborting 031218 17:57:19 ../sql/mysqld: Shutdown Complete Error executing mysqld --bootstrap Error: Could not install master test DBs make: *** [test] Error 1 #v- Why is the collation not valid for charset latin1? It certainly should be... Greetings from Germany Sebastian Wiesinger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A new charset without recompiling
Can I put a new charset or modify an existing one without recompiling MySQL? If yes, please tell me how. Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please HELP Romanian charset Collate in MySQL
Iulian, this is in the manual. Look at Database Administration Localisation Character arrays Regards, Thomas Spahni On Wed, 30 Jul 2003, Primaria Falticeni wrote: > I can copy the latin2.conf into new one, but I need to know what each code > from the conf file represents and how can I obtain the relation from these > codes and the chars.So that's two problems: > 1) Can I use asc function or what function I need to know to obtain the > codes from the chars? > 2) How is the way to arrange the codes in the conf file? Assuming that I > know the codes for each characters (found at the above point) how can I put > these codes in the three tables within the latin2.conf file? > > - Original Message - > From: "Primaria Falticeni" <[EMAIL PROTECTED]> > To: "MySQL LIST" <[EMAIL PROTECTED]> > Sent: Monday, July 28, 2003 10:00 PM > Subject: Please HELP Romanian charset Collate in MySQL > > > > Hello, > > > > Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to > > sort > > it, in fact to order it in a query. > > > > I settled the default_charset to some charsets: > > latin1(default)(latin2 win1250(central european)) > > ÎteIbur > > Ibur Îte > > ItoIto > > > > The correct result must be: Ibur, Ito, Îte in ascending order. > > > > How can I do this? Please give me an example at how can I change the > > latin2.conf in a romanian one to fairly sort the chars for me. I must do > > change the behaviour and I don't know how. > > > > Thanks Anticipated, > > > > Iulian Teodosiu > > Economist/Analyst Programmer > > Primaria Falticeni > > Falticeni (town), jud. Suceava > > Romania, Europe > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please HELP Romanian charset Collate in MySQL
I can copy the latin2.conf into new one, but I need to know what each codefrom the conf file represents and how can I obtain the relation from thesecodes and the chars.So that's two problems:1) Can I use asc function or what function I need to know to obtain thecodes from the chars?2) How is the way to arrange the codes in the conf file? Assuming that Iknow the codes for each characters (found at the above point) how can I putthese codes in the three tables within the latin2.conf file?- Original Message -From: "Primaria Falticeni" <[EMAIL PROTECTED]>To: "MySQL LIST" <[EMAIL PROTECTED]>Sent: Monday, July 28, 2003 10:00 PMSubject: Please HELP Romanian charset Collate in MySQL> Hello,>> Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to> sort> it, in fact to order it in a query.>> I settled the default_charset to some charsets:> latin1(default) (latin2 win1250(central european))> Îte Ibur> Ibur Îte> Ito Ito>> The correct result must be: Ibur, Ito, Îte in ascending order.>> How can I do this? Please give me an example at how can I change the> latin2.conf in a romanian one to fairly sort the chars for me. I must do> change the behaviour and I don't know how.>> Thanks Anticipated,>> Iulian Teodosiu> Economist/Analyst Programmer> Primaria Falticeni> Falticeni (town), jud. Suceava> Romania, Europe>>>> --> MySQL General Mailing List> For list archives: http://lists.mysql.com/mysql> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
Re: Please URGENTLY Romanian charset Collate in MySQL
Iulian, take the source code, go to 'sql/share/charsets' and create your own character set 'romanian.conf' departing from 'latin2.conf' (or whatever is closest to what you need). Regards, Thomas Spahni On Mon, 28 Jul 2003, Primaria Falticeni wrote: > Hello, > > Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to sort > it, in fact to order it in a query. > > I settled the default_charset to some charsets: > latin1(default)(latin2(iso-8859-2 I think) the same like > win1250(central european)) > SteSbur > Sbur Ste > StoSto > > The correct result must be: Sbur, Sto, Ste in ascending order. > > How can I do this? Please give me an example at how can I change the > latin2.conf in a romanian one to fairly sort the chars for me. I must do > change the behaviour and I don't know how. > > Thanks Anticipated, > > Iulian Teodosiu > Economis/Analyst Programmer > Primaria Falticeni > Falticeni (town), jud. Suceava > Romania, Europe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please HELP Romanian charset Collate in MySQL
Hi! On Jul 28, Primaria Falticeni wrote: > Hello, > > Simply I made a table with romanian characters "aAsStT". I tried to > sort it, in fact to order it in a query. > > How can I do this? Please give me an example at how can I change the > latin2.conf in a romanian one to fairly sort the chars for me. I must do > change the behaviour and I don't know how. check http://www.mysql.com/doc/en/Localisation.html Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please HELP Romanian charset Collate in MySQL
Hello, Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to sort it, in fact to order it in a query. I settled the default_charset to some charsets: latin1(default)(latin2 win1250(central european)) ÎteIbur Ibur Îte ItoIto The correct result must be: Ibur, Ito, Îte in ascending order. How can I do this? Please give me an example at how can I change the latin2.conf in a romanian one to fairly sort the chars for me. I must do change the behaviour and I don't know how. Thanks Anticipated, Iulian Teodosiu Economist/Analyst Programmer Primaria Falticeni Falticeni (town), jud. Suceava Romania, Europe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please URGENTLY Romanian charset Collate in MySQL
Hello, Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to sort it, in fact to order it in a query. I settled the default_charset to some charsets: latin1(default)(latin2(iso-8859-2 I think) the same like win1250(central european)) SteSbur Sbur Ste StoSto The correct result must be: Sbur, Sto, Ste in ascending order. How can I do this? Please give me an example at how can I change the latin2.conf in a romanian one to fairly sort the chars for me. I must do change the behaviour and I don't know how. Thanks Anticipated, Iulian Teodosiu Economis/Analyst Programmer Primaria Falticeni Falticeni (town), jud. Suceava Romania, Europe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
charset=latin1 problem
Hello I have two MySQL 4.1 servers installed. One at home and at my work. Both run WinXP. I used mysqldump to export my database at work and tried to import it at my home server, I am getting the following error in one of the - create table defintaion Error Code : 1064 You have an error in your SQL syntax near 'CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='Inneholder abonnementdata'' at line 38 (113 ms taken) The create table query is as follows CREATE TABLE `abonnenter` ( `id` int(11) NOT NULL auto_increment, `navn` varchar(100) NOT NULL default '', `abonr` varchar(20) NOT NULL default '', `adresse` varchar(50) NOT NULL default '0', `post` varchar(50) NOT NULL default '0', `telefon` varchar(20) default NULL, `telefax` varchar(20) default NULL, `epost` varchar(100) default NULL, `web` varchar(50) default NULL, `kp_navn` varchar(50) NOT NULL default '', `kp_telefon` varchar(20) NOT NULL default '', `kp_epost` varchar(50) default '', `abbtype` varchar(10) NOT NULL default '0', `tdato` date NOT NULL default '-00-00', `kresp` enum('J','N') NOT NULL default 'N', `passord` varchar(20) binary NOT NULL default '', `sdato` datetime NOT NULL default '-00-00 00:00:00', `sist_innlogget` datetime NOT NULL default '-00-00 00:00:00', `kandidat_brukernavn` varchar(30) default NULL, `skifte_passord` enum('TRUE','FALSE') NOT NULL default 'FALSE', `po_spm` varchar(100) NOT NULL default '', `po_svar` varchar(100) NOT NULL default '', `visinfo` enum('TRUE','FALSE') NOT NULL default 'TRUE', `regdato` datetime NOT NULL default '-00-00 00:00:00', `selgernr` varchar(30) NOT NULL default '', `status` varchar(30) NOT NULL default 'Aktiv', PRIMARY KEY (`id`,`abonr`), UNIQUE KEY `abonr` (`abonr`), UNIQUE KEY `id` (`id`), UNIQUE KEY `abonr_index` (`abonr`), UNIQUE KEY `kandidat_brukernavn_index` (`kandidat_brukernavn`(10)), KEY `id_2` (`id`), FULLTEXT KEY `navn` (`navn`), FULLTEXT KEY `navn_2` (`navn`), FULLTEXT KEY `navn_3` (`navn`) ) TYPE=MyISAM CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='Inneholder abonnementdata'; When I try to exeucte it at my work office, everything works fine? Why the anomaly? Is my home MySQL configuration missing something? Even this query is returning me error - CREATE TABLE `aboutvidelser` ( `id` int(11) unsigned NOT NULL auto_increment, `abonr` varchar(20) character set latin1 NOT NULL default '0', `udato` datetime NOT NULL default '-00-00 00:00:00', `abotype` char(1) character set latin1 NOT NULL default 'O', `antall` smallint(5) unsigned NOT NULL default '0', `selgerid` int(11) unsigned NOT NULL default '0', `stat` enum('aktiv','slettet') character set latin1 NOT NULL default 'aktiv', `slettetdato` datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`id`), KEY `abonr_index` (`abonr`), KEY `selgerid_index` (`selgerid`) ) TYPE=MyISAM; The error returned for the above case is - You have an error in your SQL syntax near 'character set latin1 NOT NULL default '0', `udato` datetime NOT NULL default '' at line 4 Thanks in advance. Karam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset=latin1 problem
Hello I have two MySQL 4.1 servers installed. One at home and at my work. Both run WinXP. I used mysqldump to export my database at work and tried to import it at my home server, I am getting the following error in one of the - create table defintaion Error Code : 1064 You have an error in your SQL syntax near 'CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='Inneholder abonnementdata'' at line 38 (113 ms taken) The create table query is as follows CREATE TABLE `abonnenter` ( `id` int(11) NOT NULL auto_increment, `navn` varchar(100) NOT NULL default '', `abonr` varchar(20) NOT NULL default '', `adresse` varchar(50) NOT NULL default '0', `post` varchar(50) NOT NULL default '0', `telefon` varchar(20) default NULL, `telefax` varchar(20) default NULL, `epost` varchar(100) default NULL, `web` varchar(50) default NULL, `kp_navn` varchar(50) NOT NULL default '', `kp_telefon` varchar(20) NOT NULL default '', `kp_epost` varchar(50) default '', `abbtype` varchar(10) NOT NULL default '0', `tdato` date NOT NULL default '-00-00', `kresp` enum('J','N') NOT NULL default 'N', `passord` varchar(20) binary NOT NULL default '', `sdato` datetime NOT NULL default '-00-00 00:00:00', `sist_innlogget` datetime NOT NULL default '-00-00 00:00:00', `kandidat_brukernavn` varchar(30) default NULL, `skifte_passord` enum('TRUE','FALSE') NOT NULL default 'FALSE', `po_spm` varchar(100) NOT NULL default '', `po_svar` varchar(100) NOT NULL default '', `visinfo` enum('TRUE','FALSE') NOT NULL default 'TRUE', `regdato` datetime NOT NULL default '-00-00 00:00:00', `selgernr` varchar(30) NOT NULL default '', `status` varchar(30) NOT NULL default 'Aktiv', PRIMARY KEY (`id`,`abonr`), UNIQUE KEY `abonr` (`abonr`), UNIQUE KEY `id` (`id`), UNIQUE KEY `abonr_index` (`abonr`), UNIQUE KEY `kandidat_brukernavn_index` (`kandidat_brukernavn`(10)), KEY `id_2` (`id`), FULLTEXT KEY `navn` (`navn`), FULLTEXT KEY `navn_2` (`navn`), FULLTEXT KEY `navn_3` (`navn`) ) TYPE=MyISAM CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='Inneholder abonnementdata'; When I try to exeucte it at my work office, everything works fine? Why the anomaly? Is my home MySQL configuration missing something? Even this query is returning me error - CREATE TABLE `aboutvidelser` ( `id` int(11) unsigned NOT NULL auto_increment, `abonr` varchar(20) character set latin1 NOT NULL default '0', `udato` datetime NOT NULL default '-00-00 00:00:00', `abotype` char(1) character set latin1 NOT NULL default 'O', `antall` smallint(5) unsigned NOT NULL default '0', `selgerid` int(11) unsigned NOT NULL default '0', `stat` enum('aktiv','slettet') character set latin1 NOT NULL default 'aktiv', `slettetdato` datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`id`), KEY `abonr_index` (`abonr`), KEY `selgerid_index` (`selgerid`) ) TYPE=MyISAM; The error returned for the above case is - You have an error in your SQL syntax near 'character set latin1 NOT NULL default '0', `udato` datetime NOT NULL default '' at line 4 Thanks in advance. Karam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: How can i change charset in mysql ?
On Wednesday 02 April 2003 20:30, Pratchaya Chatuphian wrote: > I use MDK 9.0 and installed MySQL 4.0.12 Max ... sir > How can i change charset sir ? > i want to use tis-620 .. sir > Any one can help me sir ... ? > > Just mean change the my.conf ? ( my-small.conf , my-medium.conf , ) You you should rename one of this file to my.cnf and put it to the /etc dir. Add into [mysqld] section (not [client] section! ) default-character-set=tis620 [skip] > that can not found tis620.conf ? > How do i do next step sir > ? Because it's a multi-byte character set. It's implemented in the ctype-tis620.c file (you can see it in the /strings dir of source distribution) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Inserting blob in database with gbk charset may cause error or data corruption
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Inserting blob in database with gbk charset may cause error or data corruption Description: When mysql's sql statement lexer (sql/sql_lex.cpp)) analyzes a sql string, it uses the my_ismbchar macro on the default charset structure to identify and skip multibyte characters. The gbk charset's implementation of ismbchar (in strings/ctype-gbk.c) checks if the first byte is between 0x81 and 0xfe, and the second byte is between 0x40 to 0x7e or 0x80 to 0xfe, if they are then the two bytes are recognized as a gbk character and are skipped in the lexer. The problem is the sql esacpe character '\' (0x5C) falls in the second range. When escaping a piece of binary data, it is possible the '\' inserted will form a valid gbk character with a previous byte and get skipped in lexer, which leads to incorrect behavior. How-To-Repeat: 1. Error: -- Add "default-character-set = gbk" in C:/my.cnf, restart mysql database. -- Create a new table with a blob column: DROP DATABASE IF EXISTS test; CREATE DATABASE test; USE test; DROP TABLE IF EXISTS t_blob_test; CREATE TABLE t_blob_test ( n_id int(11) NOT NULL default '0', b_blob blob, PRIMARY KEY (n_id) ); -- Attempt to insert 0xEE 27 45 to the blob column (I used MySQL Connector/J, but anything that properly escapes the sql statement should do, handcrafted sql is "USE test;INSERT INTO t_blob_test values (1, '...');", where ... is the escaped binary data), and an error "You have an error in your SQL syntax near ... at line 1" is generated What happened is: -- According to section 6.1.1 of the mysql manual, 0x27 must be escaped by '\'', i.e. 0x5C 27, the resulting sequence is 0xEE 5C 27 45 -- Once the sequence reaches the server, the sql lexer uses gbk's ismbchar to determine that 0xEE 5C is a gbk character and skips them. The next byte the lexer encounters is the unescaped single quote 0x27, it then decides this is the end of the column data. The byte after 0x27 is 0x45, i.e. ASCII char 'E', which the lexer regards as an syntax error. 2. Data Corruption -- Same setup as 1 -- Attempt to insert 0xEE 22 to the blob column, the data will be inserted as 0xEE 5C 22 What happened is: -- Notice 0xEE 22 is not a valid gbk character, so escape processing will be used, it is escaped to 0xEE 5C 22 -- At the server side, 0xEE 5C is recognized as a gbk character and gets skipped, 0x22 is inserted normally, which produces 0xEE 5C 22 in the column Fix: Avoid using binary data insert/update in gbk database is the only one I can think of. A way to disable multibyte skipping behavior when processing binary data may be a solution. Synopsis: Inserting blob in database with gbk charset may cause error or data corruption Originator: RJX MySQL support: none Severity: serious Priority: medium Category: mysqld Class: sw-bug Release:mysql-3.23.56, mysql-4.0.12 Exectutable: mysqld-nt (run as a service) Environment1: Custom built Duron 800, 128MB Memory, 40GB HD Environment2: Toshiba Tecra 8100, PIII 550, 256MB Memory, 40GB HD System:Win2000 Professional SP3 (both Chinese & Engish version) __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can i change charset in mysql ?
I use MDK 9.0 and installed MySQL 4.0.12 Max ... sir How can i change charset sir ? i want to use tis-620 .. sir Any one can help me sir ... ? Just mean change the my.conf ? ( my-small.conf , my-medium.conf , ) to add [client] default-character-set=character-tis620 ? just do it ? ... sir ..and second .. i want to know the command how to start mysql with --default-charset=tis620 sir .. ?and third question , i saw the files in " folder " " /usr/share/mysql/charsets "i saw -rwxr-xr-x1 root root 4386 Mar 17 13:35 cp1251.conf*-rwxr-xr-x 1 root root 4399 Mar 17 13:35 cp1257.conf*-rwxr-xr-x1 root root 4385 Mar 17 13:35 croat.conf*-rwxr-xr-x1 root root 4386 Mar 17 13:35 danish.conf*-rwxr-xr-x1 root root 4384 Mar 17 13:35 dec8.conf*-rwxr-xr-x1 root root 4383 Mar 17 13:35 dos.conf*-rwxr-xr-x 1 root root 4400 Mar 17 13:35 estonia.conf*-rwxr-xr-x1 root root 4387 Mar 17 13:35 german1.conf*-rwxr-xr-x1 root root 4385 Mar 17 13:35 greek.conf*-rwxr-xr-x1 root root 4386 Mar 17 13:35 hebrew.conf*-rwxr-xr-x1 root root 4383 Mar 17 13:35 hp8.conf*-rwxr-xr-x1 root root 4389 Mar 17 13:35 hungarian.conf*-rwxr-xr-x1 root root 621 Mar 17 13:35 Index*-rwxr-xr-x1 root root 4387 Mar 17 13:35 koi8_ru.conf*-rwxr-xr-x 1 root root 4388 Mar 17 13:35 koi8_ukr.conf*-rwxr-xr-x1 root root 4386 Mar 17 13:35 latin1.conf*-rwxr-xr-x1 root root 4386 Mar 17 13:35 latin2.conf*-rwxr-xr-x1 root root 4545 Mar 17 13:35 latin5.conf*-rwxr-xr-x1 root root 1758 Mar 17 13:35 README*-rwxr-xr-x 1 root root 4384 Mar 17 13:35 swe7.conf*-rwxr-xr-x1 root root 4384 Mar 17 13:35 usa7.conf*-rwxr-xr-x1 root root 4400 Mar 17 13:35 win1250.conf*-rwxr-xr-x1 root root 4618 Mar 17 13:35 win1251.conf*-rwxr-xr-x1 root root 4471 Mar 17 13:35 win1251ukr.conf* that can not found tis620.conf ? How do i do next step sir ? Thank you for advance sir ...pratchaya chatuphian
re: How can i change the charset in MySQL after Install with RPM Package MDK
On Tuesday 01 April 2003 23:34, Pratchaya Chatuphian wrote: > I use MDK 9.0 and use MySQL installed with RPM Package > > How can i change or set new charset on mysql . > > Caz , i want to use tis620 charset .. > > I live in thailand and must use charset that i can sort my data correctly > on my MySQL ... sir Specify default-character-set=tis620 in my.cnf file or start MySQl server with --default-character-set=tis620 option: http://www.mysql.com/doc/en/Character_sets.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can i change the charset in MySQL after Install with RPM Package MDK
I use MDK 9.0 and use MySQL installed with RPM Package How can i change or set new charset on mysql . Caz , i want to use tis620 charset .. I live in thailand and must use charset that i can sort my data correctly on my MySQL ... sir Thank u for advance sir . [EMAIL PROTECTED] " Every day is a new beginning "
estonia charset and upper/lower case
Hello! When I run mysql with default-charset = estonia, it makes difference between upper and lower case. With latin1 charset no such distinction are made. Could someone clarify for me, is it bug? -- Lauri Anton ( [EMAIL PROTECTED] ) ( +3727302126 ) - estonia - Server version: 3.23.49 Client characterset:latin1 Server characterset:estonia mysql> select * from a; ++--+ | id | str | ++--+ | 1 | AAA | | 2 | Aaa | | 3 | aaa | ++--+ 3 rows in set (0.00 sec) mysql> select * from a where str like 'AAA'; ++--+ | id | str | ++--+ | 1 | AAA | ++--+ 1 row in set (0.00 sec) - latin1 -- Server version: 3.23.49 Client characterset:latin1 Server characterset:latin1 mysql> select * from a; ++--+ | id | str | ++--+ | 1 | AAA | | 2 | Aaa | | 3 | aaa | ++--+ 3 rows in set (0.00 sec) mysql> select * from a where str like 'AAA'; ++--+ | id | str | ++--+ | 1 | AAA | | 2 | Aaa | | 3 | aaa | ++--+ 3 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Charset and French Diacritic Characters
Hello Xavier, can't you do the transforming of your keywords before doing the query ? to transform all special characters in php it would be : $keywords = strtr($keywords,"éè^éëàãâä","_"); add other special characters and a JOKER sign in mysql '_' for each. Cheers, Damien - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Charset and French Diacritic Characters
Hello everybody, I'm french and use MySQL 3.23.40 on the Windows environment. And I have a problem with the "special french" characters (é, è, ê, à, â, etc.)... I want that the search queries are insensitive to those special characters. So that, for example, the "é" character is handled as the "e" character. and the query "élégant" finds "elegant". A very common problem I think, but until now I have no simple solution (and find nothing interesting on the Net) ! I read the MySQL manual about the charsets and their handling. It seeems that, for a given charset, sorting, "upper casing" and "lower casing" are done according to the configuration stored into the "charset.conf" file... (with the 4 arrays ctype[ ], to_lower[ ], to_upper[ ] and sort_order[ ]). By default, the charset used by my MySQL is Latin1. According to the "Latin1.conf" file (and the sort_order[ ] array), the "é" character is sorted (and compared) as the "e" character... But it does not work ! WHY ? Obviously, there is something that I don't understand, but what ? What can I do ? What should I do to obtain that the queries are insensitive to french characters ? Any help will be appreciated ! Best Regards ! Xavier LENOIR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlcc 0.8.7-alfa (win32) not supporting russian charset?
Hello when using mysqlcc and adding for russian symbols into database fields, it represents as "??" When using other client - all is o'k. the repeatable steps are: 1. open mysqlcc 2. open some table 3. enter in the field of type "string" some russian letters 4. uddate this record 5. see the "??" instead of russian letters --- regards, Dmitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL DELPHI(Kylix) charset translation
Hi, I have problem with charset (MySQL + Delphi). -- SET CHARACTER SET cp1250_latin2; SELECT * FROM en1 WHERE en1 LIKE 'worm'; -- This query works right in PHP and command line (Linux, Windows), but in Delphi7 (Kylix3) line "SET CHARACTER SET cp1250_latin2;" does'nt work. It's No error notify, but it returned text in ISO-8859-2. Here is my code in Delphi (dbExpress) ... -- //1 possibilty SQLConnection1.Execute('SET CHARACTER SET latin2_cp1250',nil,nil); //2 possibility //SQLDataSet1.CommandText := 'SET CHARACTER SET latin2_cp1250'; //SQLDataSet1.ExecSQL(TRUE); sql := 'select * from where en1 +' like ''' + Edit1.Text + ''' order by ' + RadioGroup1.Items[RadioGroup1.ItemIndex]; SQLDataSet1.CommandText := sql; SQLDataSet1.Open; --- Pleasse, how can I change charset for MySQL data in Delphi? Thanks Milos Vymazal http://garten.cz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New charset for MySQL
Dear Sir, I found the following page after a google search on Bengali Character set:- http://www.alanwood.net/unicode/bengali.html Thanks Shyamal - Original Message - From: "Alexander Barkov" <[EMAIL PROTECTED]> To: "Shyamal Banerjee" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 12:30 PM Subject: Re: New charset for MySQL >Hi! > > > What is "Bengali" character set? Does it have a Unicode > mapping table like for example this one: > > ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT > > Please also send me some links to internet recourses > written in Bengali. > >Regards! > > Shyamal Banerjee wrote: > > Dear sir, > > > > I want to create a website in my native language. > > I would like MySQL support for my native character set, which is Bengali. I > > think MySQL does not support this language. How can I add support for it in > > MySQL ? > > Thanks in advance for any reply. > > > > Shyamal > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > -- > For technical support contracts, visit https://order.mysql.com/ > __ ___ ___ __ >/ |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer > /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia > <___/ www.mysql.com +7-902-856-80-21 > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New charset for MySQL
Dear Sir, Thank you for the tip.I am going to look the page you mentioned. Shyamal - Original Message - From: "Dean Harding" <[EMAIL PROTECTED]> To: "'Alexander Barkov'" <[EMAIL PROTECTED]>; "'Shyamal Banerjee'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 1:03 PM Subject: RE: New charset for MySQL > Bengali is the script used in many Indian languages, like Hindi. > > A search on google turned up a lot of pages written using Bengali, a > good example is http://www.parabaas.com/ and, for example, > http://www.parabaas.com/PB28/LEKHA/bMarkin28.html > > Shyamal, if you're a coder, you can add support for it yourself, just > check out this page: > http://www.mysql.com/doc/en/Adding_character_set.html > > Dean Harding. > > > -Original Message- > > From: Alexander Barkov [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 26 November 2002 6:00 pm > > To: Shyamal Banerjee > > Cc: [EMAIL PROTECTED] > > Subject: Re: New charset for MySQL > > > >Hi! > > > > > > What is "Bengali" character set? Does it have a Unicode > > mapping table like for example this one: > > > > ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT > > > > Please also send me some links to internet recourses > > written in Bengali. > > > >Regards! > > > > Shyamal Banerjee wrote: > > > Dear sir, > > > > > > I want to create a website in my native language. > > > I would like MySQL support for my native character set, which is > > Bengali. I > > > think MySQL does not support this language. How can I add support > for it > > in > > > MySQL ? > > > Thanks in advance for any reply. > > > > > > Shyamal > > > > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > -- > > For technical support contracts, visit https://order.mysql.com/ > > __ ___ ___ __ > >/ |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer > > /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia > > <___/ www.mysql.com +7-902-856-80-21 > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > [EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: New charset for MySQL
Bengali is the script used in many Indian languages, like Hindi. A search on google turned up a lot of pages written using Bengali, a good example is http://www.parabaas.com/ and, for example, http://www.parabaas.com/PB28/LEKHA/bMarkin28.html Shyamal, if you're a coder, you can add support for it yourself, just check out this page: http://www.mysql.com/doc/en/Adding_character_set.html Dean Harding. > -Original Message- > From: Alexander Barkov [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 26 November 2002 6:00 pm > To: Shyamal Banerjee > Cc: [EMAIL PROTECTED] > Subject: Re: New charset for MySQL > >Hi! > > > What is "Bengali" character set? Does it have a Unicode > mapping table like for example this one: > > ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT > > Please also send me some links to internet recourses > written in Bengali. > >Regards! > > Shyamal Banerjee wrote: > > Dear sir, > > > > I want to create a website in my native language. > > I would like MySQL support for my native character set, which is > Bengali. I > > think MySQL does not support this language. How can I add support for it > in > > MySQL ? > > Thanks in advance for any reply. > > > > Shyamal > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > -- > For technical support contracts, visit https://order.mysql.com/ > __ ___ ___ __ >/ |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer > /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia > <___/ www.mysql.com +7-902-856-80-21 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php