mySQL in Hebrew

Does anyone have any experience of working with mySQL in Hebrew? The front end to my database is written in Delphi/Windows; it transmits Hebrew characters and displays Hebrew characters. The backend is in mySQL/Linux, and what was Hebrew appears in English characters. The only problem which I have

RE: How Do I Insert ...... ?

"where and how do I indicate that there is a problem insert a row into the table 'message'?" I don't understand you there. INSERT INTO message(thread_topic, thread_body) VALUES ('This is a topic','This is the body.'); That should work just fine. -Original Message- From: Caroline Jen [m

How Do I Insert ...... ?

I have a table 'message' in the MySQL database. To make it simple; say, I have three fields in that table: thread_ID, thread_topic, and thread_body. The thread_ID field is AUTO_INCREMENT; therefore, I do not insert any value into that column. The value of that field starts with 1 when the first

Selecting the latest entries

Hi there, This subject might be discussed before, but I couldn't find any mail from the archives. I have a table containing weather reports of different types and cities. The structure is following: - type - city - time - report Which kind of query should I use to select the latest reports of

creating a minimal mysqldump

I'm currently working on a little PHP-project, where I would like the possibillety of automatically upgrading the MySQL-tables, so that users don't have the need to drop the database, and then run the installscript again, from a mysqldump of the original database I'm running. What I was thinking,

mysql 5.0.0 error when creating a stored procedure

I've installed 5.0.0 (from 24dec04) on WinXP. I connect with the following string mysql --user=root when I try to create a stored procedure with the following command: create procedure xxx() select * from pet; I get the following error: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist Wha

RE: Hot standby database question

> -Message d'origine- > De : Jim Richardson [mailto:[EMAIL PROTECTED] > Envoye : Thursday, December 25, 2003 10:18 AM > A : [EMAIL PROTECTED] > Objet : Hot standby database question > > > > I would like to set up two systems, a primary, and a backup, in > physically seperate locations.

Bug Report

Dear Sir/Madame, Sehr geehrte Damen und Herren, I got the following message using the mysql-Database with phpMyAdmin: Ich habe folgende Meldung beim benutzen der mysql-Datenbank mit phpmyadmin erhalten: Möglicherweise haben Sie einen Bug im SQL-Parser entgeckt. Bitte überprüfen Sie Ihre Abfra

Re: relative performance between innodb and myisam

Bruce, InnoDB in most cases uses some more CPU time than MyISAM. But the main performance disadvantage of InnoDB is that tables in the InnoDB format typically require 50 % - 300 % more disk space than MyISAM format tables. Marko Mäkelä of Innobase Oy is writing a new InnoDB table format which wil

Re: How to do case sensitive replace with wild card matching?

Chris W wrote: Michael Stassen wrote: mos wrote: Ok, put your thinking caps on because this one bit of a toughie. I an Update statement that will insert a '/' in front of the *first* lowercase letter of a field value. Example: "ABCDef" becomes "ABCD/ef". Of course it doesn't always end in "ef"

Php > mysql question please help

I just started working with mysql and I'm very novice Created a simple database and programmed php to connect as follows... $link= mysql_connect($hostname,$user,$password)or die ("_something is whong"); mysql_select_db($db,$link); $query ="SELECT * FROM projects"; $result = mysql_query($query); $

Hot standby database question

I would like to set up two systems, a primary, and a backup, in physically seperate locations. I want the backup to be synced with the primary, and if the primary goes down, dns will resolve to the backup, so it needs to be able to start processing transactions immediately. I am new to MySQL, and

Re: How to do case sensitive replace with wild card matching?

Michael Stassen wrote: mos wrote: Ok, put your thinking caps on because this one bit of a toughie. I an Update statement that will insert a '/' in front of the *first* lowercase letter of a field value. Example: "ABCDef" becomes "ABCD/ef". Of course it doesn't always end in "ef" and could be an

ANNOUNCE: moodss-17.14 and moomps-2.16

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ### CHANGES ### - --- moodss 17.14 and moomps 2.16 --- - - upgraded myvars module for MySQL 4.0.17 support - - in moodss GUI: ~ - allow saving configuration (in a .moo file) in database history ~mode, so that building database based dashboards is

Re: Column name: CHECK

Hi Hans, > Yes, I have used ` > > I don't think check is reserverd because I can CREATE the column name! From > the mysql prompt its possible to insert a record, but not from my Delphi > Code. After that i try to alter / delete the column but thats impossible. > Other columns in the same table whe

relative performance between innodb and myisam

we have a bit of a debate going on at work. The gist of it is that there is a a performance hit when using innodb tables vs myisam tables. I understand the for a given dataload innodb will be larger, but is there a performance hit as well? If so, as a rough comparison, how much of a hit is it?