h)
> VARCHAR(length)
> BINARY(length)
> VARBINARY(length)
>
> --
> Sebastian
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
View this messag
Ganesh's screen schrieb:
> Is there a way to restrict the length of text field in MySQL. For example, it
> is of 65K limit and could hold more than 2 characters. Is there a way to
> restrict that to 4000 characters at table/field level. Coz the
> max_allowed_packet constrainted the entire DB.
message in context:
http://www.nabble.com/Limiting-the-text-size-on-text-fields-tf4627867.html#a13213842
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
I followed the instructions to change columns values from an encoding
another
(in my case from latin1 to utf8), but the operation simply failed.
The manual reads
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html :
"
If you want to change the table default character set and all ch
On 2006-01-20, at 01:13, Tucker Cunningham wrote:
So, my question is: what are the pros and cons of using varchar
vs. text/longtext? Right now, longtext seems to be the best option
(it provides most flexibility in data that can be stored, at only a
2-byte-per-row storage premium) There
hi all -
I was looking for some clarification about the difference between
varchar and the text types in MySQL 5.0.18. It seems to me that varchar
and text both hold text data, are variable length, and have the same
storage requirements (4 + L bytes). Also, longtext adds the ability to
hol
On Wed, 12 Oct 2005 13:27:52 +0200, wrote:
>zzapper wrote:
>> Hi,
>> Recently had a few problems with comparing numbers stored in text
>> mysql fields char(2), which I solved by chnging the field to int(1)
>>
>> Now my question is why do you sometimes "appear" to get away with
>> this?
>
>My gues
zzapper wrote:
> Hi,
> Recently had a few problems with comparing numbers stored in text
> mysql fields char(2), which I solved by chnging the field to int(1)
>
> Now my question is why do you sometimes "appear" to get away with
> this?
My guess is that if the numbers are of the same length (numbe
Hi,
Recently had a few problems with comparing numbers stored in text mysql fields
char(2), which I
solved by chnging the field to int(1)
Now my question is why do you sometimes "appear" to get away with this?
--
zzapper
Success for Techies and Vim,Zsh tips
http://SuccessTheory.com/
--
MySQ
Hello.
Use TEXT or BLOB columns' types. See:
http://dev.mysql.com/doc/mysql/en/blob.html
Use hexademical values in your scripts which load pages
in the database. See:
http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html
Possibly you'll need to increase packet size. See:
h
[snip]
Please could you advise me my MySql, is a bit shacky.
I need to capture about 700 web pages to a large text column in my
database, the search for all the links in the pages within the column
and replace them with new relative links .. to the pages now stored in
the data base ..
so how do I
Hi all...
Please could you advise me my MySql, is a bit shacky.
I need to capture about 700 web pages to a large text column in my
database, the search for all the links in the pages within the column
and replace them with new relative links .. to the pages now stored in
the data base ..
so how do
MySQL: 4.1.11
OS: Solaris
I have a database that stores Japanese in utf-8. I have NO problems if
the field is defined as VARCHAR, but if the field is defined as TEXT any
data after an extended character (Japanese, special symbols etc.) gets
truncated. Looking at the archives I ran the followin
To: [EMAIL PROTECTED]
>To: mysql@lists.mysql.com
>Subject: Re: Load data infile and text fields
>Date: Sun, 10 Apr 2005 02:32:28 +0200
>Cc: [EMAIL PROTECTED]
>
>
>Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]:
>> First of all I hope you can be patient for my en
Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]:
> First of all I hope you can be patient for my english
> I'm working with data import into mysql from a txt file. I'm using LOAD
> DATA INFILE
> command but I cannot correctly import a text column of 595 characters.
> I receive this (v
ino" <[EMAIL PROTECTED]>
>To: "mysql" ,
> <[EMAIL PROTECTED]>
>Subject: Re: Load data infile and text fields
>Date: Mon, 4 Apr 2005 15:52:06 -0400
>
>
>Stefano,
>
>I'm copying this to the mailing list. I think it is a lot better if we
have
On Apr 4, 2005, at 3:52 PM, Rhino wrote:
Stefano,
I'm copying this to the mailing list. I think it is a lot better if we
have
discussions of this kind on the mailing list so that others can also
learn
from them, either now or in the future via the mailing list archive.
I'm glad to hear that you
--
From: <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Monday, April 04, 2005 12:24 PM
Subject: Re: Load data infile and text fields
Rhino, many thanks for your answer! My problem is that I need a filed with
precision for a field of exactly 595 characters! Only te
lot
of little msword documents. Each record should have a single word file.
I'd like to write a query (I hope without using api as php or other languages)
that imports automatically all .doc files stored ina dir. Have any idea?
Thanks
Stefano
>-- Messaggio originale --
>Subject: Re: L
Hello.
Do you use a VARCHAR type for that column? It's maximum
length is limited to 255 characters. I think, switching to TEXT type
could solve the problem.
[EMAIL PROTECTED] wrote:
> First of all I hope you can be patient for my english
> I'm working with data import into mysql f
Rhino
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 02, 2005 6:51 AM
Subject: Load data infile and text fields
First of all I hope you can be patient for my english
I'm working with data import into mysql from a txt file. I'm using LOAD
DATA
What is the structure of the table you are importing to? you might have
merely hit the natural limit of the column type.
- michael dykman
On Sat, 2005-04-02 at 06:51, [EMAIL PROTECTED] wrote:
> First of all I hope you can be patient for my english
> I'm working with data import into mysql f
First of all I hope you can be patient for my english
I'm working with data import into mysql from a txt file. I'm using LOAD
DATA INFILE
command but I cannot correctly import a text column of 595 characters.
I receive this (very large) file from an external organization and this
file is made
w
;[EMAIL PROTECTED]> wrote:
> I have to put html links inside varchar and text fields. They have to be
> (somehow) fulltext searchable (of course a substring, %keyword% search,
> would pick them up - I realize that) and they have to render as
> clickable links when I output the fie
Just put the href into the database.
When you output it to html in PHP wrap it wth the rest.
$href=$sql->data['href'];
echo "The Link\n";
leegold wrote:
I have to put html links inside varchar and text fields. They have to be
(somehow) fulltext searchable (of course a subs
I have to put html links inside varchar and text fields. They have to be
(somehow) fulltext searchable (of course a substring, %keyword% search,
would pick them up - I realize that) and they have to render as
clickable links when I output the fields via PHP. How would I do this?
Is this more of a
Folks --
I'm using
Client version:mysql Ver 14.6 Distrib 4.1.5-gamma, for pc-linux
(i686)
Server version: 4.1.5-gamma-standard-log
They both happen to both be on the same system, which is RHEL AS 3.
All defaults are now UTF8:
Server characterset:utf8
Db characterset:u
David Blomstrom <[EMAIL PROTECTED]> wrote on 07/14/2004 10:16:41
PM:
> I was just curious how most of you do it. Do you just
> dump in your text, or do you go to extra lengths to
> make sure each paragraph begins on a new line in your
> database? Whay code do you use for line breaks, so it
> look
David,
With kindest respect, I think that what you are asking is really a
question about HTML formatting style and has very little to do with MySQL
or its TEXT data type. Please try to keep your posts relevant to MySQL. If
you really do have a question that relates to MySQL, please rephrase yo
I recently started experimenting with the text field.
It generally works OK, but I have a question about
pasting in the text.
It seems a little awkward in phpMyAdmin, and I
generally wind up with everything mushed together like
this:
Vermont
is nicknamed the “Green Mountain
State.”It is a beautif
* Segis-Eresmas
> I have a table with a Text field (with texts) and Fulltext index. When
> I search a word (...) f.e. 'with match...against...', How can i do it to
> see the line and the line number of the text in that text-field?
There is no such functionality in mysql, you would have to impleme
Hi:
I have a table with a Text field (with texts) and Fulltext index. When
I search a word (...) f.e. 'with match...against...', How can i do it to
see the line and the line number of the text in that text-field?
Think's
Segismundo
--
MySQL General Mailing List
For list archives: http://list
On Thursday, August 28, 2003, at 07:09 AM, Sreesekhar Palaparthy wrote:
I wud like to rephrase my problemactually i want some method
to insert large text/binary text values into BLOB fields in chunks ,
instead of inserting the values at once in entireity. So for that , i
want to know h
arthy
[mailto:[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 9:28 AM
To: [EMAIL PROTECTED]
Subject: Text fields
Hi,
How do we insert arbitary sized texts into MYSQL Text
fields?? Is there any way to split the text into chunks and
then
append those chunks to the
: [EMAIL PROTECTED]
Subject: Text fields
Hi,
How do we insert arbitary sized texts into MYSQL Text
fields?? Is there any way to split the text into chunks and then
append those chunks to the field???
___
Art meets Army ; Swapna Weds Capt. Rajsekhar
Hi,
How do we insert arbitary sized texts into MYSQL Text
fields?? Is there any way to split the text into chunks and then
append those chunks to the field???
___
Art meets Army ; Swapna Weds Capt. Rajsekhar.
Rediff Matchmaker strikes another
Hi all,
I'm in the process of designing a database and I'm a bit of an
optimization freak ... I'd like to make sure that the actual structure
of the database is optimal.
With that said, my question is about TEXT fields. In the actual CREATE
TABLE statement, would it
On Thursday 27 February 2003 13:45, Hugo Wetterberg wrote:
> Does anyone know how to use text fields (BLOB) in the full text search?
You can create a fulltext index only on the VARCHAR and TEXT columns, but not
on the BLOB.
How to use fulltext index with TEXT columns look at:
h
- Original Message -
From: "Hugo Wetterberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 1:45 PM
Subject: Text fields & Full text search
> Does anyone know how to use text fields (BLOB) in the full text search?
>
Does anyone know how to use text fields (BLOB) in the full text search?
Hugo
PS.
sql,query,queries,smallint
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
t;[EMAIL PROTECTED]>
To: "Ivo Dvorak" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 11:34 AM
Subject: RE: Export of text fields from Access2000
If you create the tables beforehand in MySQL and then export the data into
the already created table,
we're not going to do anything about it." See
Troubleshooting in Microsoft KB article Q321686.
Greg
-Original Message-
From: Ivo Dvorak [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 6:18 AM
To: [EMAIL PROTECTED]
Subject: Export of text fields from Access2000
Hell
Hello,
I export a table from Access 2000 on WinXP to MySQL using the MyODBC 3.51.04 and text
fields are exported as text fields from Access instaed of varchar as it should
logically be (MEMO is the Access equivalent for Mysql text type).
I have Jet SP6 and latest MDAC installed. Is there a
hello,
this is presumably such a dull newbie question but i
did consult several manuals and couldn't find it:
When trying to import xml data into MySQL via a perl
script, i encounter the problem that the data is
written into the value fields when VARCHAR is choosen,
but not when TEXT is chosen:
Hi.
For example one have a table with some fields including text(blob).
Is it faster at all with SELECTs that doesn't use this(those) text
fields if they are moved into another table and linked using
primary key or it does not signify?
Best regards E
On Mon, May 20, 2002 at 04:33:41PM +0200, andy wrote:
> Thank you Egor for you reply.
>
> I did read about indexing text column on the mysql site. So I tryed
> to index my column like described. After 1 hour, I had to reboot my
> machine because there was no other way.
No other way?
You could h
CTED]>
Sent: Monday, May 20, 2002 3:59 PM
Subject: Re: indexing text fields possible?
> andy,
> Sunday, May 19, 2002, 7:06:00 PM, you wrote:
>
> a> I am wondering if it would be anyhow possible to make a search on a
mysql
> a> textfield faster. Right now the table contains 2
andy,
Sunday, May 19, 2002, 7:06:00 PM, you wrote:
a> I am wondering if it would be anyhow possible to make a search on a mysql
a> textfield faster. Right now the table contains 294000 entries and takes
a> about 40 MB of space. Is there a way to apply a index with a resonable
a> amount of disk sp
Hi there,
I am wondering if it would be anyhow possible to make a search on a mysql
textfield faster. Right now the table contains 294000 entries and takes
about 40 MB of space. Is there a way to apply a index with a resonable
amount of disk space? I am also not so sure if I should use text or
sm
Hello,
I am transfering from Access to MySQL.
I use it for a bibliograhical database.
In bibliograhical data the \ signs stands for semantische opposition.
My problem is that a query like
select * from term where term=$term$
works with Access but fails in MySQL when a \ character is in th
PROTECTED]; johnlucas-Arluna; [EMAIL PROTECTED]
Subject: RE: Semi colons in text fields in update statement
At 2:00 PM -0400 9/20/01, Will French wrote:
>There probably is a better way but the following should work:
>
>"UPDATE tblCompany SET CoName=CONCAT('"', CHAR(59)
> "Update tblCompany SET CoName='"tester"' WHERE CoID=109"
It's not the query string. I just submitted this query using urSQL
(uses ODBC) and it worked just fine (assuming CoName is a varchar(32)).
I'm also able to successfully run this query and similar queries via ADO
from a Delphi applicat
perly account for its being embeded in a literal string.
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 2:15 PM
> To: [EMAIL PROTECTED]; johnlucas-Arluna; [EMAIL PROTECTED]
> Subject: RE: Semi colons in text fields in update s
>
> There is no need for such an escape sequence because semicolons
> in strings are not special. Maybe it's an ADO bug.
>
Paul et al - I think his problem is with quotes, not semicolons. The line
"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109" is what
leads me to believe this.
Tr
not special. Maybe it's an ADO bug.
>
>> -Original Message-
>> From: johnlucas-Arluna [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, September 20, 2001 1:45 PM
>> To: [EMAIL PROTECTED]
>> Subject: Semi colons in text fields in update statement
I'll be damned if I can find it documented. Until someone else
enlightens us both, hopefully the above solution will see you through.
> -Original Message-
> From: johnlucas-Arluna [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 1:45 PM
> To: [EMAIL P
At 6:44 PM +0100 9/20/01, johnlucas-Arluna wrote:
>Hello
>
>I'm trying to do the following:
>
>"Update tblCompany SET CoName='"tester"' WHERE CoID=109"
>
>But getting an error message
>
>I tried the escape character "\" like
>
>"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109"
>
>but ge
Hello
I'm trying to do the following:
"Update tblCompany SET CoName='"tester"' WHERE CoID=109"
But getting an error message
I tried the escape character "\" like
"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109"
but get the same error
This happens whether I use ADODB in VB or if
Carsten Gehling writes:
> I'm back now, and have tested the 3.23.40. It works like a charm :-) Nice
> work!
>
> Now I only wait for the Win32 binary to be released. I didn't think there
> were any delays between the releasins anymore?
>
> - Carsten
>
Thanks for the compliments.
Win32 binaries
t;[EMAIL PROTECTED]>
To: "Carsten Gehling" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 1:49 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
> Hi!
>
> 3.23 (but 4.0 hasn't that bug either).
>
&
]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 10:31
Subject: Cannot create text fields
> Using the following Syntax I tried to create a table in mySQL. However
each
> time it returned a mySQL error which I eventually worked out it was
because
>
> I need to build a search utility which can query records based
> on multiple text parameter,
> my table will have about 10 fields and users can search on
> 3-5 parameters in one query. is there any way to achieve this
> other than doing a full table scan.
http://www.mysql.com/doc/F/u/Fullt
Hello
I need to build a search utility which can query records based
on multiple text parameter,
my table will have about 10 fields and users can search on
3-5 parameters in one query. is there any way to achieve this
other than doing a full table scan.
thanks
raghu
---
At 1:31 PM +1000 7/24/01, Geoff Martin wrote:
>Using the following Syntax I tried to create a table in mySQL. However each
>time it returned a mySQL error which I eventually worked out it was because
>I'd defined a field as text. I am able to define fields as varchar, char,
>int or float (I've tes
Using the following Syntax I tried to create a table in mySQL. However each
time it returned a mySQL error which I eventually worked out it was because
I'd defined a field as text. I am able to define fields as varchar, char,
int or float (I've tested for theses so far) but not text or blob.
The
D]>; "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 2:55 PM
Subject: RE: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
> Hi
> Where can we get V4.0?
>
> Thanks Simon
>
> -Original M
6 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
> I'm going to Spain today and cannot respond to any questions in the next
> week. I was going to wait with this until I got home again, but what the
> heck ;-)
>
> Run the following script th
Hi!
3.23 (but 4.0 hasn't that bug either).
Will be 2.23.40 soon.
And have nice trip, btw.
On Jul 20, Carsten Gehling wrote:
> Which dev. tree is that? 3.23 or 4.0?
>
> - Carsten (who hasn't left yet ;-)
>
> - Original Message -
> From: "Sergei Golubchik" <[EMAIL PROTECTED]>
> Subject
PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
> Hi!
>
> Ok, confirmed (finally :-) )
>
> My fault was that I was using our latest developmnet tree.
> When I've tried this on 3.23.39 as went public, the bug appeared.
>
> So, loo
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
> I'm going to Spain today and cannot respond to any questions in the next
> week. I was going to wait with this until I got home again, but what the
> heck ;-)
>
> Run the following script th
TED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 12:06 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
> I'm going to Spain today and cannot respond to any questions in the next
> week. I was going to wait with this until I got hom
Hi!
Ok, confirmed (finally :-) )
My fault was that I was using our latest developmnet tree.
When I've tried this on 3.23.39 as went public, the bug appeared.
So, looks like the bug was fixed even before it was found :-)
Probably, it is somehow related to over bug I've fixed
since 3.23.39 relea
Thanks for your bug report.
I am sure Sergei will have the answer before you come back from Spain ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/
I'm going to Spain today and cannot respond to any questions in the next
week. I was going to wait with this until I got home again, but what the
heck ;-)
Run the following script through your MySQL on an empty database with
mysql -uusername -ppassword dbname http://www.mysql.com/manual.php (t
Hi!
>> On Jul 19, Carsten Gehling wrote:
> > Finally I was able to produce a complete step-by-step to
> corrupt the index
> > ;-)
> >
> > mysql> insert into visitkort (kategori_id) values (108);
> > mysql> select last_insert_id();
> > mysql> update visitkort set navn = 'test5' where id = 1;
> > m
Hi!
On Jul 19, Carsten Gehling wrote:
> Finally I was able to produce a complete step-by-step to corrupt the index
> ;-)
>
> mysql> insert into visitkort (kategori_id) values (108);
> mysql> select last_insert_id();
> mysql> update visitkort set navn = 'test5' where id = 1;
> mysql> update visit
f the NULL
value in RDBMS' - I regard it as a necessary evil to be used sparsely. So it
would be great if I did not have to convert my text fields (text & varchar)
into accepting NULL.
- Carsten
- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
s still there. So it is definitely a problem
within the FULLTEXT index.
- Carsten
- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Carsten Gehling" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 6:26 PM
Subject
Hi!
On Jul 16, Carsten Gehling wrote:
> Description:
> A specific table (see "How-To-Repeat) with a FULLTEXT index causes errors in
> the MYI file when inserting new rows.
>
> 1) Create the following table:
> CREATE TABLE `visitkort` (
[skip]
> ) TYPE=MyISAM;
>
> 2) Insert a row with the follow
hk --safe-recover -force visitkort
- recovering (with sort) MyISAM-table 'visitkort.MYI'
Data records: 339
- Fixing index 1
Found block with too small length at 22812; Skipped
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
Fix:
The error does not occur, if you drop
From: ryc <[EMAIL PROTECTED]>
> I am aware that currently innobase tables can not have abritararly large
> text/varchar fields and support for this will be released sometime in the
> month of June. The application I am working with requires text fields
> (usually less than 64k)
Ryan,
I hope it pays to wait. If you compile MySQL/InnoDB yourself, you will
get unlimited BLOB and TEXT fields within 16 days. I am writing the
support for them now and I will release the source code at my website.
It will also be in the next binary release of MySQL/InnoDB, unless
Monty
fault.
Hello PostgreSQL...
Good luck
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of ryc
> Sent: Wednesday, June 13, 2001 8:48 PM
> To: MySQL
> Subject: innodb text fields
>
>
> I am aware that currently innobase ta
I am aware that currently innobase tables can not have abritararly large
text/varchar fields and support for this will be released sometime in the
month of June. The application I am working with requires text fields
(usually less than 64k), and I desperatly need row level locking. Either I
Hi all,
I'm new to this list, and would like to post a question.
I have a database with one table with a TEXT field where we save HTML files.
This table is Updated and Selected from a Servlet Applicacion, using JDBC.
Some TEXTs have a size of arround 60Kb. For records with this size (or
arround
> database,sql,query
> Hi All,
>
> Is there a nice way to take a search string eg
> "America spying China" and search a text or
> blob field for occurances of all of the words
> in the text in any order (ie not just a literal
> string match, but the equivalent of
> AND X LIKE "%America%" AND X
Use TEXT type to store texts larger than 255 symbols.
- Original Message -
From: Thomas Kaester(global) <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 11:10 AM
Subject: Problems with text fields
> Hello everybody,
>
> ich have a f
what's you table definition, what;s your query
- Original Message -
From: "Thomas Kaester(global)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 11:10 AM
Subject: Problems with text fields
> Hello everybody,
>
> ich hav
Hello everybody,
ich have a few problems with text fields. I want to get the text data of
a mysql text field. The saved texts are longer than 256 characters. But
if I use a select statement mysql returns only 256 characters!
Do anybody know why and what I have to do?
Greetings Tom
>Description:
When creating an index with multiple text fields, `where' clause
isn't handled correctly. If no index is present, "a = 'foo' and
b = 'bar'" does work well. However, if an index is present,
"a = 'foo
Dear list,
I'm new to MySQL and all of it's trappings.
Currently we're running PHP 3.x in conjunction with MySQL 3.22.22 and I need
to get better results from my text searches.
If anyone can help, thanks in advance.
Currently I'm "searching" a field in my DB using this type of query:
$searchQ
91 matches
Mail list logo
