MySQL Glitch?

Hi all, Ive recently been made aware of a glitch in MySQL regarding locked at the table level (instead of row) when a record is being updated. Is this still a problem in Version 3.23.46? Has it been fixed in 4.0.0? And if so, when is a stable version of 4.0 likely to be released? Many thanks,

Help! Languages and Characters....

I have a mysql table (MySAM), a field in there is set to unique, however the field does not seem to recognise the difference between certain ascii characters, for example it things that multimedia and multimèdia are the same (I hope it is shown correctly) but basically it dos not recognise chara

Re: Help! Languages and Characters....

The problem is that I dont want it case sensitive, but I do want it to distinguish special characters, any more ideas? Thanks Shannon --- Michael Brunson <[EMAIL PROTECTED]> wrote: > On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon > Kendrick <[EMAIL PROTECTED]> wrote: >

Table Locking...

Does anyone know of a way to lock at the row level instead of table level using MySQL 3.23.46 Thanks Shannon __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com --

Re: Table Locking...

Whats the drawback of using InnoDB instead of MySAM tables? --- Carl Troein <[EMAIL PROTECTED]> wrote: > > Shannon Kendrick writes: > > > Does anyone know of a way to lock at the row level > > instead of table level using MySQL 3.23.46 > > Yep, use InnoDB i

Re: Table Locking...

Whats the drawback of using InnoDB instead of MySAM tables? --- Carl Troein <[EMAIL PROTECTED]> wrote: > > Shannon Kendrick writes: > > > Does anyone know of a way to lock at the row level > > instead of table level using MySQL 3.23.46 > > Yep, use InnoDB i

Re: letter 'O' with umlaut not equivalent to regular 'O'?

Try setting the column to binary, that what worked for me. Shannon --- awk <[EMAIL PROTECTED]> wrote: > >Description: > Somehow the letter 'O' is not equivalent to the > letter 'Ö' (O with > umlaut), in string matching. > > >How-To-Repeat: > I tried the following query in MyS

RE: [PHP-DB] any good web hosting with php and mysql support?

Ive got numerous accounts with www.palmversa.com and I have to say they are very reliable and extremely cheap. Hope this helps Shannon > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL

Simple: Date Stamp mySQL and PHP

Hi all, Ive got a timestamp in a database column and basically I was wondering if there was any function in PHP to parse the date into something more readable from 20020123143547 "23 Jan 2002 14:35" something like $date1= datetoreadable($date); Thanks Shannon __