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
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 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 ' 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]
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]
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: 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]
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]
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
- 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
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
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