AW: Unicode

Hi, Ok, thx for your help, it's a little bit faster, but also much too slow. And what can I do that I can find such characters like 'ä' with a select like: SELECT * FROM myTable WHERE myField like '%a%' in the unicode-field? br Charlie > -Ursprünglich

Unicode

Longtext Die Tabelle beinhaltet ca. 60.000 Datensätze. Ist da MSSQL, oder eine andere DB etwa besser geeignet? Sehr wichtig ist für mich die Performance! thx+lg Charlie

Character Set convert?

Hey all, got a simple question: Is there a quick way to convert all the data in my database to a specific character set? I want to convert all the text to UTF-8. -Charlie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

AW: AW: find in list

ts is very fast without normalisation and with normalisation it was very slow. br Charlie > -Ursprüngliche Nachricht- > Von: Michael Stassen [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 17. August 2006 05:00 > An: mysql@lists.mysql.com > Cc: Mike van Hoof; Charlie Scha

find in list

like: 1,2,3,4,5,6,9,21 br Charlie

mysqld won't start

From: root To: mysql@lists.mysql.com Subject: mysqld won't start >Description: In an attempt to upgrade to MySQL 5.0.24 it was necessary to use "rpm -e ..." to remove version 5.0.22 then "rpm -U ..." to install the shared,server and client modules. When I do a "rpm -qa" it shows t

Mysql_config giving wrong location of libraries for AMD64

-lm -lz I used the RPM install of 4.1.8 MySQL of Server, Devel, Shared, and Client. Anyone have any ideas? -Charlie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Noob Question: Error 1046

Ah apparently this silly book skipped that step. So when I do databases I get "mysql" and "nuke". And figuring out how to make a new one wasnt very hard heh. Thanks, plenty more noob questions to come im sure :) - Original Message - From: "Parker Morse" &l

Noob Question: Error 1046

Evenin', Sorry to send noob questions, I know how annoying they can be, but we need help too ;) Anyways, Im using a self teach book to teach myself PHP, MySQL and Apache. The book is getting into MySQL and basic commands. Anyways, they gave an example, and I typed it in as shown in the book,

Re: Just a small newbie question

Ok well I reinstalled again and it seems to be working ok now. Thanks anyways ;) --- "Matt W" <[EMAIL PROTECTED]> wrote: Hi Charlie, Don't worry, all questions are OK. :-) Instead of trying to double-click mysql.exe, open your Command Prompt and, assuming the mysql\bin di

Just a small newbie question

G'Evening, Im extremely new to MySQL. Im sitting here using a self teach book to try to guide my way through it. Anyways, the book is discussing adding users and setting priveledges. Now the book is vague on how to do so, but I believe I use the bin/mysql.exe file (Im on windows obviously).

RE: mysql connection refused or lost (Update)

> "lost connection ..." > [mysqld] > set-variable=thread_stack=256k > Thanks! Life is good again :) Best Wishes, Charlie - Before posting, please check: http://www.mysql.com/manual.php (the man

RE: mysql connection refused or lost (Update)

-h IPAddress test ERROR 2013: Lost connection to MySQL server during query When I try to connect to this box from another box which I have granted all rights, I get the error: ERROR 2013: Lost connection to MySQL server during query Any help will be greatly appreciated. Charlie -

mysql connection refused or lost

emote box. I am not sure if the software firewall here is causing some problems or if it is something I am missing with MySQL. Best Wishes, Charlie - Before posting, please check: http://www.mysql.com/manual.php

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Charlie & >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

Errors

Hi Support Team, I'm quite a novice in installing Mysql. I needed to do this because of a task i had to accomplish by installing webtts for which mysql was a pre-requisite. during the installation process of webtts, i had the following errors "install_driver(mysql) failed: Can't load '/usr/local/l

Re: Impossible SQL ???

10 24 99 32 99 41 98 54 88 62 97 If the parameter for the second column is 4, I would need to retrieve records 2, 3, and 4. If the query needs, for simplicity, to return record 5, that could be handled by the program. Thanks for your thoughts!! Ch

Impossible SQL ???

I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not uniqu

SQL stmt help request

