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
(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
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
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
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
- 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
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
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, D
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 |
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
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
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
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
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 charac
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
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 a
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
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 in
ence.
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
rmatting).
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
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.
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.
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,
.
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
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
-
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
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
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,
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
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:
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
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
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
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,
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:
.
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
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
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
38 matches
Mail list logo