Re: Ingres vs MySQL

2003-08-28 Thread Joel Rees
?ID=1013 Note that's Computer Associates you would be dealing with on that one. Mixed in with the links to information about the artist, Jean Auguste Dominique Ingres, there were other links to potential sources of information. HTH -- Joel Rees, programmer, Systems Group Altech Corporation

Re: PHP or Perl?

2003-08-17 Thread Joel Rees
in at will, and ... -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP or Perl?

2003-08-17 Thread Joel Rees
are not carefully used, and I have never seen those problems when using PHP, but that is less about speed than about programming.) -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http

Re: How can I enable unicode and japanese support?

2003-08-07 Thread Joel Rees
? Have you looked at section 8 of the MySQL manual? http://www.mysql.com/doc/en/Charset.html -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Using a foreign character set in MYSQL

2003-08-06 Thread Joel Rees
is a solution for the CJK languages, but that's off-topic.) -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Using a foreign character set in MYSQL

2003-08-06 Thread Joel Rees
have to tell Java to convert between Unicode and BIG-5. HTH -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: How does one get off of this list

2003-07-31 Thread Joel Rees
in the recent month or so.) I assume what you've tried is the above link? You should receive a confirmation e-mail, and you need to reply to that. Did you receive the confirmation e-mail? -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp

Re: MySQL vs. PostgreSQL -- speed test

2003-07-14 Thread Joel Rees
, but bear it it mind. Actually, Unicode is much more difficult to handle than the small character encoding sets. Some slowdown is probably to be expected. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing

Re: Root@?

2003-07-08 Thread Joel Rees
Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a [EMAIL PROTECTED] Is this redundant, or is there a reason for this? Well, some people might say it's redundant, but it _is_ by design -- http://www.mysql.com/doc/en/Privileges.html ... -- Joel Rees

Re: License?

2003-07-02 Thread Joel Rees
are building your tools. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OS X downloads

2003-07-02 Thread Joel Rees
, package is the key here. One would be a traditional unix-ish install, the other would be set up to install as a package in the Mac OS X definition of a package. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General

Re: License?

2003-07-01 Thread Joel Rees
frictionless economy, tell them to take their manure generators elsewhere.) /rant -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Can't compile on NetBSD

2003-06-29 Thread Joel Rees
Can any one help me? Hard to tell without more information. Also, since the issues are likely to be system/CPU dependent, you may need to ask on a netBSD list, as well. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp PS

Re: .fil

2003-06-29 Thread Joel Rees
. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql.sock doesn't exist

2003-06-27 Thread Joel Rees
. Not surprising. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql.sock doesn't exist

2003-06-26 Thread Joel Rees
have a user for mysqld to run as? What group is mysqld running under? (Etc.) -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: 4.1 character set documentation

2003-06-16 Thread Joel Rees
At 15:05 +0900 6/12/03, Joel Rees wrote: Paul DuBois advised us that Alexander Barkov and Peter Gulutzan have written up some documentation on the new character set support in MySQL 4.1, which has now been added to the online manual. You can read it here: http://www.mysql.com/doc

Re: Set no root password

2003-06-15 Thread Joel Rees
with myphpadmin too. But now I know where it is I put the password in. And now I want to protect phpmyadmin so that only folks with a username/password can access it. -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: 4.1 character set documentation

2003-06-12 Thread Joel Rees
things have changed since 4.1.0. -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FULLTEXT Search and Charsets

2003-06-12 Thread Joel Rees
don't get all of the latin sets, though. -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unicode(ucs2) setup question

2003-06-11 Thread Joel Rees
I'd like to use ucs2 character set for MySQL. You do understand that Unicode support is not yet complete in MySQL, including the current alpha? Also, I would expect UTF-8 to be in better condition that UTF-16. -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives

Re: mysql query output get wrapped

2003-06-04 Thread Joel Rees
as vertically. -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cannot find uppercase user from mysql.user table

2003-06-03 Thread Joel Rees
is all lowercase then, the recordset is returned with the appropriate values. Sorry to give you a hit-and-run answer, but I think I read something in the on-line manual about case problems with file names on some OSses. Might have something to do with it. -- Joel Rees [EMAIL PROTECTED] -- MySQL

Re: Oracle to MySQL or ?

2003-05-30 Thread Joel Rees
://www.google.com/search?hl=enie=ISO-8859-1q=oracle+intermedia http://www.oracle.com/ip/deploy/database/oracle9i/index.html?cm_imedia.html Okay, it looks like a set of tools for managing multimedia databases. Could you explain how you use intermedia? ... -- Joel Rees [EMAIL PROTECTED

