Im trying to run a full text query on a two letter keyword 'K7'. I have
set ft_min_word_len=2 and restarted the server and if I view the system
vars in Mysql Workbench it shows it is set correctly.
I have then dropped and re-created the index on the descrip column. It
is an InnoDB
On Tue, 18 Nov 2014 13:09:25 +, Daniel Rios Couto wrote:
> You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large
> text...
> On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald
> wrote:
>
>
>> Am 18.11.2014 um 10:48 schrieb thufir:
>> > I'
You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large text...
On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald
wrote:
>
> Am 18.11.2014 um 10:48 schrieb thufir:
> > I'm trying to store a web page to table "pages" (whether or not that's a
> > g
Am 18.11.2014 um 10:48 schrieb thufir:
I'm trying to store a web page to table "pages" (whether or not that's a
good idea for a separate thread, please). What would be a suitable type
for the field which stores the actual page source?
text = 64 KB including all s
Field | Type | Null | Key | Default |
Extra |
+-+---+--+-+---
+-+
| id | int(11) | NO | PRI | NULL |
auto_increment |
| created | timestamp | NO | | CURRENT_TIMESTAMP | on update
en [mailto:shawn.l.gr...@oracle.com]
>> Sent: Tuesday, July 02, 2013 10:21 AM
>> To: mysql@lists.mysql.com
>> Subject: Re: Full text search and & sign as a part of the keyword
>>
>> Hello,
>>
>> (my response is not top-posted)
>> On 7/2/2013 12:50 PM, l
anged the name of
the test org to "Com&Me".
Searching for "Com", the test org is gonna be listed.
Though, "Com&" no results at
all.
?!?
�
>
>
>
> Hi to all,
>
>
>
> I have this full text search query
>
> SELECT name,
FULLTEXT (at least the MyISAM version) has 3 gotchas:
ft_min_word_len=4, stopwords, and the 50% rule
> -Original Message-
> From: shawn green [mailto:shawn.l.gr...@oracle.com]
> Sent: Tuesday, July 02, 2013 10:21 AM
> To: mysql@lists.mysql.com
> Subject: Re: Full text searc
Searching for "Com", the test org is gonna be listed.
>
> Though, "Com&" no results at
> all.
> ?!?
> �
>>
>
>>
>
>>
>
>> Hi to all,
>
>>
>
>>
>
>>
>
>> I have
the test org to "Com&Me".
Searching for "Com", the test org is gonna be listed.
Though, "Com&" no results at
all.
?!?
�
Hi to all,
I have this full text search query
SELECT name, org_id,
address_id
FROM organization
WHERE org_ac
Hi to all,
I have this full text search query
SELECT name, org_id,
address_id
FROM organization
WHERE org_active='Y' AND MATCH(name) AGAINST('AB&C*' IN BOOLEAN
MODE)
and I'm not getting any results. And there IS a org AB&C,
Inc.
My assumption i
ilto:h...@tbbs.net]
> Sent: Saturday, March 16, 2013 6:23 AM
> To: Reindl Harald
> Cc: mysql@lists.mysql.com
> Subject: Re: a little doubt on text about MySQL
>
> >>>> 2013/03/16 03:44 +0100, Reindl Harald >>>>
> what are you speaking about?
>
> yo
2013/03/16 03:44 +0100, Reindl Harald
what are you speaking about?
you can define it in my.cnf and YOU are responsible for
the configuration as you are also responsible the
develop php code with error_reporting = E_ALL
These SQL-modes that pertain to type-safety are really part
2013/03/15 12:43 -0300, Marcus Vinicius
Does anyone knows the author of this:
http://grimoire.ca/mysql/choose-something-else
Title: "Do Not Pass This Way Again"
Not I
--but, as to automatic type-conversion, I find me in agreement with the author.
When I first began to use MyS
Am 16.03.2013 01:51, schrieb h...@tbbs.net:
> He makes a point that had not come to me, that type-security somewhat depends
> on SQL_MODE, which belongs to the connection. It is, quite rightly, stored in
> saved program code, but not in any table. At least these affect table behavior
what are
Hello all,
Does anyone knows the author of this:
http://grimoire.ca/mysql/choose-something-else
Title: "Do Not Pass This Way Again"
Thanks a lot,
Marcus Vinicius.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
>>>> 2012/10/12 17:56 +0100, Neil Tompkins >>>>
Is there such a way in a MySQL query to extract the text "this is a test"
from the following strings as a example
http://www.domain.com/"; class="link">this is a
test
http://www.do
in a MySQL query to extract the text "this is a test"
> from the following strings as a example
>
> http://www.domain.com/"; class="link">this is a
> test
> http://www.domain.com/"; title="this is a test"
> class="link">link
>
> Thanks
> Neil
>
> From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
> Sent: Friday, October 12, 2012 9:56 AM
> To: [MySQL]
> Subject: Extract text from string
>
> Hi,
>
> Is there such a way in a MySQL query to extract the text "this is a
> test"
> from the following str
Hi,
Is there such a way in a MySQL query to extract the text "this is a test"
from the following strings as a example
http://www.domain.com/"; class="link">this is a
test
http://www.domain.com/"; title="this is a test"
class="link">link
Thanks
Neil
On Saturday, December 10, 2011 at 04:20:25 PM, Jon Forsyth wrote:
> Hello,
>
> I hope someone can help me solve this. I am trying to write 2 string
> values to separate fields of the same row in a mysql DB table using the
> Perl Module DBD::mysql. One string value is of English letters, while th
You may want to check "character_set_results" variable through
> SHOW VARIABLES LIKE 'character_set%';
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
ch
What happens if your Perl script generates (UTF8) SQL output instead of sending
the Perl Module it? Does it look right?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello Michaël,
Thank you for the tips. SHOW CREATE TABLE helped me figure out that my
table was using Latin1 and I was able to change it to utf-8. However, I
did not see any encoding specified on the column with this command.
I tried to fix the connection encoding with this line of Perl code:
Hello,
I hope someone can help me solve this. I am trying to write 2 string
values to separate fields of the same row in a mysql DB table using the
Perl Module DBD::mysql. One string value is of English letters, while the
other is of Arabic letters. However, they are somehow switched and writte
Dear all,
We have thousands of aes_encrypted data accidentally stored in a text field,
from which we're struggling to recover the data back. Simply convert the
text field to a blob field does not help. Various tricks have been tried,
but with no luck. Now I'm worried that when a blob s
On 04/26/11 05:32, Halász Sándor wrote:
2011/04/25 18:45 +, Larry McGhaw
CREATE VIEW `myview2` AS
SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
Well, for this construct
IF(b.`N
2011/04/25 18:45 +, Larry McGhaw
CREATE VIEW `myview2` AS
SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
Well, for this construct
IF(b.`Name` IS NULL, '', b.`Name`)
there is a spe
Hi,
On 04/25/11 20:45, Larry McGhaw wrote:
My best advice is to not use a custom MySQL function in a view when the
parameter to that function
is a column or expression that has the potential to result in NULL because of
being on the right side
of a left outer join (or the left side of a right
11 2:03 PM
To: Larry McGhaw
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
On 04/22/11 22:41, Larry McGhaw wrote:
> It does appear to be some type of bug to me.
Hm... do you have an idea how to wo
essage-
From: Daniel Kraft [mailto:d...@domob.eu]
Sent: Friday, April 22, 2011 1:05 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid V
On 22.04.2011 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
I agree. I was thrown by Daniels "first and third" comment, which I
guess should read "second and third"
I reproduced the behavior in 5.1.53-community on Windows.
/ Carsten
--
MySQL General Mailing List
F
mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent wrote:
>> DROP DATABASE `test`;
>> CREATE DATABASE `test`;
>> USE `test`;
>>
>> CREATE
In the last episode (Mar 31), Carlos Fernndez Iglesias said:
> I have this field in a table from my database that contains a lot of
> information and I would like to extract only a little bit of it. I have
> to parse it but need to do it directly in the sql query, do you know what
> kind of functi
Hello,
I have this field in a table from my database that contains a lot of
information and I would like to extract only a little bit of it.
I have to parse it but need to do it directly in the sql query, ¿do you
know what kind of function I have to use, or how?
This is an example of the fiel
-
From: "Uwe Brauer"
Sent: Wednesday, September 15, 2010 2:00 PM
To:
Subject: extract text from table to file, and recover damage.
Hello
I am still fighting with the crashed hard disk and its db.
I had a look at the tables
mysql -u wikiuser -p maqwiki
and
then
select * from searchind
if on unix/mac:
$ echo "select * from searchindex" | mysql -u wikiuser -p maqwiki
> myfile.txt
you can probably do something similar on windows..
On Wed, Sep 15, 2010 at 4:00 PM, Uwe Brauer wrote:
> Hello
>
> I am still fighting with the crashed hard disk and its db.
>
> I had a look at the
Hello
I am still fighting with the crashed hard disk and its db.
I had a look at the tables
mysql -u wikiuser -p maqwiki
and
then
select * from searchindex
(This is the only table which seems to have useful information.)
However the information is written so fast on the screen
that it is
> Â
> Hi All,
> Â
> Is there any way I can decode base64 encoded message from mysql. I tried
> using mysql decode function but it did not work for me.
> Â
> Can anyone provide any input on how I should go about it.
> Â
> Thanks and Regards,
> Manasi Save
> Â
base64?
--
bEsT rEgArDs
Hi All,
Is there any way I can decode base64 encoded message from mysql. I tried using
mysql decode function but it did not work for me.
Can anyone provide any input on how I should go about it.
Thanks and Regards,
Manasi Save
--
MySQL General Mailing List
For list archives: http://list
You can do some trickery with auto increment fields and multiple-column
indexes. Have a look at http://www.bitbybit.dk/carsten/blog/?p=131
Beware that this is apparently a MyISAM-specific trick.
/ Carsten
On Tue, 6 Apr 2010 16:02:48 +0530, "Suryanarayanan"
wrote:
> I am new to mysql a
I am new to mysql and am trying to develop a package in php using mysql as
backend database.
I have a table in mysql which has a customer code which is alpha numeric.
Eg: J0001 and name and address of the customer. The alphabet signifies the
first letter of the name of the customer viz. James.
>-Original Message-
>From: mos [mailto:mo...@fastmail.fm]
>Sent: Wednesday, March 03, 2010 5:14 PM
>To: mysql@lists.mysql.com
>Subject: Tip: Full Text Searches
>
>Something I didn't realize about full text searches, but they can be used
>with multi-table view
Something I didn't realize about full text searches, but they can be used
with multi-table views!
Maybe I'm the last one on the planet to discover this, but I think this is
really neat.
For example, I can create a view with all the fulltext index column of the
customer table (nam
Practical Full-Text Search in MySQL
http://forge.mysql.com/wiki/Practical_Full-Text_Search_in_MySQL
This Thursday (December 3rd, 16:00 UTC – note the different time), Bill
Karwin will talk about Practical Full-Text Search in MySQL. He'll
introduce and compare five different approaches of
Don
Thanks for your response. The issue I have is that the password for our
database is stored either in the ODBC registry or within our ASP page as
plain text. One option I have is to encrypt the password in the database
connnection string and have a function with a key in a external file that
e problem still remains,
>> the
>> password is stored in the ASP file in plain text. Does anyone have any
>> recommendations on how to overcome this issue ?
>>
>>
> Secure the access to the ASP-source file.
> You *could* encrypt it but then you have to store th
PM, Jay Ess wrote:
> Tompkins Neil wrote:
>
>> Following my previous email. I've now configured my database connection
>> using a ODBC DNSLESS SSL connection. However the problem still remains,
>> the
>> password is stored in the ASP file in plain text. Does an
Tompkins Neil wrote:
Following my previous email. I've now configured my database connection
using a ODBC DNSLESS SSL connection. However the problem still remains, the
password is stored in the ASP file in plain text. Does anyone have any
recommendations on how to overcome this
Following my previous email. I've now configured my database connection
using a ODBC DNSLESS SSL connection. However the problem still remains, the
password is stored in the ASP file in plain text. Does anyone have any
recommendations on how to overcome this issue ?
Cheers
Hi
The MySQL ODBC connection password is stored as plain text in the Windows
registry. What is the best way to overcome this issue - to ensure the
password is saved securely
Thanks,
Neil
Gavin Towey wrote:
> Hi Pol,
>
> MySQL support FULLTEXT indexes, and natural language searches, including
> Boolean conditions. This may help you; however, you will have to adjust
> the default behavior of the index, but changing server settings. By
> default there is a minimum word length wh
ysql@lists.mysql.com
Subject: text records and cross referencing
Hi
i am very new to mysql. I am playing around with it to test it as a
personal vocabulary and language expression manager.
Main field would be a passage from a text work, where each word is
searchable.
Any experience and reports about
Hi
i am very new to mysql. I am playing around with it to test it as a
personal vocabulary and language expression manager.
Main field would be a passage from a text work, where each word is
searchable.
Any experience and reports about such use?
A further questions is about the possibility to
>-Original Message-
>From: Moon's Father [mailto:yueliangdao0...@gmail.com]
>Sent: Friday, June 26, 2009 4:13 AM
>To: john.dais...@butterflysystems.co.uk
>Cc: Lin Chun; mysql@lists.mysql.com
>Subject: Re: How can we stock the query result into a text file
>
&
Have a look at "create table as select" and the csv engine.
On Thu, Jun 25, 2009 at 4:18 PM, Lin Chun wrote:
> Hi
>
> In mysql , how can we stock the query result into a text file
>
> the table is too large , i don't want to dump it , but select a part of it,
>
file '/path/and/filename.txt'
>
> Regards
>
> John
>
>
> > Hi
> >
> > In mysql , how can we stock the query result into a text file
> >
> > the table is too large , i don't want to dump it , but select a part of
> > it,
> > i wrote
SELECT INTO OUTFILE does almost the same thing as spool in SQL*Plus
SELECT columnname from tablename into outfile '/path/and/filename.txt'
Regards
John
> Hi
>
> In mysql , how can we stock the query result into a text file
>
> the table is too large , i don't
Hi
In mysql , how can we stock the query result into a text file
the table is too large , i don't want to dump it , but select a part of it,
i wrote a script perl to do this, but each time i have to change the
parameters in the script to get another table, when i google it, i find the
fun
Sorry, I don't understand your answer. Could you kindly explain in more details?
Thanks,
Jack
--- On Fri, 4/24/09, zhu dingze wrote:
From: zhu dingze
Subject: Re: Full Text Search Problem
To: mysupp...@asuma.com
Cc: mysql@lists.mysql.com
Date: Friday, April 24, 20
'Words' shows in more than 50% rows will be regards as a stop words.
2009/4/24
> Hi,
>
> I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
>
> 'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
> ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPA
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM article
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM article
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM article
thank you for your reply :)
I've roughly read some source codes about MYSQL_BIN_LOG & Log_Event.
It seems that the way which mysql writes binlog in is per Log_Event.
In that case, records are stored in sequence, just like plain text
logs does. So, even if I can write pure SQLs into a
t; mysqlbinlog can't process it correctly.
>
> Is there any usable plain text SQL log in mysql( I care about write
> operations only )? If not, where to start with if I want to add such a
> log?
The plain text logs have the same problem. The binlog is generally as
reliable as
hi,
I've been using mysql-5.1.22 in my project, which processes a lot of
read operations but little write operations. I got the idea from some
of my coworkers that binlog has a chance to be corrputed so that
mysqlbinlog can't process it correctly.
Is there any usable plain text
Hi,
When I use ft_min_word_len=3 under [mysqld] section, mysql fails to start.
ft_min_word_len=3 parameter has been added under [myisamchk] only , which
works.
mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline
5.1
Anyone know about this?
Hi all:
I read in mysql documentation that searches are case-insensitive by
default but this default behaviour can be changed using a latin1_bin
collation. But, is there any way to make searches sensitive or
unsensitive to accents, umlauts, etc.?
I suppose that queries are accent sensitive by def
Hi all:
I have been reading mysql 5.1 documentation and it says that default 50%
threshold for natural language searches can be changed in
storage/myisam/ftdefs.h but, what I have to change to allow indexing of
all words?
This percentage is not explicit in the file, so I don't know what I have
to
> MySQL has no idea how you are presenting the data (html, rtf, etc.),
> so it couldn't hilight the words for you. It should really be that
> tricky using grep and PHP.
>
> Brent
I have my data as pure text: no html, rtf or something else. That is, one
table with two columns:
into mail archives but I
didn't find a solution to the following question:
Is there any way to highligh results from a full-text search? I know
some tricky methods using PHP but I want to know if mysql (5.0 or 5.1
versions) offers some methos or function to do this.
I want to write the k
Hi all:
I was reading documentation and searching into mail archives but I
didn't find a solution to the following question:
Is there any way to highligh results from a full-text search? I know
some tricky methods using PHP but I want to know if mysql (5.0 or 5.1
versions) offers some meth
I've extracted text from approx 1600 pdf files using pdftotext.exe and
inserted it into a table.
Now I see there are form feed characters in the field, and I would suspect
other special characters, also.
I'm not having much luck trying to remove them.
Any pointers appreciated.
Thanks,
David
The 5.0 documentation that I have says that you can specify a length for a
TEXT column, and that this will affect the storage space used by the column
data. When I specify TEXT(n), however, n is ignored. It won't be shown in a
SHOW CREATE, nor in any other way.
Is this a feature that cam
The official table's data.
++---+-+
| id | title | body|
++---+-+
| 1 | MySQL Tutorial| DBMS stands for DataBase ...
Dear Users,
I am facing a problem related to full text search. I am trying to
search non latin characters with no success :(.
I am trying the following queries for searching and only the English one works.
SELECT * FROM bangla_test WHERE MATCH(bn_test) AGAINST('নাম নাই' in
boolean mo
Hi All,
is there a clever way to access the full-text index...
I want to know what the the words that has been indexed...
Many thanks :)
Regards,
HK
50% value or using default 50
%)
thanx and regards
--
View this message in context:
http://www.nabble.com/Full-Text-Search-tp14947073p14947073.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
'%..whatever..&'
UNION
SELECT "I'M A NEWS",ID_NEWS as ID_TO_RETURN
FROM News T1
WHERE TITLE like '%..whatever..&' OR CONTENT like '%..whatever..&'
Aloha!
Claudio Nanni
-Messaggio originale-
Da: nikos [mailto:[EMAIL PRO
That is a grate solution.
The problem is that I must have deferent links for each response.
That's the tricky thing!
Thank you
Sebastian Mendel wrote:
nikos schrieb:
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books author
On Jan 9, 2008 8:36 AM, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
> nikos schrieb:
> > Hello list
> > I have to make a full text search and I want to do it in many tables.
> > I have deferent tables for books authors and news.
> > Any ideas how to do it?
>
nikos schrieb:
> Hello list
> I have to make a full text search and I want to do it in many tables.
> I have deferent tables for books authors and news.
> Any ideas how to do it?
three separate queries or an UNION
--
Sebastian
--
MySQL General Mailing List
For list ar
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books authors and news.
Any ideas how to do it?
Thank you
Nikos
Urms schrieb:
> I'm using pretty standard approach to sorting search results by relevancy:
>
> SELECT DISTINCT product_name,
> MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS
> rate
> FROM _TT
> WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN
Urms wrote:
I'm using pretty standard approach to sorting search results by relevancy:
SELECT DISTINCT product_name,
MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS
rate
FROM _TT
WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN
MODE ) >0
OR
n the result but at the
same time it takes only about 0.006 sec without ORDER BY clause.
I understand that ORDER BY is time consuming but maybe someone knows a
different way to have sorting by relevancy.
Thanks in advance!
--
View this message in context:
http://www.nabble.com/Fast-relevance
#x27; matches though.... Is such a thing possible?
MySQL full-text searching is out as I'm using InnoDB tables.
Does anyone have any suggestions?
Thanks!
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
16:12
Pour : Éric Fournier/CSPQ <[EMAIL PROTECTED]>
cc :mysql@lists.mysql.com
Objet : Re: Possible cause of error when inserting into text field ??
> Hi ,
> Someone using typo3 try to update a field "tx_templavoila.flex" into a
table tt_content but get
> Hi ,
> Someone using typo3 try to update a field "tx_templavoila.flex" into a
table tt_content but get kicked out of typo3 without error message. The
user tried with PHPmyadmin but got the same result. First thought coming
to mind is the field is too small for the data being inserted but
Hi ,
Someone using typo3 try to update a field "tx_templavoila.flex" into a
table tt_content but get kicked out of typo3 without error message. The
user tried with PHPmyadmin but got the same result. First thought coming
to mind is the field is too small for the data being inserted but the
f
w.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 03, 2007 3:09 PM
> To: mysql@lists.mysql.com
> Subject: speical characters in text column
>
> hi friends,
>
> i s
hi friends,
i searched on google but not file a solution.
is there a way that i can store special characters (return, new line, tab,
etc) into mysql (ver. 4.1.12) table with text type?
i use textarea tag for user to enter the text.
my goal is to store/display EXACTLY what user entered in
Hi,
Thanks for the link
Is there standalone jar/zip Just for auto_ef
Also see Perl module Encode::Guess. There are others out there as well.
Regards,
Jeremy
--
high performance mysql consulting
www.provenscaling.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Solaris Express Developer
Edition [x86] is a wonderfully simple install.
~mm
>
> Thanks again
> Martin--
> - Original Message -
> From: "Michael Monaghan" <[EMAIL PROTECTED]>
> To: "Bharat" <[EMAIL PROTECTED]>
> Cc:
> Sent: Wednesd
> i have one problem with Arabic text. I have created database with
> charaterset utf8. when i insatal sql file all the content which is arabic
> that content stored as arabic. but when i retrieve
When you retrieve this content, how are you viewing it? - browser? terminal?
For the br
i have one problem with Arabic text. I have created database with charaterset
utf8. when i insatal sql file all the content which is arabic that content
stored as arabic. but when i retrieve this content it is display something like
ASCII value("ÙعاÙ"ÙSØ© ادارة اÙ"Ù^Ù,
mos schrieb:
I posted this message twice in the past 3 days, and it never gets on
the mailing list. Why?
Here it is again:
I have a Text field that contains paragraph text and for security
reasons I need to have it encrypted. If I do this, how can I still
implement full text search on it
If you are going to rely on obfuscation to protect valuable data, you might
want to consider not posting the particular method you will use on a public
mailing list.
I think any method you implement will lower the overall security of the system.
But, if you must search for encrypted text, you
I also need to protect a couple dozen Float fields and thought I could
obscure them a bit by adding an offset to them based on an encrypted id
stored with each row. It is not going to be as good as encryption but
will help to obfuscate the data.
How much will obfuscation save you? Are you sav
1 - 100 of 1303 matches
Mail list logo
