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
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.
---
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
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 my
---
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?
---
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
---
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
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