Fwd: character set problem
Begin forwarded message: From: Napster Cao tx...@hotmail.com Subject: character set problem Date: June 11, 2013 11:04:18 PM GMT+08:00 To: mysql@lists.mysql.com Hi Guys, I installed a new CentOS server (6.4 x86_64), and when I try to log into phpmyadmin, there's an ERROR: Can't initialize character set utf-8 (path: /usr/local/mysql/share/charsets/) BTW: Everytime I logged into system, I got: -bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory and I cannot find locale-gen on my system, the latest version of glibc is installed. [admin@zxue /]# rpm -qa | grep glibc glibc-devel-2.12-1.107.el6.x86_64 glibc-2.12-1.107.el6.x86_64 glibc-headers-2.12-1.107.el6.x86_64 glibc-common-2.12-1.107.el6.x86_64 and here's the output of locale command: [admin@zxue /]# locale LANG=en_US LC_CTYPE=en_US.utf-8 LC_NUMERIC=en_US.utf-8 LC_TIME=en_US.utf-8 LC_COLLATE=en_US.utf-8 LC_MONETARY=en_US.utf-8 LC_MESSAGES=en_US.utf-8 LC_PAPER=en_US.utf-8 LC_NAME=en_US.utf-8 LC_ADDRESS=en_US.utf-8 LC_TELEPHONE=en_US.utf-8 LC_MEASUREMENT=en_US.utf-8 LC_IDENTIFICATION=en_US.utf-8 LC_ALL=en_US.utf-8 How to resolve those two problems?(or maybe they are the same problem?) Thanks in advance!
Re: character set problem
independent how often you re-post it will not become magically a MySQL problem if you have messed up your OS environment Am 12.06.2013 15:27, schrieb Napster Cao: BTW: Everytime I logged into system, I got: -bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory and I cannot find locale-gen on my system, the latest version of glibc is installed signature.asc Description: OpenPGP digital signature
character set problem
Hi, I want to search from a table , I have a table with a column that each record filled with different character set ,is it possible to know what are their character set and then is it possible to change all of them to a character set ,how can I do that? these records show like below that I don't know what are their charset : ارÚ(c)يد شيمی جهان #1578;#1608;#1604;#1610;#1583; thanks
Character set problem
Hi. I just installed MySQL 4.1.20 for the UTF-8 support it offers. I'm trying to set the charcter set collation at the database level but can't get it to work. It works by setting it at the server level (in my.cnf) but I want to set it at the database level because I'll be hosting the web app on a third-party web hosting server, where likely I won't have access to server level settings via my.cnf (is there a way around this?). I perform the following query: ALTER DATABASE my schema name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; After the query a dump of the relevant MySQL variables is as follows: character_set_client: utf8 character_set_connection: utf8 character_set_database: utf8 character_set_results: utf8 character_set_server: latin1 character_set_system: utf8 collation_connection: utf8_general_ci collation_database: utf8_general_ci collation_server: latin1_swedish_ci The variables look right but the characters (chinese in this case) do not display correctly in the web page. As mentioned before setting the charset at server level results in the characters displaying just fine. Any thoughts/guesses? Thanks in advance. _ Consolidate your email! http://www.fusemail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Character set problem
From: Spiros Philopoulos Sent: 06 July 2006 13:32 Hi. I just installed MySQL 4.1.20 for the UTF-8 support it offers. I'm trying to set the charcter set collation at the database level but can't get it to work. It works by setting it at the server level (in my.cnf) but I want to set it at the database level because I'll be hosting the web app on a third-party web hosting server, where likely I won't have access to server level settings via my.cnf (is there a way around this?). I perform the following query: ALTER DATABASE my schema name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; After the query a dump of the relevant MySQL variables is as follows: character_set_client: utf8 character_set_connection: utf8 character_set_database: utf8 character_set_results: utf8 character_set_server: latin1 character_set_system: utf8 collation_connection: utf8_general_ci collation_database: utf8_general_ci collation_server: latin1_swedish_ci The variables look right but the characters (chinese in this case) do not display correctly in the web page. As mentioned before setting the charset at server level results in the characters displaying just fine. Any thoughts/guesses? The ALTER above only sets the character set for any future tables created, it won't convert any data already in tables. If you recreate the tables and data after setting the database char set, does it work? You can use 'SHOW CREATE table_name' to check what character set the tables are actually using. If you need to convert existing data see: http://dev.mysql.com/doc/refman/4.1/en/charset-conversion.html Mind you not sure how that fits with it working with the database char set set to utf8! hth, mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author and do not necessarily represent those of Independent Television News Limited unless specifically stated. This email and any files attached are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] Please note that to ensure regulatory compliance and for the protection of our clients and business, we may monitor and read messages sent to and from our systems. Thank You. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Character set problem
Hy I have a table datas like that : name Mester József Job György Czibere Lajos If I create : select name from dolgozok where name like '%jó%' ; then all data will be shown. But I wolud like see datas which really contain ó character (only Mester József). Joe - Win a BlackBerry device from O2 with Yahoo!. Enter now.
Re: Character set problem
Hello. Perhaps it is an issue of your collation: mysql select a from ts where a like '%ó%' collate utf8_bin ; ++ | a | ++ | Mester József | ++ 1 row in set (0.00 sec) mysql select a from ts where a like binary '%ó%'; ++ | a | ++ | Mester József | ++ mysql select a from ts where a like '%ó%'; ++ | a | ++ | Mester József | | Job György | | Czibere Lajos | ++ See: http://dev.mysql.com/doc/refman/5.0/en/charset-collations.html Mester József wrote: Hy I have a table datas like that : name Mester József Job György Czibere Lajos If I create : select name from dolgozok where name like '%jó%' ; then all data will be shown. But I wolud like see datas which really contain ó character (only Mester József). Joe - Win a BlackBerry device from O2 with Yahoo!. Enter now. -- 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]
migrate from 3.x to 4.1 character set problem
hi, we've got an old mysql-3.23.58 and a new mysql-4.1.10a and we'de like to migrate our data, but it doesn't seems to be so easy:-( out old server has a latin2 database. after we dump it and try tp import into the new ones we always got errors or the spical accented hungarian characters are getting wrong. - what is the prefered (and working) way to migrate from the old to the new? - how can define the new char sets? we try these variations (and manualy create the database with defult char set and latin2): 1. mysqldump --opt -p xxx xxx.sql mysql xxx xxx.sql 2. mysqldump --opt --default-character-set=latin2 -p xxx xxx.sql mysql --default-character-set=latin2 xxx xxx.sql 3. mysqldump --opt -p xxx xxx.sql iconv -f ISO_8859-2 -t UTF-8 -o xxx2.sql xxx.sql mysql xxx xxx2.sql and many more combination, try to read all docs, but can't find any solutions. another question what is the collations latin2_hungarian_ci contains? how can i interpret that xml file? eg. a is equal to á or not? is there any way to find out how is the buildin contains defined? or any description? thank you for your help in advance. yours. -- Levente Si vis pacem para bellum! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: migrate from 3.x to 4.1 character set problem
hi, we've got an old mysql-3.23.58 and a new mysql-4.1.10a and we'de like to migrate our data, but it doesn't seems to be so easy:-( out old server has a latin2 database. after we dump it and try tp import into the new ones we always got errors or the spical accented hungarian characters are getting wrong. - what is the prefered (and working) way to migrate from the old to the new? - how can define the new char sets? we try these variations (and manualy create the database with defult char set and latin2): 1. mysqldump --opt -p xxx xxx.sql mysql xxx xxx.sql 2. mysqldump --opt --default-character-set=latin2 -p xxx xxx.sql mysql --default-character-set=latin2 xxx xxx.sql 3. mysqldump --opt -p xxx xxx.sql iconv -f ISO_8859-2 -t UTF-8 -o xxx2.sql xxx.sql mysql xxx xxx2.sql and many more combination, try to read all docs, but can't find any solutions. another question what is the collations latin2_hungarian_ci contains? how can i interpret that xml file? eg. a is equal to á or not? is there any way to find out how is the buildin contains defined? or any description? thank you for your help in advance. yours. Generally speaking you need to define the character set for each column or table in your 4.1 database, or set a default character set for the database or for the server, this is independent of the default character set used by the clients... Then you need your clients to connect to the database using the appropriate character set... while the examples above seem correct, there are some opportunities for errors to occur. Firstly export the data using the mysql tools provided with 3.23.58... eg make sure you use the mysqldump that comes with the 3.23.58 mysql binary - chances are that is will be mysqldump 3.23.58. I expect that version off mysqldump will not support the --default- character-set flag and should have thrown an error if you try to give it that flag... It's important that you export the 3.23.58 data the way it is, and let the 4.1 tools deal with putting it into the new format appropriately. using mysqldump from 4.1 may not give you exactly the same results, so you should avoid that. Also for what it is worth you may want to try doing a dump slightly differently... we always use --tab=/var/tmp/database or some such thing and that creates a series of files in the folder you specify, one .sql file for each table containing just the create table statement, and one .txt file for each table containing just the data for each table in tab delimited format. It means your import process will be slightly different, but it's faster, and because we have done it regularly it's more likely to handle the data conversion. Next when doing the import make sure you use mysql tools that match the database you are installing. Here you will need to specify the default character set for the clients, they will understand and use that when speaking to the database. Here is the process we use to do the export from 4.0 and import into 4.1, there should be no great difference in how 3.23.58 and 4.0 handle the character sets so the results should be much the same. We use UTF8, and our 4.0 databases had no special character settings, so it was stored in the database as latin1. On the original server using 4.0.n server and tools to match we run this: mysqldump --tab=/var/tmp/database database You should be able to do the same thing provided you use mysqldump 3.23.58, again make no allowances for character set in the dump process, you just want the data dumped to disk the same way it is stored now. Then we move the directory /var/tmp/database to /var/tmp on the new server with 4.1 running... note this has the 4.1.n server AND the 4.1.n tools (such as mysql, mysqldump, mysqlimport and so on). Finally we go ahead and import our data into the server using this sequence of commands (we use a shell script, so that's what you get here). Call the shell script by giving it the database name as a flag (eg ./import database) - watch for differences in line breaks caused by email clients here, there are three lines of commands after setting DB=$1. #!/bin/sh # # LiveWorld's MySQL Import Script # Use for converting 4.0 databases to 4.1 UTF8 databases # Suitable for LiveWorld Servers only, use at your own risk # DB=$1 mysql -e CREATE DATABASE $DB default character set utf8; cat /var/tmp/$DB/*sql | mysql --socket=/tmp/mysql.sock $DB mysqlimport --default-character-set=utf8 $DB /var/tmp/$DB/*txt Obviously you are going from latin2 to latin2 so it should be a little easier for you than it was for us... and you'll want to make some changes in the script compared to our utf8 stuff (of course you may want to just go with utf8 anyway, should handle most anything you want to throw at it that way, our databases run in 30 languages). So be careful to match your tools with your server version and try to
Re: Character Set Problem
Is it possible to change the character set just for an individual table and if so which character set should I try to display this european characters? Cheers, Lee - Original Message - From: Sumito_Oda [EMAIL PROTECTED] To: Lee Denny [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, May 03, 2005 1:42 PM Subject: Re: Character Set Problem Hello, Is the MySQL server that you are using MySQL4.1.x or MySQL5.0.x? As for most binarys of PHP and MySQL, the default charset of the MySQL connection client is set as 'latin1'. Therefore, if charset with the server is not 'latin1', it is necessary to set the MySQL connection client properly. It is whether to set to use the charset that you use by default, to compile the binary or to set the MySQL connection first by 'SET NAMES' syntax. http://dev.mysql.com/doc/mysql/en/set-option.html Regards, -- Sumito_Oda mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Character Set Problem
Hello, this is probably quite simple but I've got a text file that has non-english characters, when I view it I see : 'Dcouvrez un rseau europen d'htels et de restaurants beignant dans une atmosphre conviviale et familliale' I've imported this straight into my myisam DB which is set up with default charsets and collations - and these characters are just the same. I've looked into this but can't really grasp charsets and collations. I'd be happy to translate these codes back into the default charset (english characters). I'm using PHP to query the database, but would like to change the data in the DB if possible. I know this is a bit vague but I was wondering if anyone had any insight into this. Cheers, Lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character Set Problem
Hello, Is the MySQL server that you are using MySQL4.1.x or MySQL5.0.x? As for most binarys of PHP and MySQL, the default charset of the MySQL connection client is set as 'latin1'. Therefore, if charset with the server is not 'latin1', it is necessary to set the MySQL connection client properly. It is whether to set to use the charset that you use by default, to compile the binary or to set the MySQL connection first by 'SET NAMES' syntax. http://dev.mysql.com/doc/mysql/en/set-option.html Regards, -- Sumito_Oda mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character Set problem
Hello. If you can reproduce this problem on several different installations, you may open a new bug (because #312 is closed) and leave there a note about bug #312. Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Gleb Paharenko wrote: Thanks for the reply. See: http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html Yeah Thanks - seen that already. Check that you have the charsets directory in c:\mysql\share. Again, thanks, but that doesn't actually solve the issue. There are entries in the Index file for the appropriate language number. There isn't, however, an xml file for the language (utf8 in this instance). I've tried changing the server default character set to cp1251. I've recreated complete databases from scratch making sure that the character set it uses is cp1251. None of the above have worked. Any other thoughts? This is mySQL 4.1.10-nt on win2003 server giving : File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) ^GCharacter set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file which is classified as Bug number 312 (http://bugs.mysql.com/bug.php?id=312) Regards Stephen -- 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: Character Set problem
Gleb Paharenko wrote: Thanks for the reply. See: http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html Yeah Thanks - seen that already. Check that you have the charsets directory in c:\mysql\share. Again, thanks, but that doesn't actually solve the issue. There are entries in the Index file for the appropriate language number. There isn't, however, an xml file for the language (utf8 in this instance). I've tried changing the server default character set to cp1251. I've recreated complete databases from scratch making sure that the character set it uses is cp1251. None of the above have worked. Any other thoughts? This is mySQL 4.1.10-nt on win2003 server giving : File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file which is classified as Bug number 312 (http://bugs.mysql.com/bug.php?id=312) Regards Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character Set problem
Hello. See: http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html I've read through all the supposed fixes and other posts all over the place, but, to be honest, I'm confused. I'm not really sure what the fix is. Check that you have the charsets directory in c:\mysql\share. Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Hi there, I'm on mysql 4.1.10a on Windows 2003 Server. I'm getting : File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) ^GCharacter set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file when some PHP applications try accessing their database. I know this is classified as Bug number 312 (http://bugs.mysql.com/bug.php?id=312). I've read through all the supposed fixes and other posts all over the place, but, to be honest, I'm confused. I'm not really sure what the fix is. Is there actually a fix? If there is a fix, would someone be kind enough to give me an idiots guide on what to do please? Regards Stephen -- 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]
Character Set problem
Hi there, I'm on mysql 4.1.10a on Windows 2003 Server. I'm getting : File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file when some PHP applications try accessing their database. I know this is classified as Bug number 312 (http://bugs.mysql.com/bug.php?id=312). I've read through all the supposed fixes and other posts all over the place, but, to be honest, I'm confused. I'm not really sure what the fix is. Is there actually a fix? If there is a fix, would someone be kind enough to give me an idiots guide on what to do please? Regards Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 Character set problem ( Ithink?)
Hello. The value of the character_set_system in this case doesn't have affect in this case. You table has latin2 as default character set, and all your character_set_xxx variables have a latin1 value. Ian Gibbons [EMAIL PROTECTED] wrote: On 12 Feb 2005 at 14:09, Gleb Paharenko wrote: Hello. Please tell us, what output the following statement produces: SHOW VARIABLES LIKE '%char%'; Hi Gleb, mysql SHOW VARIABLES LIKE '%char%'; +--++ | 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/ | +--++ 7 rows in set (0.08 sec) I assume the character_set_system being utf8 is the problem, but how do I change it? You can use hexademical values for inserting the data. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html I've taken a look at this and it could prove very useful. I wish I had the time to read the whole manual! Thanks Ian -- 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: 4.1.7 Character set problem ( Ithink?)
Hello. Please tell us, what output the following statement produces: SHOW VARIABLES LIKE '%char%'; You can use hexademical values for inserting the data. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html Ian Gibbons [EMAIL PROTECTED] wrote: Hi List, I am having a strange problem on Linux Fedora Core 3 with MySQL 4.1.7 ( of= fical mysql rpms). The data was originally stored in MySQL 3.something and was = placed into the database via a MySQLDump file. It is too late to reload the data= . I have a table called fees: CREATE TABLE `fees` ( `refID` int(11) NOT NULL default '0', `price` text, `tuitionFee` tinyint(4) default NULL, `examFee` tinyint(4) default NULL, `otherFee` tinyint(4) default NULL, `feeText` text, `pending` tinyint(4) default '0', PRIMARY KEY (`refID`), KEY `refID` (`refID`) ) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin2 When I try updating the price field for one record, it doesn't seem to rec= ognise the pound sign (=A3): mysql UPDATE fees SET price=3D '=A345' WHERE refID=3D732; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql select price from fees where refID=3D732; +---+ | price | +---+ | ?45 | +---+ 1 row in set (0.00 sec) The same result ?45 is returned via php as well, so its not a console disp= lay problem. I have also tried this with the latin1 character set with the same results= . I know I am probably better off changing the field type to a double and pl= acing the pound sign in my php code, but I am curious as to why this happens. Is it a problem with the character sets? Should I be using a different ch= aracter set for English language text ( no international chars ). Any help will be appreciated. Ian -- 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: 4.1.7 Character set problem ( Ithink?)
On 12 Feb 2005 at 14:09, Gleb Paharenko wrote: Hello. Please tell us, what output the following statement produces: SHOW VARIABLES LIKE '%char%'; Hi Gleb, mysql SHOW VARIABLES LIKE '%char%'; +--++ | 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/ | +--++ 7 rows in set (0.08 sec) I assume the character_set_system being utf8 is the problem, but how do I change it? You can use hexademical values for inserting the data. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html I've taken a look at this and it could prove very useful. I wish I had the time to read the whole manual! Thanks Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.1.7 Character set problem ( Ithink?)
Hi List, I am having a strange problem on Linux Fedora Core 3 with MySQL 4.1.7 ( offical mysql rpms). The data was originally stored in MySQL 3.something and was placed into the database via a MySQLDump file. It is too late to reload the data. I have a table called fees: CREATE TABLE `fees` ( `refID` int(11) NOT NULL default '0', `price` text, `tuitionFee` tinyint(4) default NULL, `examFee` tinyint(4) default NULL, `otherFee` tinyint(4) default NULL, `feeText` text, `pending` tinyint(4) default '0', PRIMARY KEY (`refID`), KEY `refID` (`refID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin2 When I try updating the price field for one record, it doesn't seem to recognise the pound sign (£): mysql UPDATE fees SET price= '£45' WHERE refID=732; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql select price from fees where refID=732; +---+ | price | +---+ | ?45 | +---+ 1 row in set (0.00 sec) The same result ?45 is returned via php as well, so its not a console display problem. I have also tried this with the latin1 character set with the same results. I know I am probably better off changing the field type to a double and placing the pound sign in my php code, but I am curious as to why this happens. Is it a problem with the character sets? Should I be using a different character set for English language text ( no international chars ). Any help will be appreciated. Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL character set problem
Hi, I have just found a major problem with my site. This is my problem: My server has been running on a redhat 7.3 distro without any problems for some time now. I then purchased a new server, which is running Redhat Linux ES 3.0 with the same basic settings and same install options. When performing a mysql dump of the database, and uploading this to the new server, all of the special scandinavian characters are beeing replaced with somthing that looks like chineese or something. Everything else works great. Somewhere i need to change som language coding, but I'm not sure where to do this. I have checked the charset directory and there are many options there allready. I then tried to include the following in my /etc/my.cnf file: default-character-set=latin1(Also tried the default swe7) But this did not solve my problem. Both Linux distro's are installed with English language and Norwegian/Swedish extra language support + Norwegian keymap. Hope someone can help me work this out. System config: Old-server: RH 7.3 with mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686) New server: RHEL ES 3.0 with mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) Terje D Norway -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL character set problem
The first things you should check: 1. Do \s from the mysql client to be sure its using the character set you told it to use with default-character-set=latin1. Be sure its the same one you used on your old server. 2. Since you have the Norwegian keyboard set up try typing Norwegian characters in the terminal. If they are displayed as expected then you know that the terminal font is not the problem. Having an improper terminal font is often the problem in cases like this. 3. Select the hex values for the characters which are not being displayed. SELECT hex(Norwegian_column) FROM your_table; If your old system is still available compare these values to the working system, just to be sure your data wasn't corrupted somewhere in the transfer. 4. Test with multiple clients if possible. Such as the command line client and a php web client. Hope this helps, Jeremy _ Let the new MSN Premium Internet Software make the most of your high-speed experience. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character set problem Linux - Windows
From a quick search of the online docs, it seems this is what you need: http://www.mysql.com/doc/en/Charset-CONVERT.html but I think it is only in 4.1.0 alpha. Feel free to correct me, I'm no guru here. Adam On 09/18/2003 12:06 PM Marcin Giedz wrote: - Original Message - From: Adam Hardy [EMAIL PROTECTED] To: Marcin Giedz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:34 AM Subject: Re: Character set problem Linux - Windows Hi Marcin, have you tried using unicode? Not yet Adam but though about it!!! If I change to unicode how to change existing strings with Polish letters in mysql tables?? Marcin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character set problem Linux - Windows
Hi Marcin, have you tried using unicode? Adam On 09/17/2003 02:02 PM Marcin Giedz wrote: Hi all, My company(situated in Poland) produce cross platform software based on Borland Delphi/Kylix. We also use mysql server to store all our date.Server is configured with latin2 character set. Nowadays several users work on Linux boxes(Debian + XFree 4.3.1 + KDE 3.1.3 + iso 8859-2 with LC_ALL=pl_PL) and rest on Windows 2000. The following problem occured: - when linux user insert string with Polish letters into table it looks OK but only on Linux application. In windows Polish letters like s with upper mark - and a with lower mark - and also z with upper mark - are changed with +- etc... - when windows user insert string with Polish letters into table it looks OK but only on Windows application. In linux Polish letters like s with upper mark - and a with lower mark - and also z with upper mark - are changed with +- etc... Is it possible to fix it??? Thanks,Marcin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character set problem Linux - Windows
- Original Message - From: Adam Hardy [EMAIL PROTECTED] To: Marcin Giedz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:34 AM Subject: Re: Character set problem Linux - Windows Hi Marcin, have you tried using unicode? Not yet Adam but though about it!!! If I change to unicode how to change existing strings with Polish letters in mysql tables?? Marcin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Character set problem Linux - Windows
Hi all, My company(situated in Poland) produce cross platform software based on Borland Delphi/Kylix. We also use mysql server to store all our date.Server is configured with latin2 character set. Nowadays several users work on Linux boxes(Debian + XFree 4.3.1 + KDE 3.1.3 + iso 8859-2 with LC_ALL=pl_PL) and rest on Windows 2000. The following problem occured: - when linux user insert string with Polish letters into table it looks OK but only on Linux application. In windows Polish letters like s with upper mark - and a with lower mark - and also z with upper mark - are changed with +- etc... - when windows user insert string with Polish letters into table it looks OK but only on Windows application. In linux Polish letters like s with upper mark - and a with lower mark - and also z with upper mark - are changed with +- etc... Is it possible to fix it??? Thanks,Marcin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
default-character-set problem
Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49 ver on Red Hat Linux 7.2 Thanx list --- sql, query Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - 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: default-character-set problem
At 10:23 + 11/6/02, nick gatsis wrote: Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49 ver on Red Hat Linux 7.2 Thanx list --- sql, query The index entries are still stored in the order of the previous character set. You'll need to rebuild the indexes using the new character set. You can either: - dump, drop, and restore your tables - drop and recreate the indexes for each table - use myisamchk --recover --quick --set-character-set=greek for each table (take the server down if you do this) - use mysqlcheck --recover --quick for each table - use REPAIR TABLE ... QUICK for each table But in any case, you won't be able to sort using greek order sometimes and english order sometimes. Simultaneous character set support will be available in MySQL 4.1, though. - 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
Character Set Problem
I use mysql php. I created a table.. I entered some record. I want to order by name as asc. But I have turkish character like ,.. How can I set turkish character to mysql? Thanks.. Edakom Internet Sorumlusu Gokce Akkaya - 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
Character Set Problem
admin, Friday, March 29, 2002, 4:13:26 PM, you wrote: aect I use mysql php. I created a table.. I entered some record. I want to aect order by name as asc. But I have turkish character like ,.. aect How can I set turkish character to mysql? You should set latin5 character set: run mysqld with --default-character-set=latin5 option. aect Thanks.. aect Edakom Internet Sorumlusu aect Gokce Akkaya -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Character Set Problem
Hi, As I understand it Turkish has some unique features. There is no current turkish character set in the source tree. I am not sure if anyone has one. You could look at the other character sets and pick on that may also work. These can be found in the source ./sql/share/charsets. There is information on adding a charset in the manual http://www.mysql.com/doc/A/d/Adding_character_set.html and in Leon Atkinsen's book 'Core MySQL'. If you decide to make a turkish charset please submit the results so that it can be added. Sounds like it might be fun! I hope this helps, Ken - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 29, 2002 9:13 AM Subject: Character Set Problem I use mysql php. I created a table.. I entered some record. I want to order by name as asc. But I have turkish character like ,.. How can I set turkish character to mysql? Thanks.. Edakom Internet Sorumlusu Gokce Akkaya - 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: Character Set Problem
Victor is right, latin5 is for turkish, it's commented at the top of the character set! Ken - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 29, 2002 9:26 AM Subject: Character Set Problem admin, Friday, March 29, 2002, 4:13:26 PM, you wrote: aect I use mysql php. I created a table.. I entered some record. I want to aect order by name as asc. But I have turkish character like ,.. aect How can I set turkish character to mysql? You should set latin5 character set: run mysqld with --default-character-set=latin5 option. aect Thanks.. aect Edakom Internet Sorumlusu aect Gokce Akkaya -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Character Set Problem in MySQL!
Actually I hadn' t this kind of problem. But now I can' t display turkish characters in mysql queries. Can anyone help me? Edakom Internet Sorumlusu Gokce Akkaya - 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
MyODBC can't initialize character set problem ...
Hi I'm trying to compile to MySQL latin2 sorting and cp1250_latin2 character set conversion. I've compiled mysql-3.23.31 with these configure options: --without-debug \ --without-readline \ --enable-shared \ --with-extra-charsets=complex \ --without-bench \ --localstatedir=/var/lib/mysql \ --with-unix-socket-path=/var/lib/mysql/mysql.sock \ --with-mysqld-user="mysql" \ --with-extra-charsets=all \ --with-charset=latin2 I #define DEFINE_ALL_CHARACTER_SETS in convert.cc. I connect to the server with MyODBC 2.50.36 and I get error: -- [TCX] [MyODBC] Can't initialize character set 9 (path: c:\mysql\share\charsets) (#2019) -- and I can't connect - of course. There is no directory c:\mysql in default MyODBC Win95 installation ... What am I doing wrong ? -- Bartlomiej Czardybon, Dzial obslugi serwerow PIK-Net Sieci Rozlegle Toszecka 102, Gliwice Poland, +48 32 338-33-00 czar AT pik-net.pl - 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: MyODBC can't initialize character set problem ...
On Wed, Jan 31, 2001 at 02:25:14PM +0100, Bartlomiej Czardybon wrote: -- [TCX] [MyODBC] Can't initialize character set 9 (path: c:\mysql\share\charsets) (#2019) -- There is no directory c:\mysql in default MyODBC Win95 installation ... In MyODBC Readme file there is a sentence: --- Some common problems: [cut] - If you are connecting to a server with a character set that isn't compiled into the MySQL client library (the defaults are: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis ) then you need to install the mysql character definitions from the charsets directory into the c:\mysql\share\charsets. --- What does the author mean by 'you need to install the mysql character definitions fro the charsets directory into the c:\mysql\share\charsets ? I've just done it (copied 'charsets' directory from unix server path: /usr/share/mysql/charsets) but it still does not work ... :( TIA for any help, -- Bartlomiej Czardybon PIK-Net Sieci Rozlegle e-mail: czar AT pik-net.pl BC374-RIPE - 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