required would be the first succeeding record where the value of Field2 is equal to the value of Field2 in the 'starting' record. Field2 is NOT unique, and is not in any particular order. The result would be ordered by Field0 (the autonumber field) Is this possible? TIA, Charlie M

vb.net & aggregate MySQL functions

ecuted directly from mysqlfront. It is only when attempting to read them from vb using oledb datareader() that present a problem. Any queries not using functions work fine. dataReader claims no fields have been returned. I'm using MyOLEDB version 3

Penalty for non-null defaults ?

Is there any storage / performance penalty for specifying '' or 0 as default values, as opposed to allowing null's in the table structure? sql, query Thanks, Charlie - Before posting, please check: http:

RE: No Warnings after changed data

Hello, I think that my problem boils down to the unimplemented getWarnings() method in the mm. JDBC driver. If it was implemented, I could detect if the data was e.g. truncated. Can anybody help me find an implementation for this method? Thank you again, Charlie Hi. :I'd like to fin

No Warnings after changed data

Hi All, I'd like to find out how I could convince mysql to generate warnings whenever the data I want to insert is modified by the server. E.G. CREATE TABLE test (value real); INSERT INTO test VALUES ('a1'); I am programming in JAVA using JDBC. Thanks for any a

Comparing UNSIGNED and INDEXED columns with negative numbers

ng to do with casting (-1) to an unsigned value. Is (id > -1) a valid and supported comparison on that column after all??? Thanks for any answers! Charlie _ Join the world’s largest e-mail service with MSN Hotmail. http:/

SLOW MULTI COLUMN INDEXES, ESPECIALLY FOR MERGE TABLES

), (but wierd). Could anyone recommend a better solution in this case? Thanks for any comments! Charlie _ Get your FREE download of MSN Explorer at http://exp

GRANT TEMPORARY CREATE ...

such privilege system currently supported by MySQL. Could anyone confirm that or suggest a solution? Thanks for any response! Charlie _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

MAX_ROWS limits

still gives the original number for MAX_ROWS! Could someone help me to understand, if MAX_ROWS is limited to the maximum value of the integer, or do I need to change some other settings in order to go beyond this number? Thanks for any ideas! Charlie

MAX_ROWS limits

still gives the original number for MAX_ROWS! Could someone help me to understand, if MAX_ROWS is limited to the maximum value of the integer, or do I need to change some other settings in order to go beyond this number? Thanks for any ideas! Charlie

To many processes, 100% CPU usage...HELP

up the old box because it's in transit via UPS back from my Co-location facility.1 TIA, Charlie Here's a sample from top PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 20395 mysql 17 0 58104 56M 1696 R48.2 2.8 0:04 mysqld 20477 mysql 15 0 5

Re: Enum

esult when using If Y >then...(ASP). Do I use ENUM right? I have tried SET also, but with no better result. >Anyone? > Use type `bool'. This is an alias for tinyint(1), with values 0 or 1. Charlie - Before pos

Re: Fulltext search

Lorang Jacques wrote: >Hello, >This is the last time I will post this thread. Apparently nobody knows any >solution to this : > >The Fulltext search only matches those rows who match >teh exact word, so if I search for "bank", the query wont find banking. >(this would work with "like '%bank%'", b

problem stopping mysqld

Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but then i can't stop the server...i tried ./mysqladmin shutdown, ./mysqladmin -u root shutdown, but it doesn't work..any one can help??? mysql 3.23.37 Thank you, EISSEN Chalrie ---

C Libraries: Commands out of sync...help

du/~schmidt/ACE.html, very cool) to deal with platform specifics, threading, mutexes and other stuff...) Namespace collisions with ACE is why I'm not using the C++ libraries. I expect to make at least one query to the database every few minutes, so timeouts aren't really an issue. T

mysql & os x server

dow named 'Dead Terminal': my_print_defaults: not found Didn't find ./bin/mysqld You should do a 'make install' before executing this script [Process exited - exit code 1] can someone help me? thank you, charlie EISSEN

linking ms access to mysql db

question: Can i link to a mysql database using ms access 97 or ms access 2000 using an odbc driver. i recall doing it before, but can't seem to get it work again. i would appreciate any help you could give me on this subject. thanks charlie