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 v
(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
(Bregard
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 an
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-
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-
- 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 questi
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> kayamb
an 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:
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
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+-+--+--+-+---
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
SELECT DISTINCT FROM ORDER BY 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
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 t
quot; <[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
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 ad
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:
> >
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.
>
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,
> >
> >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.
&
ge 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:
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: d
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
--
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
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
FILE '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:
.
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
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: "
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: Wednesda
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
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
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: We
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_ta
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 wro
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
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, p
the server, it says that the alias name(dsn name) can't be found.
The server machine is Windows NT4.0 sp 6a and the client machines are
windows XP and windows 98.
The error message is
Unknown Database
AliasName : phmysql
where phmysql is my dsn name
Hope this clarifies you
Regards
Kay
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 P
lphi 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 li
ax 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
39 matches
Mail list logo
