Japanese display problem with mysql on Linux
Hi folks I wrote an application which uses japanese characters. I can display japanese characters, fetching from a mysql database on my WindowsXP machine. I moved the same to a Linux machine and could see only junk characters. Any suggestions? MySQL version 4.0.13 on Win XP Japanese MySQL version 4.0.14 on Linux English But the charset is set to latin1 on both installation. I used the mysql binary distribution. Do I need to change this. If so how? Best Regards K.Suresh ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
copying innodb data
(It sucks; sql,query,mysql,...) (B (BHello folks (B I need to move my database from a WindowsNT environment to a Linux (BRedHat7.0 Box. I am now using innodb tables. Is there any easy way of (Bcopying my existing tables in NT Box to Linux? (B (B (BThanks for any suggestions (B (Bregards (B (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Conflict with 2 different database servers ?
Hello Folks (B I am building a C/S application with Delphi. I am now placing all my (Bmain databases in MySql 4.0.3(InnodB) Server. The temporary databases for (Bindividual users are kept as text files and as *Paradox db* files. (B There are cases when both the connections are active and I execute (Bqueries in MySql, getting some WHERE clause variables from Paradox . Will (Bthis lead to any conflict ? or Crash ? (B (BNote : (BI am not sure about the default port for Paradox (B (BAny help is appreciated (B (Bregards happy new year to all (B (BKayambooSuresh (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
entering Chr(13) Chr(10) in insert update
mysql, query, sql (B (BHello folks (B (B Is there any way I can insert Chr(13) Chr(10) along with string (Bcharacters in a blob field using *insert* or *update* statements. (B (B (B (BThanks for any suggestions (B (BKayambooSuresh (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
entering Chr(13) Chr(10) in insert update
mysql, query, sql (B (BHello folks (B (B Is there any way I can insert Chr(13) Chr(10) along with string (Bcharacters in a blob field using *insert* or *update* statements. (B (B (B (BThanks for any suggestions (B (BKayambooSuresh (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question: saving a file into a field of a table
- Original Message - From: Fabiana Garfunkel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 20, 2002 7:18 AM Subject: question: saving a file into a field of a table Hello, my name is Fabiana Garfunkel, and I´m new in MySQL developing. I have a punctual question: I need to save a zipped file into a field of a table. The question is: 1- is it possible to save a file into a field of a a table ? Yes. 2- if the answer is YES, which is the proper type of field for this ? Blob, MediumBlob,L.. 3- how can I save a file into a field ? LOAD DATA INFILE 'C:/a.zip' into table your table ; 4- how can I read or retrieve the file saved in a field of a table ? SELECT fieldName FROM your table INTO OUTFILE 'a.zip' ; If you don't specify any path, default will be MYSQLHOME/DATA/YOURDATABASE/a.zip Thanks a lot and best regards !!! GoodLuck Fabiana - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table syntax
I don't get you. But when I executed the drop table syntax fromt he command line, the result was this error mysql alter table town_db drop primary key ; ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db' (errno: 150) mysql Can you make me clear? regards - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: kayamboo [EMAIL PROTECTED] Cc: list mysql [EMAIL PROTECTED]; R. Hannes Niedner [EMAIL PROTECTED] Sent: Saturday, December 07, 2002 2:19 AM Subject: Re: alter table syntax In the last episode (Dec 06), kayamboo said: When I tried to drop the key, this was the error mysql alter table town_db drop primary key ; ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db' (errno: 150) And what does perror 150 return (it's a shell command, not an SQL one)? -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: alter table syntax
Thanks for the suggestions. (BIt worked fine (B (B (Bregards (B (B- Original Message - (BFrom: "Egor Egorov" [EMAIL PROTECTED] (BTo: [EMAIL PROTECTED] (BSent: Friday, December 06, 2002 11:36 PM (BSubject: re: Re: alter table syntax (B (B (B kayamboo, (B Friday, December 06, 2002, 9:15:04 AM, you wrote: (B (B (B k When I tried to drop the key, this was the error (B (B k mysql alter table town_db drop primary key ; (B k ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to (B'.\forest\town_db' (B k (errno: 150) (B (B k I suppose some lock in the index somewhere but couldnot figure it out. (B (B Did you have another table with foreign key constraints for which (B town_db is a parent table? If so, you need to create index on the (B 'town' and then drop PRIMARY KEY. (B (B (B (B (B -- (B For technical support contracts, goto https://order.mysql.com/?ref=ensita (B This email is sponsored by Ensita.net http://www.ensita.net/ (B__ ___ ___ __ (B / |/ /_ __/ __/ __ \/ /Egor Egorov (B / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] (B /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net (B___/ www.mysql.com (B (B (B (B (B - (B Before posting, please check: (Bhttp://www.mysql.com/manual.php (the manual) (Bhttp://lists.mysql.com/ (the list archive) (B (B To request this thread, e-mail [EMAIL PROTECTED] (B To unsubscribe, e-mail (B[EMAIL PROTECTED] (B Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php (B (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
alter table syntax
sql, mysql, query (B (BHello folks (B (BThis is my table structure with MySql 4.0.3-beta-max-nt with InnoDB (B (B+-+--+--+-+-+---+ (B| Field | Type | Null | Key | Default | Extra | (B+-+--+--+-+-+---+ (B| town| varchar(50) | | PRI | | | (B| subcity | varchar(50) | | MUL | | | (B| rankt | int(10) unsigned | | | 0 | | (B+-+--+--+-+-+---+ (B3 rows in set (0.01 sec) (B (BNow I want to have the primary key on both town and subcity fields like this (B (Bmysql describe town_db1 ; (B+-+--+--+-+-+---+ (B| Field | Type | Null | Key | Default | Extra | (B+-+--+--+-+-+---+ (B| town| varchar(50) | | PRI | | | (B| subcity | varchar(50) | | PRI | | | (B| rankt | int(10) unsigned | | | 0 | | (B+-+--+--+-+-+---+ (B3 rows in set (0.00 sec) (B (BI am able to create new table but can't alter the existing one to achieve (Bthis. (B (B (BAny suggestions with alter syntax is highly appreciated (B (BThanks for your time (B (BRegards (B (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table syntax
Sorry, I tried that before. *** This is my show create table syntax mysql show create table town_db ; +-+- | Table | Create Table +-+- | town_db | CREATE TABLE `town_db` ( `town` varchar(50) NOT NULL default '', `subcity` varchar(50) NOT NULL default '', `rankt` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`town`), KEY `subcity` (`subcity`), FOREIGN KEY (`subcity`) REFERENCES `forest.subcity_db` (`subcity`) ON DELETE CASCADE ) TYPE=InnoDB | +-+- 1 row in set (0.00 sec) *** I used this to create the table CREATE TABLE TOWN_DB( town VARCHAR(50) NOT NULL PRIMARY KEY, subcity VARCHAR(50) NOT NULL, rankt INT UNSIGNED NOT NULL, INDEX( subcity ) , FOREIGN KEY( subcity ) REFERENCES subcity_db( subcity ) ON DELETE CASCADE) TYPE = INNODB ; * When I tried to drop the key, this was the error mysql alter table town_db drop primary key ; ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db' (errno: 150) I suppose some lock in the index somewhere but couldnot figure it out. regards - Original Message - From: R. Hannes Niedner [EMAIL PROTECTED] To: MySQL Mailinglist [EMAIL PROTECTED] Sent: Friday, December 06, 2002 3:50 PM Subject: Re: alter table syntax ALTER TABLE town_db1 DROP PRIMARY KEY; ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity ); On 12/5/02 10:31 PM, kayamboo [EMAIL PROTECTED] wrote: sql, mysql, query Hello folks This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | town| varchar(50) | | PRI | | | | subcity | varchar(50) | | MUL | | | | rankt | int(10) unsigned | | | 0 | | +-+--+--+-+-+---+ 3 rows in set (0.01 sec) Now I want to have the primary key on both town and subcity fields like this mysql describe town_db1 ; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | town| varchar(50) | | PRI | | | | subcity | varchar(50) | | PRI | | | | rankt | int(10) unsigned | | | 0 | | +-+--+--+-+-+---+ 3 rows in set (0.00 sec) I am able to create new table but can't alter the existing one to achieve this. Any suggestions with alter syntax is highly appreciated Thanks for your time Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query question
SELECT DISTINCT FILEDNAME FROM TABLENAME ORDER BY FIELDNAME ASC ; - Original Message - From: Kevin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 2:40 PM Subject: query question Hello, I have a table with a list of names. I need to get a distinct list of the names by first letter, as follows: John Mary Mark Tom the query should return the following: J M T Is there any way to this with a single query? TIA -Kevin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query question
Hope this will work for u select distinct substring(name, 1,1) from test1 order by name asc ; - Original Message - From: Kevin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 2:40 PM Subject: query question Hello, I have a table with a list of names. I need to get a distinct list of the names by first letter, as follows: John Mary Mark Tom the query should return the following: J M T Is there any way to this with a single query? TIA -Kevin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
language charset
Hello Folks I am so far using japanese characters with mysql without any problem. But today when I try to insert some japanese characters, only one character get truncated to a . (dot) mark. How can I set the default charset in the .cnf or .ini file ? With MyISAM, I used to set in the mysql admin. Now I am not using MySQL admin with innodb Thanks for any help regards KayambooSuresh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: language charset
Egor As you said I have set the default-character-set = sjis But I need few clarfications for my strange problems I am using mysql 4.0.3-beta(innodb) on windows NT 4.0 (SP6) machine 1. Under \MYSQL_HOME\SHARE\CHARSETS, there is no config file for sjis like the ones for cp1251, german1 etc. Will this affect the charset structure for japanese 2. Secondly I created a table CREATE TABLE PLOT_DB( plotname VARCHAR(5) NOT NULL PRIMARY KEY ) TYPE = INNODB ; When I insert japanese alphabets of size 1 from a text file, it throws error-- primary key violation. ( the characters I am inserting are unique) When I removed PRIMARY KEY constraint, they are inserted without any error 3. But When I use select * from plot_db, the characters are not properly displayed and are masked. But when the size is reduced to 1 ( VARCHAR(1) ), they are displayed properly In DB tools the characters are displayed followed by a dot mark. when the size is VARCHAR(5). They are displayed properly when the VARCHAR(1), that is the exact size of the characters. 4. When I load the characters back to a text file, the same distortion is found. How can I rectify these errors ? My problem is this happens exactly when the varchar size, I am declaring exceeds the actual size of the characters I am inserting. That too only for certain characters. 5. How MySQL handles the data transfer? Is it binary mode or ASCII mode? regards - Original Message - From: "Egor Egorov" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 7:51 PM Subject: re: language charset kayamboo, Tuesday, October 15, 2002, 12:31:39 PM, you wrote: k I am so far using japanese characters with mysql without any problem. k But today when I try to insert some japanese characters, only one character k get truncated to a . (dot) mark. k How can I set the default charset in the .cnf or .ini file ? [mysqld] dafault-character-set=# k With MyISAM, I used to set in the mysql admin. k Now I am not using MySQL admin with innodb -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
inserting records
Hello folks ** sql,query * Can anyone give me a clue, how to solve this problem I have a table with only one column and values are inserted by getting user request from my application. I want to display the column values in the order they are inserted. So only option is to go for another column with an auto increment key. eg. col Acol B 1 apple 2 orange 3 apefruit But the user should have the option to insert data in between, any two existing column values. He can also delete any record. And now I want to display the records in the new order. eg. col B apple orange jack apefruit Any suggestions ? regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: password / last record
Hi Arjen If that is the case, suppose if I have forgotten the string password of a particular user But I want to grant certain privileges to him, is GRANT DELETE ,. ON Database Name TO User Name IDENTIFIED BY 'Encrypted Password' valid ? regards - Original Message - From: "Arjen Lentz" [EMAIL PROTECTED] To: "kayamboo" [EMAIL PROTECTED] Cc: "list mysql" [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 1:08 PM Subject: Re: password / last record Hi, On Thu, 2002-10-10 at 10:57, kayamboo wrote: 1. Is there anyway to know the string value of the password using the encrypted value , from the mysql.user table ? No. It's scrambled with a one-way (lossy) algorithm. 2. How can I know the most recently entered record, that does not have an AUTOINCREMENT column ? You can't. Rows are by definition un-ordered in SQL databases, because storage is an internal matter for the server, it can do it any way it sees fit (it'll depend on the format, and other considerations like filling gaps of deleted rows, etc). The only logical ordering is one you put in (with AUTO_INCREMENT or timestamps or whatever). Actually you would only see that order if you use SELECT ... ORDER BY ... Otherwise, output is also unordered! (the fact that it may appear ordered while not using ORDER BY is purely coincidence: delete a row and insert a new one and you'll definitely find more disorder ;-) Regards, Arjen. -- MySQL Training in Auckland and Sydney, http://www.mysql.com/training/ Purchase Training, Support, Licenses @ https://order.mysql.com/?marl __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
drop constraint in innodb
sql, query Hi Folks ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES Syoyu_db( Code, Kana) ON DELETE CASCADE ; works fine. But how to drop the constraint or modify the constraint ? Simply changing ADD to DROP or MODIFY throws errors regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: drop constraint in innodb
Is there any other way to do this in a table with thousands of records. - Original Message - From: "Heo, Jungsu" [EMAIL PROTECTED] To: "kayamboo" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 8:50 PM Subject: Re: drop constraint in innodb Last week, I posted a message related to this. Heikki (InnoDB Developer) said "sorry, DROP CONSTRAINT is not implemented yet." - Original Message - From: "kayamboo" [EMAIL PROTECTED] To: "list mysql" [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 2:45 PM Subject: drop constraint in innodb sql, query Hi Folks ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES Syoyu_db( Code, Kana) ON DELETE CASCADE ; works fine. But how to drop the constraint or modify the constraint ? Simply changing ADD to DROP or MODIFY throws errors regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing PDF files in mysql ?????
Hello There are lots of discussions in this regard and the suggestions are always to save your blob somewhere in your hard disk and just store the path. In my case, each of my image is around 1MB but you know, I find it difficult to map the images stored in a particular machine, through a network using Delphi. But storing in the database solves most of the problems and the users can also easily load and retrieve them. But any suggestions from experts in this regard is welcome regards - Original Message - From: "Alexis Antonakis" [EMAIL PROTECTED] To: "list mysql" [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 8:57 PM Subject: RE: storing PDF files in mysql ? Hi, The thing I was wondering is whether there is any advantage in saving IMAGES in a database? I have had a little play around with a 50k jpeg file and it appears that if I save it in Blob format, then the filesize of the database increases by 50K as well, and surely converting it from/to a database just add time to the loading of a page, albeit it very minimal, but as I am designing a site which will host huge numbers of photos, this will make a big difference. Any thoughts or advice on this topic will be most appreciated. Regards Alexis -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: 09 October 2002 01:20 To: toby z Cc: list mysql Subject: Re: storing PDF files in mysql ? I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: "R.Dobson" [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: ht
Re: storing PDF files in mysql ?????
Hi toby Just replace the .gif with your .pdf. I hope this will work for you. INSERT INTO photo(name , pic, picname) values( 'raman', load_file('e:/mysql/images/Click.gif'),'Click.gif') ; SELECT length(pic) FROM photo WHERE picname = 'Click.gif' ; UPDATE photo SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name = 'velan' ; SELECT pic FROM photo WHERE name = 'velan' INTO DUMPFILE 'C:/TEMP/pic2.gif' Good Luck - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 9:45 PM Subject: RE: storing PDF files in mysql ? thnx guyz 1) i m tryin to put the pdf file into a blob field but i cant insert it like normal text how shall i go about inserting it 2) i m in the process of converting the word doccuments to pdf got this acrobat disteller n m havin a million probz with that alone like the security issue I NO THIS IS THE WRONG LIST SORRY FOR THIS Q BUT .. has anyone worked with this thing n wouldnt mind me mailin him/her plz do lemme no guyz plz hlp . thnx a billion toby From: "Sqlcoders.com Programming Dept" [EMAIL PROTECTED] To: "toby z" [EMAIL PROTECTED],"list mysql" [EMAIL PROTECTED] Subject: RE: storing PDF files in mysql ? Date: Tue, 8 Oct 2002 21:47:23 -0600 Toby, If I understand correctly you want to perform two distinct actions: 1. Convert Microsoft Office Word .doc files into .pdf 2. Store those pdf's in MySQL. You should look into (via google.com) some doc to pdf converters. An example is this com object: http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy, it costs $219 and converts .doc to .pdf. If you can convert the .doc's into .html files, you might be able to get away with using Adobe's free email converter service. Email the HTML document to [EMAIL PROTECTED], wait an hour or so, and you'll find a pdf version in your inbox. (There's also a [EMAIL PROTECTED] address if you dont want to use html, but I think you wanted to keep formatting). Once you have the document in PDF, it's a relatively trivial action to store the documents in your MySQL database. HTH, William. -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 18:20 To: toby z Cc: list mysql Subject: Re: storing PDF files in mysql ? I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: "R.Dobson" [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ri
Re: drop constraint in innodb
HI If suppose my table has thousands of records, is it possible to create a new table without a foreign key constraint, and then copy the existing data with the foreign key constraint to the new one ? regards - Original Message - From: "Egor Egorov" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 9:15 PM Subject: re: drop constraint in innodb kayamboo, Wednesday, October 09, 2002, 8:45:39 AM, you wrote: k ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES k Syoyu_db( Code, Kana) ON DELETE CASCADE ; k works fine. k But how to drop the constraint or modify the constraint ? k Simply changing ADD to DROP or MODIFY throws errors Curretly you can't drop only foreign key constarints. You should re-create a table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
password / last record
sql, query Hello Folks 1. Is there anyway to know the string value of the password using the encrypted value , from the mysql.user table ? 2. How can I know the most recently entered record, that does not have an AUTOINCREMENT column ? Thanks for the tips. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing PDF files in mysql ?????
I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: "R.Dobson" [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updating blob from command line
Paul, I checked for InnoDb and this have to work with MyIsam also. But also decide your size. If your size exceeds the limit, it get truncated and u never come to know during insert. so you can go for mediumblob if it exceeds the blob size. Check for the size restrictions in the manual. regards - Original Message - From: Ivan Paul [EMAIL PROTECTED] To: kayamboo [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 3:11 PM Subject: Re: Updating blob from command line dear kayamboo, can i use myisam table type to input my blob data in gif/jpeg (image format)? TIA, Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: kayamboo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: list mysql [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 09:55 Subject: Fw: Updating blob from command line sorry i missed the update statement UPDATE temponly SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name = 'velan' ; regards - Original Message - From: kayamboo [EMAIL PROTECTED] To: Chris [EMAIL PROTECTED] Cc: list mysql [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 9:15 AM Subject: Re: Updating blob from command line CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE = INNODB ; INSERT INTO temponly(name , pic) values( 'velan', load_file('e:/mysql/images/Click.gif')) ; Hope this helps. - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:31 PM Subject: Updating blob from command line Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to be able to update the database with the new image through a script since it needs to be automated. Does anybody have any ideas, and can this be done? Thanks! - Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updating blob from command line
Hope this helps u CREATE TABLE photo( name VARCHAR(50) NOT NULL, pic MEDIUMBLOB, picname varchar(50), INDEX(name), FOREIGN KEY(name) REFERENCES person(name) ON DELETE CASCADE ) TYPE = INNODB ; INSERT INTO photo(name , pic, picname) values( 'raman', load_file('e:/mysql/images/Click.gif'),'Click.gif') ; SELECT length(pic) FROM photo WHERE picname = 'Click.gif' ; UPDATE photo SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name = 'velan' ; SELECT pic FROM photo WHERE name = 'velan' INTO DUMPFILE 'C:/TEMP/pic2.gif' ; now you can go to c:/temp/pic2.gif and open in a browser to check whether it is corrupted or transferring etc., regards - Original Message - From: Ivan Paul [EMAIL PROTECTED] To: kayamboo [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:25 PM Subject: Re: Updating blob from command line dear kayamboo, if i'm not wrong, there is three blob type: 1. blob 2. medium blob 3. long blob, but problem for me now, is how to initialize the blob type (blob/medium/long) into table structure. so can u give me some information about that, i mean the command to create medium or longblob. for table example: create table blob_test ( blob_test_id bigint null auto_increment, blob_sbj varchar(40) null, blob_img ???, primary key(blob_test_id), index idx_blob_test_id(blob_test_id) ); TIA, Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: kayamboo [EMAIL PROTECTED] To: Ivan Paul [EMAIL PROTECTED] Cc: list mysql [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 13:53 Subject: Re: Updating blob from command line Paul, I checked for InnoDb and this have to work with MyIsam also. But also decide your size. If your size exceeds the limit, it get truncated and u never come to know during insert. so you can go for mediumblob if it exceeds the blob size. Check for the size restrictions in the manual. regards - Original Message - From: Ivan Paul [EMAIL PROTECTED] To: kayamboo [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 3:11 PM Subject: Re: Updating blob from command line dear kayamboo, can i use myisam table type to input my blob data in gif/jpeg (image format)? TIA, Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: kayamboo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: list mysql [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 09:55 Subject: Fw: Updating blob from command line sorry i missed the update statement UPDATE temponly SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name = 'velan' ; regards - Original Message - From: kayamboo [EMAIL PROTECTED] To: Chris [EMAIL PROTECTED] Cc: list mysql [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 9:15 AM Subject: Re: Updating blob from command line CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE = INNODB ; INSERT INTO temponly(name , pic) values( 'velan', load_file('e:/mysql/images/Click.gif')) ; Hope this helps. - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:31 PM Subject: Updating blob from command line Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to be able to update the database with the new image through a script since it needs to be automated. Does anybody have any ideas, and can this be done? Thanks! - Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updating blob from command line
| +---+--- + | Test |GIF89ak | +---+--- + 1 row in set (0.00 sec) mysql mysql select length(pic) from tblob where title = 'Test' ; +-+ | length(pic) | +-+ |2237 | +-+ 1 row in set (0.00 sec) regards - Original Message - From: Ivan Paul [EMAIL PROTECTED] To: kayamboo [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Friday, September 27, 2002 1:14 PM Subject: Re: Updating blob from command line dear kayamboo, i've tried it, but seems there still something strange with this matter, so i decided to create one table with myisam table type (default table type), and i try to input data in this table. but when i check this up (do query) i have null value in mediumblob field (pic). this is the captured process... Logging to file 'c:\mysql\problem.txt' mysql create table tblob - ( - title varchar(100) null, - pic mediumblob null - ); Query OK, 0 rows affected (0.06 sec) mysql desc tblob; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | title | varchar(100) | YES | | NULL| | | pic | mediumblob | YES | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql insert into tblob - values('Test', load_file('c:/mysql/betasw.gif')); Query OK, 1 row affected (0.00 sec) mysql select * from tblob; +---+--+ | title | pic | +---+--+ | Test | NULL | +---+--+ 1 row in set (0.00 sec) mysql \t TIA, Ivan Paul sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Set Path Environment
Why not you set the path in your environment variables and restart the computer Are you using win98 or NT? - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:33 AM Subject: Set Path Environment Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\ prompt, I get the following error: C:\mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have a nice day. William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updating blob from command line
CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE = INNODB ; INSERT INTO temponly(name , pic) values( 'velan', load_file('e:/mysql/images/Click.gif')) ; Hope this helps. - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:31 PM Subject: Updating blob from command line Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to be able to update the database with the new image through a script since it needs to be automated. Does anybody have any ideas, and can this be done? Thanks! - Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Updating blob from command line
sorry i missed the update statement UPDATE temponly SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name = 'velan' ; regards - Original Message - From: kayamboo [EMAIL PROTECTED] To: Chris [EMAIL PROTECTED] Cc: list mysql [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 9:15 AM Subject: Re: Updating blob from command line CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE = INNODB ; INSERT INTO temponly(name , pic) values( 'velan', load_file('e:/mysql/images/Click.gif')) ; Hope this helps. - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:31 PM Subject: Updating blob from command line Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to be able to update the database with the new image through a script since it needs to be automated. Does anybody have any ideas, and can this be done? Thanks! - Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Character Set Settings
What you mean by explorer pages? Browser? If so you have to set the correct character set at the beginning of each place, whether asp, jsp, php or html. regards - Original Message - From: [EMAIL PROTECTED] To: Nikolaos Georgiafentis [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 4:54 PM Subject: RE: Character Set Settings Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql select * from test - ; +--+ | data | +--+ | åíá | | ÅÍÁ | | ÄÕÏ | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installing mysql together with application
It is obvious, even in windows you have to set the configuration files atleast. It is the privilege of the user to install the stuff anywhere in his computer and so he has to change the .inf or .cnf accordingly Why not you try onething called the embedded mysql. If you just want to go with your way, better make one more program in java to get the installation directory as input from the user and accordingly change the configuration files and put them in winnt/ or windows/ regards - Original Message - From: Martijn van Iersel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 4:45 PM Subject: installing mysql together with application Hello I want to distribute my java database application together with mysql, and I want to make it as easy as possible. Right now a new user has to: - download and install mysql - run the mysql server with mysqld --standalone or a similar command - download my program and run it. To make this easier for the user, I tried to zip mysql together with my program (the whole c:\mysql directory except the data directory), and to issue the mysqld --standalone command each time the user starts my program, but it doesn't work (it would be too easy, wouldn't it?). When I try that, see below for the errors that appear in mysql.err: I want my program in a single zip file, and that you only have to unzip it, type setup and then run to make it work. Is there a better way to achieve this? It only has to work under Windows (I am assuming here that linux users are smart enough to set up mysql by themselves) thanks in advance Martijn van Iersel Here are the errors I get: Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020925 10:19:34 bin\mysqld: Table 'mysql.host' doesn't exist Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020925 10:20:05 bin\mysqld: Table 'mysql.host' doesn't exist __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Japanese Charset
Hello friend I am not an expert in mysql and I am also a newbie But As for I think, mysql has nothing to do with this problem. I am using mysql with jsp to store and retrieve japanese characters. My O/S is also japanese WindowsNT4.0SP6a. Despite I get errors in my browser in the beginning.So I wrote a small bean component. This component will read the characters(Shift_JIS , a,b or any) and convert into (8859_1) and put it into the database While retrieving the data, I will do the reverse. Also make sure the right charset is set in your html page My knowledge in asp is a big zero. So if you are using jsp, I can send you the bean. Best of luck - Original Message - From: Dawn Friedland [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Joel Rees [EMAIL PROTECTED]; Shashank Tripathi [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 4:54 PM Subject: RE: Japanese Charset Here's a brief summary of where we are: I trying to store Japanese text (Shift_Jis) in MySQL and view it from a web page. The content is provided to me in Word format. I convert it to plain text, copy/paste into a web form in an ASP-based CMS on a Windows box. When viewed from a web page, seemingly random characters are morphed into other characters. The majority of the database contains rows in Latin. MySQL supports Japanese and Latin in the same table. Other people are able to do this without the morphing problem. My Regional Language settings in Windows are set to to Shift_Jis in order to view Shift_Jis characters in notepad and the DOS prompt. If I circumvent the CMS and copy/paste from notepad directly to MySQL in the DOS Prompt, the results are the same (although fewer characters are broken when viewed through DOS). For a good explanation visit this problem's web site: http://commworks01.barklouder.com/japan/press/broken_chars.asp I conclude that one of two things may be happening: 1. Characters are being corrupted by virtue of the fact that their source of origination were copied from Word, despite the conversion to plain text. (At this point I do not have a plain text file with content typed directly into notepadi.e. Word circumvented. I am at the mercy of the client's PR department.) 2. Characters are being corrupted by MySQL. If option 1 were true, then why do the characters show up fine when in a static HTML document? (see below). In Response to Joel Rees: I checked the text you gave me, and I found what's getting clobbered. It's the latter half of characters like the katakana 'so'. Although the byte that is getting walked on here is 0x5c, this is _not_ the escape character. It is preceded (in the case of katakana 'so') by a byte of 0x83. The entire character is '0x835c', and the 0x5c is being treated as if it were a backslash. There are other characters that will get hit by this, by the way. Question 1: It seems like a lot more characters are getting hit than just '0x835c'. How do I map the 0x835c to what the character looks like? I don't know what 0x835c is. Question 2: How do I handle the character escape mechanism correctly according to MySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
image size in mysql
filter;sql;query Hello folks Can anyone pls give some useful tips for these questions 1.I have to store some images in the db. Each image size is around 800kb to 900kb(almost 1 mb). Will it affect the performance. I am using mediumblob for this. 2.Secondly, if I am storing for eg. this is my_table id pic varchar(50)mediumblob suppose if i insert 3 rows like insert into my_table('', load_file('c:/images/a.jpeg')) ; insert into my_table('', load_file('c:/images/b.bmp')) ; insert into my_table('', load_file('c:/images/c.gif')) ; is there any way of knowing the 1. file type eg. jpeg, bmp, gif 2. name of the file inserted. eg. a,b,c 3. Thirdly does mysql treat jpeg and jpg formats differently? 4.Is there any reason to fear, the blob data get corrupted while inserting or selecting ? for eg. if I issue a statement like this from the command prompt select * from my_table ; thanks for any suggestions ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Loading jpeg and avi files to blob
Hello everyone Can anyone give me some tips on how to insert and select jpeg and avi files to a blob data type ? Version used : mysql4.0.3-beta(innodb) DTool : Delphi5.0 with zeos libraries Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ABUSE? , myisampack , sql , admin [T2002091901XL]
Me too received the same but dont know why - Original Message - From: Franz, Fa. PostDirekt MA [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 8:03 PM Subject: WG: ABUSE? , myisampack , sql , admin [T2002091901XL] -Ursprüngliche Nachricht- Von: Franz, Fa. PostDirekt MA Gesendet am: Donnerstag, 19. September 2002 13:00 An: '[EMAIL PROTECTED]' Betreff: AW:ABUSE? , myisampack , sql , admin [T2002091901XL] Hi there, i received this message , after sending a request to mysql-mailing-list: Thank you for bringing this matter to our attention. We are sorry for any inconvenience it has caused you. Because we receive a large number of complaints each day at [EMAIL PROTECTED], regretfully, a personalized response to each message is not possible. Please be assured that Verizon investigates each reported occurrence of unsolicited e-mail or spamming. We maintain a zero-tolerance policy in regard to spamming and will take the appropriate action as permitted by Verizon's Acceptable Use Policy. To view our policy, please refer to one of the two following links: Former Bell Atlantic users: http://www.bellatlantic.net/help/faqs/#faqpolicies Former GTE users: http://www.gte.net/hotlinks/policies/agreement.html To better understand the problems with unsolicited e-mail, we have provided information about filtering Spam with your e-mail software, answers to several frequently asked questions and links to some useful online information about Spam at the following link: http://www.gte.net/announcements/spam.html You may also link directly to our page about unsolicited e-mail: http://www.gte.net/contact/spam.html If you are reporting an issue of hacking or other security issues not related to e-mail abuse, please submit your report to [EMAIL PROTECTED] for investigation. Sincerely, Verizon Internet Services [EMAIL PROTECTED] It wasn't my intention to abuse , offend or spam anyone or anything and i think i didn't do something like that at all. If i did , i am very sorry about it , but I'd like to know : What went wrong? mfg Klaus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql4.0.3-beta with delphi5.0
Hello friends Is there anyone using mysql with delphi5.0 I will be very thankful to get some tips to connect to a remote server running mysql4.0.3-beta using delphi5.0 odbc dsn. I am able to connect with a local server but can't with a remote server. I can't find any help in the delphi sites. Any tips or suggestion urls will be greatly appreciated Regards Kayamboo Suresh sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table creation error with innodb/ sql,query
Thanks a lot Chris It worked for me. But I refered somewhere , that using excessive index will eat up resources. So is it mandatory to use index even if I am not using them for something like search? regards Kayamboo Suresh - Original Message - From: "Chris Tucker" [EMAIL PROTECTED] To: "kayamboo" [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 5:35 PM Subject: Re: table creation error with innodb/ sql,query InnoDB requires that you have an index on both ends of a foreign key constraint. Thus, you need to index the "type" field of the person table. Change your create statement to: CREATE TABLE person( name VARCHAR(50) NOT NULL PRIMARY KEY, type VARCHAR(50) NOT NULL, dob DATE, INDEX (type), FOREIGN KEY(type) REFERENCES relation(type) ON DELETE CASCADE ) TYPE = INNODB ; And you should have no problems (note that if "type" was not the primary key on the "relation" table you would also have to explicitly declare an index for that column). Chris On Mon, 2002-09-16 at 22:45, kayamboo wrote: Hello experts I am trying to create innodb tables with foreign key relations but I get error 150 meaning that foregin key constraint can't be established. Here are the statements 1.CREATE TABLE relation( type VARCHAR(50) NOT NULL PRIMARY KEY)TYPE = INNODB; 2.CREATE TABLE person( name VARCHAR(50) NOT NULL PRIMARY KEY, type VARCHAR(50) NOT NULL, dob DATE, FOREIGN KEY(type) REFERENCES relation(type) ON DELETE CASCADE ) TYPE = INNODB ; But if I remove the type = innodb in the second statement, it is executed. Then I am using the ALTER TABLE syntax to create innodb tables. Any advice to avoid this alter table syntax? Or my create statement is wrong? Thanks in advance Regards Kayamboo Suresh sql,query,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table creation error with innodb/ sql,query
Hello experts I am trying to create innodb tables with foreign key relations but I get error 150 meaning that foregin key constraint can't be established. Here are the statements 1.CREATE TABLE relation( type VARCHAR(50) NOT NULL PRIMARY KEY)TYPE = INNODB; 2.CREATE TABLE person( name VARCHAR(50) NOT NULL PRIMARY KEY, type VARCHAR(50) NOT NULL, dob DATE, FOREIGN KEY(type) REFERENCES relation(type) ON DELETE CASCADE ) TYPE = INNODB ; But if I remove the type = innodb in the second statement, it is executed. Then I am using the ALTER TABLE syntax to create innodb tables. Any advice to avoid this alter table syntax? Or my create statement is wrong? Thanks in advance Regards Kayamboo Suresh sql,query,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php