Re: searching for words with special chars
2006-05-10
Thread
Adam i Agnieszka Gąsiorowski FNORD aka ALinkA ak a symbol '( { .A. } )'' ||~ { A.A }
On 2006-04-01, at 13:17, Octavian Rasnita wrote: Hi, Is it possible to create a query that searches for records which contains words with special chars and with their english correspondents? For example, if a user searches for mata, I want to return all the records that contain the
Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)
2006-05-02
Thread
Adam i Agnieszka Gąsiorowski FNORD aka ALinkA ak a symbol '( { .A. } )'' ||~ { A.A }
On 2006-04-26, at 20:53, Nicolas Verhaeghe wrote: Also, in order to do the Zip+4 translation, you need a good CASS certification script. Most of these products are expensive. You could program your own, but from talking to a programmer who created such a product, it takes years to come with a
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
2006-05-02
Thread
Adam i Agnieszka Gąsiorowski FNORD aka ALinkA ak a symbol '( { .A. } )'' ||~ { A.A }
On 2006-05-02, at 08:51, The Nice Spider wrote: Wow, impressive pseudonym...Are you strong enough to be my man? ;-} DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null ...AND the_reader IS a_fool. Hell and damnation! SQL POETRY! :-} This task is
Re: differences between varchar and text fields
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
Re: Easy regex replace?
On 2006-03-20, at 12:11, Pooly wrote: 2006/3/19, Adam i Agnieszka Gąsiorowski FNORD [EMAIL PROTECTED]: On 2006-03-18, at 00:59, Yani Copas wrote: Is there a quick and dirty way to update such that I can only affect the portion of a string (varchar column) that matches a regexp? (e.g
Re: Problems with UTF and MySQL
On 2006-03-20, at 16:12, Gabriel PREDA wrote: One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to talk the same language !!!
Re: Easy regex replace?
On 2006-03-18, at 00:59, Yani Copas wrote: Is there a quick and dirty way to update such that I can only affect the portion of a string (varchar column) that matches a regexp? (e.g. replace all '%20' with ' ' leaving the rest untouched?) You know that proverb - For a man in possession
