RE: Insert error

2002-11-27 Thread MarkH
I running from the command line and using MySQL version 3.23.53. I've also tried through .NET using MySQLDriverCS and have the same problem. I'm not running WinMySQLadmin, I didn't know it existed I might have to look into that! Mark -Original Message- From: DL Neil [mailto:[EMAIL

RE: Insert error

2002-11-27 Thread MarkH
Miquel, Using version 3.23.53. Don't know what version the db I'm trying to access was created on, but the tables are MYISAM. Example below. I also get the same error using LOAD DATA and through .NET using MySQLDriverCS. -- mysql describe main_categories;

From Russia with love.

2002-11-27 Thread MarkH
I need to create a database with tables that can contain either Russian or Latin1 characters. Is it right that version 3.23.53 does not support Unicode? If so, how can I get around this problem. Can I create 2 databases one using the Latin1 and the other using the Russian character set?

RE: MySql on Non english locales.

2002-11-27 Thread MarkH
This problem's similar to one I posted earlier re Russian and English characters in a database. I'm using the .net MySQLDriverCS driver. Are you saying that MySQL tables can hold unicode? If so, how do I set it up to do so? If not, how can I store Russian and English characters in MySQL? Will

Insert error

2002-11-26 Thread MarkH
I'm running MySQL as a service on win2k and trying to insert data into a database. Each time I try to do this I receive the following error: ERROR 2013: Lost connection to MySQL server during query The following error was shown when I opted to debug: Unhandled exception at 0x004803c9 in

RE: Selecting rows issue

2002-11-22 Thread MarkH
Use the DISTINCT keyword. SELECT DISTINCT table2.* FROM table2, table1 WHERE table2.id=table1.id -Original Message- From: Tarik Ansari [mailto:[EMAIL PROTECTED]] Sent: 22 November 2002 17:10 To: [EMAIL PROTECTED] Subject: Selecting rows issue Hello, I got two tables containing