Storing foreign characters in DB

I'm having a problem figuring out how to deal with foreign characters in text that was copied from an MS Word document and pasted into a form field, then stored in a MySQL DB. (I have MySQL 3.23.58 running). I'm not how sure how these characters are being stored in the MySQL database, but, when I

RE: MySQL TEXT - Possible Corruption

Hi again, Sorry for the double post. I created a new database, recreated all my tables, repopulated them, and it seems to work now. Any ideas as to what was causing this? Paul From: "Paul Higgins" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: MySQL TEXT - Possible Corruption Date: Sat, 0

Re: Help needed with MySQL C API-based client (segfault)

On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote: > Hello, > > I need to write a simple C client for a project. I am using the MySQL C > API. Attached is the code. It occassionally segfaults with no visible > pattern. Could someone help me figure out why? Or any other comments on the

MySQL TEXT - Possible Corruption

Hi, I've been having a problem using the TEXT column type. I'm trying to insert a serialized PHP object into this field. However, when I execute the insert command (via a php script), I cannot view the data until I restart the service. I query the database using the command prompt, but the da

Re: grant tables update backward compatibility

Hi Eric,: Thanks for responding. Preliminary tests indicate no problems, although it does of necessity make assumptions about which of the new privileges existing users should have when upgrading, but they were fairly safe. Regards, -Bob > I would assume that you can since mysql probably doe

Re: 1 database; 2 scripts; different results

Michael Stassen wrote: Amer Neely wrote: OK, obviously a bit more background seems to be in order. My site is hosted but I am not the administrator. I have 2 perl scripts, behaving as already described. I also have phpMyAdmin access to my databases. I don't have command line access to the server

Re: Is it possible to have Undeletable Records?

Wesley Furgiuele wrote: I don't think so. I think your current method of either storing it in the query or with a boolean field is your best bet. What I've seen done in the past is that records get marked with a user level and there is either one or a group of users who are allowed to delete or mo

Re: 1 database; 2 scripts; different results

Amer Neely wrote: I'm pretty sure it's not. With a properly functioning mysql server, you need neither FLUSH TABLES nor the RELOAD privilege to delete a row from a table. See the manual for a description of FLUSH TABLES . I did and imagine my sur

Re: 1 database; 2 scripts; different results

Amer Neely wrote: OK, obviously a bit more background seems to be in order. My site is hosted but I am not the administrator. I have 2 perl scripts, behaving as already described. I also have phpMyAdmin access to my databases. I don't have command line access to the server. Well, that's a start.

Re: 1 database; 2 scripts; different results

Michael Stassen wrote: Amer Neely wrote: Amer Neely wrote: Brian Reichert wrote: On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote: My question is, in my admin script I deleted a record, but it still shows up using the other script. The admin script shows 102 records and the other shows

Re: Forcing case sensitivity in queries

Le dim 05/09/2004 à 00:14, Yannick Warnier a écrit : > Hi, > > When I execute a query in MySQL client, it seems like I cannot get the > case-sensitivity to be activated. > > If I ask: > SELECT * FROM mytable WHERE field = 'd'; > > I get all records containing 'd' or 'D'. > > How do I enable cas

Re: Forcing case sensitivity in queries

You need BINARY . SELECT * FROM mytable WHERE BINARY field = 'd'; Michael Yannick Warnier wrote: Hi, When I execute a query in MySQL client, it seems like I cannot get the case-sensitivity to be activated. If I ask: SELECT * FROM mytable WHER

Re: Graphics and blobs

My apologies for rushing in with a question that gave little in the way of details. I've straightend out the mess ;) Just in case it's of any relevance, I've opted to store the gifs in a file directory and use a varchar field to make a link to the file / directory. All is good. Sorry again! Stuart

Re: 1 database; 2 scripts; different results

Michael Stassen wrote: Amer Neely wrote: Amer Neely wrote: Brian Reichert wrote: On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote: My question is, in my admin script I deleted a record, but it still shows up using the other script. The admin script shows 102 records and the other shows

Forcing case sensitivity in queries

Hi, When I execute a query in MySQL client, it seems like I cannot get the case-sensitivity to be activated. If I ask: SELECT * FROM mytable WHERE field = 'd'; I get all records containing 'd' or 'D'. How do I enable case-sensitivity? Thanks, Yannick -- MySQL General Mailing List For list

Re: 1 database; 2 scripts; different results

Amer Neely wrote: Amer Neely wrote: Brian Reichert wrote: On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote: My question is, in my admin script I deleted a record, but it still shows up using the other script. The admin script shows 102 records and the other shows 103. The record does s

Re: 1 database; 2 scripts; different results

Amer Neely wrote: Brian Reichert wrote: On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote: My question is, in my admin script I deleted a record, but it still shows up using the other script. The admin script shows 102 records and the other shows 103. The record does show up in the 'publ

Re: 1 database; 2 scripts; different results

You can eliminate webserver/browser/caching issues from consideration by trying your query directly in the mysql client. Are you using InnoDB and transactions? It sounds to me as if you deleted the record but have not yet committed. In that case, the deleted record will be gone for the client

Re: 1 database; 2 scripts; different results

Brian Reichert wrote: On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote: My question is, in my admin script I deleted a record, but it still shows up using the other script. The admin script shows 102 records and the other shows 103. The record does show up in the 'public' script, so it'

Re: 1 database; 2 scripts; different results

Brian Reichert wrote: On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote: My question is, in my admin script I deleted a record, but it still shows up using the other script. The admin script shows 102 records and the other shows 103. The record does show up in the 'public' script, so it'