Re: How to secure a MySQL database from people with physical access

2003-05-27 Thread Joel Rees
, ...) -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mac OS X package problems

2003-04-02 Thread Joel Rees
Haven$B!G(Bt been following your thread, but I thought I'd make a stupid (Bsuggestion ... (B (B At startup, the computer says something about starting a MySQL server. (B Could it be that the startup item is still trying to start mysqld even (B though it no longer exists and in the process

Re: [newbie] localhost login problems from MSW2k command line (solved)

2003-03-27 Thread Joel Rees
it might be a little awkward. -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Creating fulltext index never completes...?

2003-03-25 Thread Joel Rees
... It dawned on me that perhaps the problem had to do with double-byte characters, What language is this text in? Is it by chance a language that does not use whitespace to delimit words? -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

Re: Spanish

2003-03-25 Thread Joel Rees
I need , obtain the month in spanish, $B%=(Bhow can do it...? (B (B NOTE: Linux is in spanish , and mysql also. (B (BWorst comes to worst, you could always build a small table of the month (Bnames in Spanish and index the table by the month number. (B (B-- (BJoel Rees [EMAIL

[newbie] localhost login problems from MSW2k command line

2003-03-24 Thread Joel Rees
? Second, why does it complain about the loopback when I said localhost on the command line? Could this have something to do with named pipes? -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: access primitives in php

2003-03-19 Thread Joel Rees
there. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

access primitives in php

2003-03-18 Thread Joel Rees
searching skills seem weak this week. Anyone know of some good tutorial material on the subject? (I am not interested in arguments about which is better, by the way. The requirements of the current project specify that we do both.) -- Joel Rees [EMAIL PROTECTED

Re: Question about auto-increment columns

2003-02-19 Thread Joel Rees
, of course. My choice of search term wasn't very good, I guess.) http://marc.theaimsgroup.com/?l=mysqlm=94495471802684w=2 -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: MySQl db as filesystem.

2002-10-11 Thread Joel Rees
ls and get a list of tables, run cat on a table and get a tab-delimited listing of the contents of the table? On the surface it didn't seem like such an unreasonable question, ... -- Joel Rees (thinking distractedly about trying to edit a MySQL table with vi, among other things) [EMAIL PROTECTED

utility for looking at hex values in strings from the command line (was Re: Japanese Charset)

2002-10-02 Thread Joel Rees
Enjoy. Joel can I get a copy of that hex convert utility too? I am working on a Korean version of mysql yet I currently speak only english. That utility would help me gobbs. -Original Message- From: Joel Rees [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 29, 2002 8:24 PM

Archives are where (was Re: Filemaker database to MYSQL)

2002-10-01 Thread Joel Rees
a mile away, and you have their shoes. Yeah, but they probably have your shoes. ;-) -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: install mysql on osx 10.2

2002-10-01 Thread Joel Rees
, but I am somewhat comfortable with UNIX. Still took me a good piece of a night, but I needed to know about the stuff going on underneath. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: Cannot install mysql on OS X 10.2

2002-10-01 Thread Joel Rees
Philip Lavine scrawled To all, I can not configure mysql on OS X, using the latest build for that OS. Oh? Thanks Sure. (I'm not telepathic. What error messages and/or misbehavior are you getting during the install?) -- Joel Rees [EMAIL PROTECTED

Re: Japanese Charset

2002-09-30 Thread Joel Rees
.) They are working on methods for doing this in MSWindows, but the different user model in MSWindows requires a different approach than they are using for *NIX. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http

Re: Japanese Charset

2002-09-30 Thread Joel Rees
might want to put single or double quotes around something on a page, and the way it is right now MySQL should be throwing syntax errors when it gets embedded quotes. (The hex value of the backslash is 0x5c, see Joel Rees' previous emails for an explanation on how multibyte Japanese characters

Re: Japanese Charset

2002-09-29 Thread Joel Rees
of the characters in a string? Basically, it would be a command-line utility, so you would copy the text and then paste it into the command line, after the name of the utility. You'd need a compiler, of course. -- Joel Rees [EMAIL PROTECTED

Re: Japanese Charset

2002-09-27 Thread Joel Rees
direction? That won't be a topic for the MySQL list, however. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Filemaker database to MYSQL

2002-09-27 Thread Joel Rees
Has anyone created a plugin or script that will allow me to convert my filemaker database to MYSQL Check the archives. There has been some discussion of this in the past. -- Joel Rees [EMAIL PROTECTED] - Before posting

Re: Japanese Charset

2002-09-24 Thread Joel Rees
show up fine when in a static HTML document? (see below). I want to see that static HTML. In Response to Joel Rees: I checked the text you gave me, and I found what's getting clobbered. It's the latter half of characters like the katakana 'so'. Although the byte that is getting walked

Re: Japanese Charset

2002-09-20 Thread Joel Rees
. But your content tool will need to do something slightly different with the input. Could you search the archives about escape sequences or the backslash character? (Maybe someone who remembers could chime in here?) -- Joel Rees [EMAIL PROTECTED

Re: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

2002-09-19 Thread Joel Rees
to understand how a machine could get confused.) -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Japanese Charset

2002-09-18 Thread Joel Rees
.) Question 3. How do I tell which charset MySQL is using, euc-jis or s-jis? It's Latin, unless you've set the language in my.cng/my.ini. It's in the manual, section 4.6. http://www.mysql.com/doc/en/index.html(index page for the manual) HTH -- Joel Rees [EMAIL PROTECTED

Re: JAMES KADEH mysql !

2002-08-29 Thread Joel Rees
James, I took the liberty of forwarding your requests to [EMAIL PROTECTED] I hope you don't mind. For those who are not familiar with poor James's situation, I offer (again) these links: http://home.rica.net/alphae/419coal/

OT: Re: Info on 4.0.x release date

2002-08-28 Thread Joel Rees
earlier suggestion still stands. If you are willing to spec MySQL into your future products, I'd think you'd be most profited by starting to develop with the betas now. Use them internally. Feed bug reports back to MySQL AB. When you start needing answers on a timely basis, buy the support. -- Joel

Re: Info on 4.0.x release date

2002-08-27 Thread Joel Rees
just me.) -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: 30th December 1899

2002-08-25 Thread Joel Rees
. But there are lots of other ways to get bad dates into records. -- Joel Rees [EMAIL PROTECTED] sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Won't compile on Mac OS X 10.2

2002-08-25 Thread Joel Rees
the socket directory and chown/chmod by hand. I think I also built the bin structure by hand, as well, don't remember why. You might try that, just to see. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http

OT put-on-vacation command for list server? (was Re: a newsserver ...)

2002-07-31 Thread Joel Rees
guess I should see if I can figure out how hard it would be. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: about big5 charset

2002-07-24 Thread Joel Rees
, and the necessary files should be in place. The file you need to edit (or make) for MSWinjunk is probably C:\WINNT\my.ini. Look over the manual carfully. -- Joel Rees [EMAIL PROTECTED] Ben Koo inquired Dear Sirs, would you mind to tell me how to add "big5" or "gb" chines

Re: MySQL in different OSes

2002-07-17 Thread Joel Rees
mysqldump. Unless, of course, you're just curious to see what happens when bits aren't where the CPU thinks they're supposed to be. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: Goodday

2002-07-11 Thread Joel Rees
Attn: mysql , My name is Mr. Oluwafunmi G, the manager, credit and foreign bills of Ecobank Plc. I am writing in Well, they're getting smart enough to vary the story line a bit now: http://www.google.com/search?hl=enie=ISO-8859-1q=nigeria+money+laundering+419

Re: multi-byte characters

2002-07-03 Thread Joel Rees
in a MySQL context), and was wondering if anyone can point me to information on how to do that with MySQL and PHP. Have you tried setting the language to Japanese and the encoding to shift-JIS yet? -- Joel Rees [EMAIL PROTECTED

Re: help starting up mysql

2002-06-23 Thread Joel Rees
://marc.theaimsgroup.com/?l=mysqlr=1w=2 -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Re: How to convert non latin characters?

2002-06-06 Thread Joel Rees
with the consonants, at least not in the last hundred years or so. But that doesn't help for Tibet or Myanmar, of course. Unicode is helping bring these sorts of tools a lot closer to reality. You can help, too, if you want. -- Joel Rees [EMAIL PROTECTED] sql, query filter fodder forgotten first time again

Re: to_asci

2002-06-06 Thread Joel Rees
() is really going to do what you want. I'm guessing you would prefer auxilliary fields or tables, but that is just my guess. -- Joel Rees [EMAIL PROTECTED] sql,query,table - Before posting, please check: http

Re: UTF-8 national characters

2002-05-15 Thread Joel Rees
Sven Bentlage asked Is there a way to get UTF-8 national characters sets working when you only have user access to a database (it's my ISP's)? Whether you use the my.cnf/my.ini configuration file or the startup parameter, it's a startup option. You have to have access to one or the other.

Re: Errors catalog, character-sets-dir .

2002-05-01 Thread Joel Rees
. but when I start the client, It continues to look on c:\mysql\\share\charsets. Hmm. Shot in the dark, but you aren't by any chance trying to put your my.ini file on your d: drive, are you? Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Re: mysql /bin directory

2002-04-30 Thread Joel Rees
/Installing_binary.html http://www.mysql.com/doc/L/i/Linux-RPM.html Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re:  character

2002-04-24 Thread Joel Rees
it in tact, so there must be a way... Lasso -- would mean you're on a Mac? Hmm. Does MySQL have a charset for the Mac version of extended ASCII? You may find yourself making a charset. (If so, please share it.) Check under localization in the manual, section 4.something. Have fun. Joel Rees Alps

Re: search pattern matching

2002-04-12 Thread Joel Rees
n't really related. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka blasted filter fodder: sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Re: mysql japanese

2002-04-10 Thread Joel Rees
to keep English and Japanese together in one database, or if you plan to separate the databases so you don't have to mess too much with keeping the browser environments and character encodings and database structure straight. So, please, ask us a question we can answer. Joel Rees Alps Giken Kansai

Re: OpenBSD and MySql

2002-04-09 Thread Joel Rees
collection? Is it too old? If not, it will probably be the quickest solution for now. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: MySQL database changes for japanese Lang..

2002-04-09 Thread Joel Rees
4.6 of the manual? Do you know what parts of the database will store Japanese data, what parts of stored Japanese data will need to be search and/or sorted, that sort of thing? Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Re: adding 8-bit character encoding to mysql-max-3.23.49-win

2002-04-09 Thread Joel Rees
. Try it and see. The manual says you must re-compile to get the new character set recognized. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php

Re: PERL/SQL, again? - Re: Procedures

2002-04-02 Thread Joel Rees
the management at my current shop of the advantages of perl over PHP or Java. Still have to show them that it gains more than it costs to have perl as an additional tool.) Don't have much time, but if you have some short tasks that might help lay some groundwork, let me know. Joel Rees Alps Giken Kansai

Re: Is Addition To Previous Post

2002-04-02 Thread Joel Rees
the archives. ;) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Original Message - From: Marcus - Videomoviehouse.com [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 11:59 AM Subject: Is Addition To Previous Post Here are some results from what I

Re: regarding MySql boolean field/datatypes is there a equvilent bool

2002-04-02 Thread Joel Rees
that with neither SET nor ENUM can you define 'FALSE' as zero. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka Come on - let me out of my misery as im a PostgreSql man but like this tool very much and at the moment creating a work project in both flavours as back end to out front end internet

Re: filemaker to mysql

2002-03-31 Thread Joel Rees
http://www.profdata.nl/pdm/generic.jsp?taxonomy_id=5 (I asked in the devoloper discussions area, if anyone's curious.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http

Re: [newbie post] linked lists..

2002-03-29 Thread Joel Rees
actual linked lists in tables. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: GUI

2002-03-29 Thread Joel Rees
DL Neil wrote: Various scripting/programming languages will interface to MySQL. PHP (and therefore C++) fit into that happy intersection. _^^^ Perl? - Before posting, please check:

Re: auto_increment question

2002-03-28 Thread Joel Rees
se, client ID) so huge that you don't care if there are gaps. An unsigned INT (instead of MEDIUMINT) will give you so many keys that it will take over thirteen years at an average ten new clients per second to overflow. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Re: Importing fixed-length records

2002-03-28 Thread Joel Rees
://www.mysql.com/doc/L/O/LOAD_DATA.html 6.4.9 LOAD DATA INFILE Syntax etc/ HTH Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka sql, query - Before posting, please check: http://www.mysql.com/manual.php

Re: filemaker to mysql

2002-03-28 Thread Joel Rees
they are working on it. It looks like it supports JDBC, so you may be in luck if you use Java. Not much information. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka sql, query - Before posting, please check: http

Re: Enforcing Column Types

2002-03-26 Thread Joel Rees
to either allocate the maximum width for each variable length field, or use an additional level of indirection in the indexing? Just a thought. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka Filter fodder: sql,query (I thought the filter also accepted "database" and v

Re: binary expansion?

2002-03-26 Thread Joel Rees
. Incidentally, have you considered using a SET type here (manual section 6.2.3.4)? Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Access denied on use mysql;

2002-03-19 Thread Joel Rees
set in it for root. As was mentioned, you might have been able to access the 'test' database. Anyway, read that fantastic manual. And follow up on list. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before

Inquiring minds want to know about Unicode in 4.1

2002-03-19 Thread Joel Rees
, allowing all the current additions (Unicode 3.1) in the first extension plane? Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka mysql, tables, select good food - Before posting, please check: http://www.mysql.com

Re: Application security

2002-03-19 Thread Joel Rees
to consider. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: OSX and Virtual Hosting set-up?

2002-03-19 Thread Joel Rees
of MySQL, per the manual, section 4.1.4, Running Multiple Copies? Am I off base thinking this would be appropriate? (Just a thought.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka phpmyadmin (saves using the command line!) to grant 'user' permissions to each domain name. this 'user

Re: Mailing list manager

2002-03-18 Thread Joel Rees
was scheduling using MSW2k's services. (Well, no, the biggest headache is an alternate download feature which I am trying to re-build right now, another curse for MSIE for not handling headers and timeouts very well.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Re: delete old mysql users

2002-03-18 Thread Joel Rees
it. The database name is mysql and the tables in it are user and db, I think. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: adding messages and a character set for shift-jis

2002-03-18 Thread Joel Rees
Michael Widenius wrote: "Joel" == Joel Rees [EMAIL PROTECTED] writes: Joel But comp_err doesn't seem to be in the win32 distribution. So I am thinking, Joel I should be able to load mysql into openBSD and do the conversion there. Or Joel is the comp_err tool available for

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Joel Rees
in the manual, where it describes the install process. I have my data directories on a different drive, no problems. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com

Re: (newbie) how can I regenerate the data/mysql tables?

2002-03-18 Thread Joel Rees
Some airhead wrote: Ehhhtto. You're using windows, right? Have you checked in your php.ini file? I think that airhead must have meant the my.ini file. Or the my.cnf file. :^, PS: The MySQL Reference Manual, section 2.1.2.2 for MSWindows and section 4.1.2 in general. Airhead Alps Giken

Re: Access denied on use mysql;

2002-03-18 Thread Joel Rees
, but it is worth it. Section 3 (Introduction to MySQL) shows you how to specify the host and user, and you are not going to get administrator access logging on anonymously. Section 4.3 has the nitty-gritty, if you need it. c:mysql -h host -u user And there's a password option, too, which you may need. Joel

Re: Foreign languages

2002-03-18 Thread Joel Rees
? I'm curious about Chinese and Japanese (and other asian languages) specifically. Using it light duty with Japanese (s-jis) here. Don't really know why it works yet. (No problems yet.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Re: copy osx db to win2k

2002-03-18 Thread Joel Rees
jake williamson 28 queried: hello! i've been developing a MySQL database in mac osX - i would like to transfer it to work onto a win2k box running apache and mysql. Have you looked at mysqldump and mysqlhotcopy, in section 4.8 of the manual? what files from X do i need to copy over? is

Re: Mysql dump

2002-03-18 Thread Joel Rees
Uma Shankari T queried: I am having all mysql database contents in one txt file.how i will dump all those contents to mysql database tablespls tell me how to do it Have you looked at the manual, section 4.8.7? mysqlimport Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Re: IS THIS BETTER?

2002-03-17 Thread Joel Rees
uot;, and found this: http://www.geocrawler.com/archives/3/13/2001/11/0/7183423/ Like Todd says. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.ph

Re: Languages

2002-03-12 Thread Joel Rees
messages, and I seem to be getting along okay. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Multiple languages (was Re: Cyrillic characters)

2002-03-12 Thread Joel Rees
Weeehll, thet's whut ah git fer shootin' off at th' mouth. Anybody that really knows care to correct the confusion I've caused? (See comments below:) Jim Philips wrote: On Mon, 2002-03-11 at 23:39, Joel Rees wrote: Sort of off topic, but here goes: Jim Philips wrote: I am trying

Re: What type of Unicode?

2002-03-11 Thread Joel Rees
, conversion is always risky, and should be avoided in databases. Best to simply record what the encoding should have been and store it as is. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please

Re: Languages

2002-03-11 Thread Joel Rees
in mysql/share/charsets? Check the Readme and the Index. Also, the manual, around section 4.6. (That monolithic html is a pain. If you download it, download the pdf.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka

Multiple languages (was Re: Cyrillic characters)

2002-03-11 Thread Joel Rees
the locale is. A blob of English text in a record that is otherwise Cyrillic might not really pose any problems. (But you'll want to think it out carefully beforehand.) In other words, it's going to require some experimenting. Let us know how it goes. Joel Rees Alps Giken Kansai Systems Develoment Su

XML Databases (was Re: xml)

2002-03-10 Thread Joel Rees
URL: http://www.mediafusion.co.jp There are some English pages there, as well. I no longer work for them, and they are not connected with my present employer, so please don't ask me questions about it. Joel Rees Alps Giken Kansai Systems Develoment Su

  1   2   >