Re: latin1/utf-8 problem

2004-11-29 Thread Gleb Paharenko
Hello. Looks like you've solved the problem? Remove quotes from show create... statements: show create table table_name; Steve Mansfield <[EMAIL PROTECTED]> wrote: > --- > On Saturday 27 November 2004 12:38, Steve Mansfield wrote: > > Seem to be answering my own que

Re: latin1/utf-8 problem

2004-11-28 Thread Steve Mansfield
--- On Saturday 27 November 2004 12:52, Gleb Paharenko wrote: | Hello. | | Strange behavior. You said that both servers configured to use latin1? | What output produced Can only do with for the local server, access is denied to the mysql shell on the shared hosting. But it's the l

Re: latin1/utf-8 problem

2004-11-28 Thread Gleb Paharenko
Hello. Strange behavior. You said that both servers configured to use latin1? What output produced show variables like '%char%'; show variables like '%colla%'; show create database 'database_name'; show create table 'table_name'; on both servers? Also send your my.cnf files.

Re: latin1/utf-8 problem

2004-11-27 Thread Steve Mansfield
--- On Saturday 27 November 2004 12:38, Steve Mansfield wrote: Seem to be answering my own questions here...:-) Looks like it's a MySQLcc problem. Dumped tables from the live server and then, rather than running them as a sql query via MySQLcc, I did it from the command line wit

Re: latin1/utf-8 problem

2004-11-27 Thread Steve Mansfield
--- On Saturday 27 November 2004 12:16, Steve Mansfield wrote: | --- | | On Friday 26 November 2004 17:58, Gleb Paharenko wrote: | | Hello. | | | | What charset produced mysqldump with --default-character-set=latin1 | | command line option? | | Hmm, that still produc

Re: latin1/utf-8 problem

2004-11-27 Thread Steve Mansfield
--- On Friday 26 November 2004 17:58, Gleb Paharenko wrote: | Hello. | | What charset produced mysqldump with --default-character-set=latin1 command | line option? Hmm, that still produced a file with utf-8 characters, which means they must be stored that way in the table, no? (Al

Re: latin1/utf-8 problem

2004-11-27 Thread Gleb Paharenko
Hello. What charset produced mysqldump with --default-character-set=latin1 command line option? Steve Mansfield <[EMAIL PROTECTED]> wrote: > I have a strange, irritating problem that I think is to do with MySQL. I have > a table on a live (shared hosting) system that, when I use it on

latin1/utf-8 problem

2004-11-26 Thread Steve Mansfield
I have a strange, irritating problem that I think is to do with MySQL. I have a table on a live (shared hosting) system that, when I use it on my local system, seems to wind up in utf-8 rather than latin1. Here's the set-up: Live system - MySQL 3.2.3.56, PHP 4.1.2, Apache 1.3.27. MySQL is config

UTF-8 problem

2004-05-24 Thread Marek Lewczuk
Hello, I've just installed 4.1.1 to see how UTF-8 is working. In my.ini I have set default-character-set=utf8 - so all input/output data should be send in utf-8 charset. System variables (after start) are set as they should: character_set_serverutf8 character_set_systemut

ORDER BY ascii value (another UTF-8 problem...)

2003-11-28 Thread Yves Goergen
Hi again, I have stored UTF-8 encoded usernames in a table and need a properly sorted output. I tried with 'ORDER BY Name', but it won't sort extended ASCII characters correctly by their values but rather by some similarity with other letters. In my example, the Unicode character starts with a val