Unicod problems

2002-05-14 Thread Svend Erik H. Jørgensen
Hi I'm currently developing on a system that we will launch on a int'l scale using MySQL as a small client database (30 MB). We are currently examine FoxPro and MySQL. I understand that MySQL doesn't support Unicode and one solution is to encode strings with UTF-8 before storing in MySQL, but

deleted tabels in innodb file

2002-05-01 Thread Svend Erik H. Jørgensen
Hi Some how i have manged to delete a database, i'm not quite sure how. When i try to create the table's i get an error : 020501 15:08:38 InnoDB: Error: table noah/user already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE?

Large datafiles

2002-03-27 Thread Svend Erik H. Jørgensen
Hi I'm running mysql 3.23.36 on a Red Hat 7.1 with the standard kernel. I have a /var partition (ext2) with 6.5 gb total space. One of the tables are almost running out of space, it is almost 4 gb. is it the filsystem that prevents files larger than 4 gb, or is it mysql that should be tweaked

Large datafiles

2002-03-27 Thread Svend Erik H. Jørgensen
Well, if i'm usin ext2 with a blocksize on 4 kb, then the largest file should be about 4 gb, right ? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 27. marts 2002 12:16 To: [EMAIL PROTECTED] Subject: Large datafiles Svend, Wednesday, March 27, 2002, 12:30:28 PM,