Time / Date calculations

Is there a way to do calculations on a timestamp field in mysql. I would like to be able to find time elapsed and then the average of the elapsed times. I am using php4 to connect to the database. Any help Will be greatly appreciated. Joel

MySQL on Windows CE

Does anyone have any information on running MySQL on a windows CE handheld? Thanks Joel

Re: Command.com Statement

The command is path=c:\mysql\bin * Earn a dime every time you receive email! Sign up FREE at: http://www.MintMail.com/?m=666501 * - Original Message - From: "Sara" <[EMAIL PROTECTED]> To: <[E

Date calculations with php and mysql

How do I find the elapsed time on a timestamp field? I know there must be a way but I can't find it in the Mysql Docs. I am using php 4 and the latest mysql i386 binary. Thank you very much Joel

CentOS 4.4 mysqld crash

edir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid nice = -5 open_files_limit = 8192 [myisamchk] tmpdir=/home/mysqltmp key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysqldump] quick max_allowed_packet = 16M """ Thanks Joel

Re: CentOS 4.4 mysqld crash

I have opened a bug about this issue: http://bugs.mysql.com/bug.php?id=44914 Joel On Tue, May 12, 2009 at 10:55 PM, Joel Heenan wrote: > Mysql List, > > I have a crash that has occured a number of times on a production CentOS > 4.4 machine. It occurs when using a product calle

Policies in the DBSPI MySQL OpenView on linux server

msgi "PROD-CAPMSG-opcmsg"enabled1 msgi "PROD-OSSPI-opcmsg" enabled 1 msgi "PROD-OSSPI-procmonMsg" enabled1 msgi "PROD_OSSPI-FilesystemMsg" enabled1 Could you help me Thx and re

Exclude duplicates except most recent using GROUP BY and HAVING

May 05 13:37:29 EDT 2006 CYB1| 000F20D0272D-453E8A1B-0365-CEED-02D6| CAL_LAPTOP | Fri Feb 09 09:46:09 EST 2007 CYB1| 00508BE171F3-4587E84F-0540-56B8-003D| CFWRKSTATION| Tue Feb 06 16:14:03 EST 2007 ... -- Joel Nimety Product Architect 203.5

Re: Exclude duplicates except most recent using GROUP BY and HAVING

e have any suggestions? Am I posting on the correct list to get this answered? Thanks. Joel Nimety wrote: > The default "host" table can possibly have multiple records for a given > workstation. Presumable the duplicate records are for historical > purposes, but only one is actually

Re: Cannot find uppercase user from mysql.user table

. But, if the entry in the user field 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 i

Re: mysql query output get wrapped

. Stretch your terminal window wide. If that isn't enough, pipe to a file and break out a text editor that scrolls horizontally as well 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: Unicode(ucs2) setup question

> 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

Re: 4.1 character set documentation

current for 4.1.1 and some 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

to handle latin as if it were single-byte. You 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: Set no root password

to be able to get to the data 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 archi

Re: 4.1 character set documentation

> 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. Y

XML in MySQL

Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? -- Joel Amoussou XML Instructor IBM XML Certification Practice Test http://www.xmlmentor.net/xmlexamsim.htm

Re: mysql.sock doesn't exist

cket is supposed to be created in? Do you 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:/

Re: mysql.sock doesn't exist

nually created was blown away after trying to light > it up. 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: Can't compile on NetBSD

> 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

Re: .fil

ing the script, of course. -- 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: License?

dangerous one, and when you hear the suits talk about "frictionless economy", tell them to take their manure generators elsewhere.) -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List

Re: License?

supporting the people who 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

> Todd I think the word, "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

Re: Root@?

> 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 >

Re: MySQL vs. PostgreSQL -- speed test

27;t get enough performance out of PostGreSQL, you should by then have identified what tables need to be high-performance, and you should be able to use MySQL for those. Use all your tools. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.al

Re: MySQL vs. PostgreSQL -- speed test

gt; is to blame, 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 --

Re: Perl/mysql question

t;'; $dbh->do($statement) or die "tilt\n"; Upload data from pipe delimited text file. Loads whole table. LOAD DATA LOCAL INFILE "[path with front slashes] filename.txt" INTO TABLE tablename FIELDS TERMINATED BY "|"; Note that some service providers don't

Re: How does one get off of this list

ql.com/[EMAIL PROTECTED] (Hmm. That's changed 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

Re: Using a foreign character set in MYSQL

ners keep thinking that \u 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/m

Re: Using a foreign character set in MYSQL

system also has to know what character set you're going to use. Likewise, you'll have to tell people's browsers it's Chinese. And if you're using Big-5 with Java, you'll have to tell Java to convert between Unicode and BIG-5. HTH -- Joel Rees, programmer, Systems

Re: How can I enable unicode and japanese support?

re mysql to use unicode? 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.mys

Re: PHP or Perl?

and PostGreSQL can be mixed 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?

s 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 archi

Overriding mysql connection variables

Does anyone know whether it is possible to override the MySQL connection variables used in a PHP script? I use Plesk and want it to use a database that is located on an external server, but I cannot edit the variables as Plesk is closed source? Joel Moss HomepageUniverse.com -- MySQL General

Implementing xml/xpath UDF with libxml2

place??) to call per-process initialization and deinitialization routines for UDF's? - or - 2. Is there another way to do this? Thanks. Joel

Re: Ingres vs MySQL

and came up with the following: http://www3.ca.com/Solutions/Product.asp?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 informa

Re: Question about auto-increment columns

scussed many times before and since, of course. My choice of search term wasn't very good, I guess.) http://marc.theaimsgroup.com/?l=mysql&m=94495471802684&w=2 -- Joel Rees <[EMAIL PROTECTED]> - Befor

access primitives in php

re, but my 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 <[EM

Re: access primitives in php

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

[newbie] localhost login problems from MSW2k command line

otten about and just can't find in the manual today? 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/[EMAIL PROTECTED]

Re: Creating fulltext index never completes...?

> ... > 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

Re: Spanish

> 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 P

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

t on > the command line? Could this have something to do with named pipes? Is localhost folded to the loopback? That seems 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: Mac OS X package problems

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 proce

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

http://www.google.com/search?hl=en&ie=ISO-8859-1&q=encryption+mysql You might have to dig in a couple of pages, or maybe try a different set of search keys. (That's probably not much help, ...) -- 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]

Signal 11 on replicated MySQL Slave (4.0.13-standard)

'll know in a day or so when I can check how the replication is going. >Submitter-Id: >Originator:Joel Rowbottom >Organization: Fotopic Ltd. www.fotopic.net >MySQL support: none >Synopsis: mysqld crashes with signal 11 on replicated slave >Severity: se

Re: Oracle to MySQL or ?

ntermedia. Hmm. I guess I could look it up. http://www.google.com/search?hl=en&ie=ISO-8859-1&q=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

Re: MySQL PHP Development IDE

> This off topic, but one of our programmers is interested in NuSphere's PHPEd > development interface and I would liek some feed back from other users. > > His interest lies not so much in using for database table modeling, but for > PHP and Perl development. If he's not really that interes

Japanese shift-JIS messages

ld re-compile something? Or run a filter on something? If this might be possible, I'd appreciate a pointer in the right direction. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please chec

Re: Japanese shift-JIS messages

sql\share\japanese_sjis directory and save the two > errmsg files in it in shift-jis. Sections 4.6.2 through 4.6.7 in the manual talk about this. I'm going to have to do some reading. I'll have to pick this up on the internals list, I suppose. Sorry about the line noise. Joel Rees

Re: delete after undo

ob for Perl. Of course, it would be nice if you could get someone familiar with the internal formats mysql uses to give you some hints, unless you are really good at reading source code. Back up the directory tree twice, and work on one of the copies, of course. And stay away from the beer until

"XML Databases" (was Re: xml)

anyone is interested, here's their 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

Re: What type of Unicode?

hat characters are equivalent to what, and similar problems, 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 --

Re: Languages

n French > > Latin Spanish > > Portuguese Did you look 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 R

Multiple languages (was Re: Cyrillic characters)

For simple storage, however, you really don't care what 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 experimentin

Re: Languages

n't use the euc-JIS Japanese error 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

Re: Multiple languages (was Re: Cyrillic characters)

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: > >

Re: IS THIS BETTER?

ch on Google: "mysql error 3251", 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 c

Re: Mailing list manager

sible to build in a man-week. The biggest headache 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

Re: delete old mysql users

MySQL script to do 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

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

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 conversio

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

ows, right? Have you checked in your php.ini file? This is mentioned 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

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

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 Kansa

Re: Access denied on use mysql;

er And there's a password option, too, which you may need. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: Foreign languages

kinds of searches in, etc? 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

Re: copy osx db to win2k

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? i

Re: Mysql dump

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,

Re: Access denied on use mysql;

on as you know how. You may have a my.cnf (root of your system drive, I did see a c:> didn't I?) or my.ini (Windows directory) left over from the previous install. That may have a default password set in it for root. As was mentio

Inquiring minds want to know about Unicode in 4.1

encodable space, 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

Re: Application security

. Or perhaps a server for each party. Again, you would have a lot of trade-offs to consider. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (t

Re: OSX and Virtual Hosting set-up?

f MySQL, or a separate instance 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 gr

Re: Enforcing Column Types

in a database? that the database software has 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 als

Re: binary expansion?

2. A result of 1 says it's a hit, 0 says it's a miss. 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,

Re: auto_increment question

make your index (in this case, 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 Deve

Re: Importing fixed-length records

ILE Syntax. http://www.mysql.com/doc/L/O/LOAD_DATA.html 6.4.9 LOAD DATA INFILE Syntax HTH Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka sql, query - Before posting, please check: http://www.mysql.com/manua

Re: filemaker to mysql

orted on Mac OS X, but they seem to indicate 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 --

Re: [newbie post] linked lists..

he disk, it is usually best to avoid 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.

Re: GUI

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: http://www.mysql.co

Re: filemaker to mysql

ing links: http://www.filemaker.com/ti/105748.html 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 ---

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

se I have yet to convince 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 gr

Re: Is Addition To Previous Post

check 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 &

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

manual page as above). Or you may just want to use 0 and 1 in a TINYINT field. Depends on what you need. I note 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 P

Re: Uninstalling on MacOS X

(Does anyone?) > 2) several weeks go by without use, forget password to mysql > 3) cannot remember password, at all > 4) install mysql over itself, doesn't fix problem When you forget your password, see the manual about the "--skip-grant-tables" option. And don't forg

Re: OpenBSD and MySql

there a reason you don't want to use the binary in the openbsd packages 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

Re: MySQL database changes for japanese Lang..

Have you read section 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 Develomen

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

ork for 8-bit character sets. 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://w

Re: mysql & japanese

acter sets they work with, etc. And we don't even know for sure if you are going to try 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 dat

Re: mysql & japanese

n the list can. I'll this to the list and BCC you, hope you don't mind. (BCCing you means you'll have to watch the list for answers.) Thanks for making me look up the charset options for MySQL again. Now maybe I'll get my machine set up right. ;-) Joel Re

Re: search pattern matching

ained, but aren'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 manu

Re: OpenBSD and MySql

openbsd packages > > collection? Is it too old? If not, it will probably be the quickest > > solution for now. > > I'm using openbsd to host a server from home, and the default binary isn't > configured correctly. What configurations are you having problems with? Most of the

Re:  character

n and retrieve 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.

Re: mysql /bin directory

installing: http://www.mysql.com/doc/I/n/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/

Re: Errors catalog, character-sets-dir .

-sets-dir=d:\mysql\share\charsets. > 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

Re: UTF-8 national characters

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: How to convert non latin characters?

s on how consistent the authors were. Japanese has five vowels, a, i, u, e, and o. People don't usually do anything strange 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

Re: to_asci

ering if something like to_ascii() 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 -

Re: help starting up mysql

tmp/mysql.sock' (61) > >> > >> What do I need to do, please? I myself made the directory to store the sockets in by hand. I doubt that was the right thing to do, but I was able to get mySQL to run, query the permissions table from the command line, etc. > >> (Does this li

Re: need your attn: can mysql support japanese and korean simultaneously in same database

to pick up some oddball cases. Or, you might consider keeping the Japanese and Korean data in separate tables on separate servers. From what I understand, that should be possible. > if you can sugest any other package or addin for this, that would > also be >

Re: multi-byte characters

7;ve seen it > called ejis 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?

  1   2   >