Hi there,
Just run a query that has a column that has a result of more then 1024
characters( quite a lot more actually) when I display full text in
phpMyAdmin, it only seems to show up to 1024 characters.
I was really hoping this was not the case. does anyone know how I can get
round this.
Sorry for probably not the best presented question, but under pressure to
get some reports ready for tomorrow morning.
Kind regards
David.
4  5963  Just run a query that has a column that has a result of more then 1024
characters( quite a lot more actually) when I display full text in
phpMyAdmin, it only seems to show up to 1024 characters.
I was really hoping this was not the case. does anyone know how I can get
round this.
Sorry for probably not the best presented question, but under pressure to
get some reports ready for tomorrow morning.
further to my last limit, it may actually be a MySQL limit as when I changed
the query into my own php script within a HTML page it seemed to have the
same limit. I did not get anything returned over 1024 characters. How comes
this is happening and what can I do about it?
Kind regards
David.
"David Smithz" <da******@bluey onder.co.uk> wrote in message
news:GG******** ********@text.n ews.blueyonder. co.uk... further to my last limit, it may actually be a MySQL limit as when I
changed the query into my own php script within a HTML page it seemed to
have the same limit. I did not get anything returned over 1024 characters.
How comes this is happening and what can I do about it?
How do you know the result has more than 1024 characters?
What's the data type of the column(s) involved?
What's the query?
What version of MySQL are you using?
Here's the page that describes limits on string-related types: http://dev.mysql.com/doc/refman/5.0/...-overview.html
Regards,
Bill K.
"Bill Karwin" How do you know the result has more than 1024 characters?
What's the data type of the column(s) involved?
What's the query?
What version of MySQL are you using?
The query is
SELECT count(dob) as DOBcount, dob,
group_concat(co ncat(firstname, ' ', lastname))
FROM accounts
GROUP BY dob
HAVING DOBcount > 1;
Which I got recently from this newsgroup. The problem is that one of the
result there are many people born on a particular day (over 1000 in fact) so
when it lists the names of 1000 people, it cuts it short at 1024 characters.
So the column type is group_concat so I assume text.
Version of MySQL is 4.1 as my host kindly upgraded so that I could use the
Group_concat command.
I'll check out the link you posted also but right now having to manually get
a list of customers on specific dates.
Thanks
David Smithz wrote: "Bill Karwin" How do you know the result has more than 1024 characters?
What's the data type of the column(s) involved?
What's the query?
What version of MySQL are you using?
The query is
SELECT count(dob) as DOBcount, dob,
group_concat(co ncat(firstname, ' ', lastname))
FROM accounts
GROUP BY dob
HAVING DOBcount > 1;
Which I got recently from this newsgroup. The problem is that one of the
result there are many people born on a particular day (over 1000 in fact) so
when it lists the names of 1000 people, it cuts it short at 1024 characters.
So the column type is group_concat so I assume text.
Version of MySQL is 4.1 as my host kindly upgraded so that I could use the
Group_concat command.
I'll check out the link you posted also but right now having to manually get
a list of customers on specific dates.
Thanks
see: http://dev.mysql.com/doc/refman/4.1/...variables.html
System Variables (ie. set group_concat_ma x_len 65535 GLOBAL;)
group_concat_ma x_len numeric GLOBAL | SESSION This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Darren Gates |
last post by:
hi PHP users,
Here's a Flash 7 version of phpMyAdmin:
http://www.tufat.com/phpflashmyadmin.php
Special features include: drag-and-drop interface for InnoDB table
relationships, quick record editing, tree-menu display for databases
and tables, support for multiple hosts, and much more...
|
by: ghasem |
last post by:
Dear all,
Hello to all the great minds of php. My humble question is regarding
the phpmyadmin. As you know the welcome screen of phpmyadmin allows
one to choose the language.
My question is this: if the data was entered into a database of mySQL
in UNICODE, like "محمدان" and so
fort, then how can we display this in a readable format when for
example trying to Insert a new record from the phpmyadmin Insert
option for the particular table?...
|
by: Ed |
last post by:
------=_NextPart_000_001D_01C34FCC.1D2B5E50
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
There seems to be a significant penalty imposed by the optimizer when =
these
3 clauses are uses together. If we use the Full Text Search the penalty =
is
gone. However, the Full Text Search is not a very good option in my =
|
by: lithne |
last post by:
Hi,
when I try to open phpMyAdmin administration page I got this error:
'Cannot load mysql extension, please check your PHP configuration'
I cannot sort out what's the source of the problem, cause:
1. In the php.ini file I commented out the line
'extension=php_mysql.dll' and properly set the path to extension
directory: extension_dir = "c:\php\ext\"
2. MySQL is running
|
by: news |
last post by:
We just upgraded our phpMyAdmin GUI to the latest stable version, and
now the SQL queries are doing odd additions.
First, without changing the database it's connecting to at all, there's
a new column "collation" for all the tables, and the value in all of
them is: "latin1_swedish_ci".
I'm doubting that's what it should be.
And any SQL querey formulates like:
| | |
by: stbrenner |
last post by:
Hi,
I'm trying to insert 5112 lines of data into a table named INVENTORY
via phpmyadmin. All the data types are CHAR and have a limit of 50
(there are 8 columns). I tried inserting the data by commands;
basically copying and pasting
INSERT INTO INVENTORY VALUES
('AHS','312','cpu','dell','3248','HN97P01','','');
|
by: NewbieSupreme |
last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x,
which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a
table to a text file, tab-delimited, text qualifyer of "none" (this is how I
read to do it from newsgroups).
When I use the Query window in phpmyadmin to import the text file, it waits
a while, then returns an error:
#1064 - You have an error in your SQL syntax; check the manual that...
|
by: Marcus |
last post by:
Hello,
I am having a problem with a query in phpMyAdmin... it works fine on my
localhost, but the exact same query produces an error in phpMyAdmin on
my server:
localhost: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.8.1
server: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.6.3-pl1
SELECT AES_DECRYPT(pass, 'asdf') FROM `test`
|
by: northernrave |
last post by:
Hi, I am new to PHP and I can only understand small bits and pieces.
I have ordered a dedicated server running on a linux operating system and I have just installed PHPmyadmin. When I tried to import a backed up MySQL database my backup was too big to import (it is just under 4 megs big).
I have been on the wiki site for PHPmyadmin and it says I could change the max upload size on the import page by adding the following line into the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