Re: 1 database; 2 scripts; different results

On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote: > My question is, in my admin script I deleted a record, but it still shows > up using the other script. The admin script shows 102 records and the > other shows 103. The record does show up in the 'public' script, so it's > not just a

Question concerning lack of binaries with OpenSSL support

This is an issue I have seen many people ask over the last year or two, but I can't say I've ever seen a comprehensive answer (searched the archives heavily, too). I realize there are no binaries available directly from MySQL with OpenSSL support compiled in. I am curious as to why (I'm sure th

1 database; 2 scripts; different results

I have one database that is currently being accessed by 2 scripts which query the database. One is for me to administer the db contents. The other is for public display, and so has the final buttons disabled for 'Delete', 'Add', 'Modify', 'Dump', and 'Restore'. Users can go through the motions o

Re: 4.1.4-gamma cannot compile

At 13:29 -0400 9/4/04, Michael Stassen wrote: Paul DuBois wrote: At 16:14 +0800 9/1/04, Unreal HSHH wrote: got this error and broken when making mysql 4.1.4-gamma automake-1.7: not found WARNING: `automake-1.7' is needed, and you do not seem to have it handy on your system. You might have

Re: Graphics and blobs

At 9:56 -0700 9/4/04, Stuart Felenstein wrote: This maybe OT but perhaps somone has a clue here. I am storing gifs in a Blob, well tinyblob field. I was under the assumption they could just be pulled out and shown on a web page similar to running any other query. Apparently not, someone have a hint

Re: 4.1.4-gamma cannot compile

Paul DuBois wrote: >At 16:14 +0800 9/1/04, Unreal HSHH wrote: > >> got this error and broken when making mysql 4.1.4-gamma >> >> automake-1.7: not found >> WARNING: >> `automake-1.7' is needed, and you do not seem to have it handy on your >> system. You might have modified some files without h

Re: Problems Compiling

--prefix is the only option you passed to configure? You must have missed the recommendations in the manual. Take a look at how MySQL builds their official binaries . There is also a section on building and other issues under Linux

Graphics and blobs

This maybe OT but perhaps somone has a clue here. I am storing gifs in a Blob, well tinyblob field. I was under the assumption they could just be pulled out and shown on a web page similar to running any other query. Apparently not, someone have a hint ? Thanks Stuart -- MySQL General Mailing

Re: Updating a one-to-many with a MIN result from 'many' for each 'one' record?

Yes, there's a better way -- use a temporary table: CREATE TEMPORARY TABLE minopen SELECT Account_Number, MIN(Open_DATE) AS min_open_date FROM Table1 GROUP BY Account_Number; UPDATE Table2, minopen SET Table2.Open_Date = minopen.min_open_date WHERE Table2.Account_

Re: Is it possible to have Undeletable Records?

I don't think so. I think your current method of either storing it in the query or with a boolean field is your best bet. What I've seen done in the past is that records get marked with a user level and there is either one or a group of users who are allowed to delete or modify those otherwise per

Updating a one-to-many with a MIN result from 'many' for each 'one' record?

I have a common update that I need to run that is a bottleneck in a lot of the reports that are being requested. If anybody else has dealt with a similar situation but with more success, any tips would be appreciated. Basically, I have a one-to-many relationship and I want to update every record i

SQL Error 1030 / Error 124 - Additional info

Hi, I get an SQL Error 1030 with error 124 (MySQL error: 124 = Wrong index given to function) during the execution of the following SQL statement: select t.Datum, t.kmStand, t.kmStand - max(h.kmStand) as km, t.Betrag, round(t.Menge,1) as Liter, round(t.Menge * 100 / (t.kmStand - max(h.kmStand)),

SQL Error 1030 / Error 124

Hi, I get an SQL Error 1030 with error 124 (MySQL error: 124 = Wrong index given to function) during the execution of the following SQL statement: select t.Datum, t.kmStand, t.kmStand - max(h.kmStand) as km, t.Betrag, round(t.Menge,1) as Liter, round(t.Menge * 100 / (t.kmStand - max(h.kmStand))

RE: please explain why this query isn't optimized

The other simple solution is to do something like this. Select changed FROM archived_stats order by changed DESC limit 0,1 I haven't actually tried it, it may be just as slow. If you always know that you have dates in the changed for the past week or past day, this may be an even better solution

Re: Problem on InnoDB - Tablespace enough but engine said table full

Heiki Thx... it's work :D Sorry, one liner Heikki Tuuri <[EMAIL PROTECTED]> wrote: Ady, - Alkuperäinen viesti - Lähettäjä: "Ady Wicaksono" Vastaanottaja: "Ady Wicaksono" ; "Heikki Tuuri" Kopio: Lähetetty: Friday, September 03, 2004 10:41 AM Aihe: Re: Problem on InnoDB - Tablespace

Re: HELP ME WITH THIS

Dear Dobromir Velev and members of list, Thank you so much for the help, yes the sql query works perfectly, though i did add some, as to cancel the duplicates ones, and also to not to take into negative timings, please advice on this too, select SEC_TO_TIME(unix_timestamp(concat(e.Date,' ',e.Time)

Re: please explain why this query isn't optimized

> >> Getting the same answer, from a simpler query, in infinitely >> less time, just seems wrong to me. > >Makes perfect sense. Simpler queries *are* easier to optimize, you >know :) Makes perfect sense. Thanks, I think the relevant points have been covered. -- MySQL General Mailing List Fo