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