default-character-set problem

Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49

Re: How to use comma instead dot in numeric values?

I had the same problem. No, in MySQL you can't. But you can use number_format() function of PHP. Check PHP Manual for How-to Nikos --- Putte Koivisto <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > > Is there a simple solution to define MySQL to use > comma i

float digit

How can i change the floating point '.' to ',' as a decimal separator in MySQL 3.23... in Linux RH 7.2? Nikos - sql, query Do You Yahoo!? &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&e

"my.ini" in RH Linux 7,2

In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? Thanx Do You Yahoo!? &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&th

MySQL LOGS

Does anybody know how to make log files for each of my databases? Thanx sql, query Do You Yahoo!? &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr

Flash & MySQL

For the one who need help about using Flush and Mysql, there is a tutorial in the phpbuilder.com, which is enough good. Nikos --- Do You Yahoo!? &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &t

Re: Unknown MySQL Server Host 'localhost' (11001)

I've got apache in Win32 system and MySQL 3,32... intall also. As far as i know mysql admin needs a server (loclhost) to work. The ODBC@localhost apears to me when i havn't give permisions to a user to select a database. You should check mysql database where you choose permisions. Nikos --- Kev

Re: Character set

I had the same problem with greek characters. I set field as binary and the problem corrected. --- National Theater of Greece <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hi. > I have installed SuSE Linux 8.0 Proffessional and > the MySQL that came with > it. If anyone of you has do

Re: script for complete Database dump?

I suggest you to copy the database files. If you are the administrator in a Linux system make a cron once (for example) a week to copy this files to somwere else. --- Kai Vermehr <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > is there any single MySQL script that would backup > my co

Re: Euro sign & mysql

The html symbol for euro sign is: "€" (without quots) if that helps. Is it neccecery to insert it in the database? --- Derk van der Harst <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hello everyone, > > how can I insert records with the Euro sign into the > mysql database? > When

Re: Unknown MySQL Server Host 'localhost' (11001)

Kevin, have you got install Apache HTTP server? --- Kevin Walker <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hi all > > I've recently downloaded and installed MySQL 3.23.52 > for Windows. I'm > running Win95 OSR2, and Winsock2 is installed. This > is a standalone PC with > no web

Fwd: Re: Importing into MySQL from Access

Did you try to make an .csv file and then import it with Mysql-Front? I believe that both tables have the same structure. > --- Ian Zabel <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > I already > have my table structure in place in MySQL, > > and I just want to > > import the dat

Re: How to separate different domains on an e-mail database

ient/quicker MySQL solution is available? > =dn > > - Original Message - > From: "nick gatsis" <[EMAIL PROTECTED]> > To: "DL Neil" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, August 12, 2002 9:06 AM > Subject: Re: How

Re: PHP form to mySQL

Check some articles in http://www.devshed.com/Server_Side/MySQL, http://www.devshed.com/Server_Side/PHP --- JeRRy <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hi, > > I am trying to setup a PHP form to send to mySQL > database. I know how to connect to mySQL but need > help getti

Re: How to separate different domains on an e-mail database

Its a PHP function my friend. I'm using 3,23... --- DL Neil <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Nick, > Explode: which version of the MySQL manual are you > using? > =dn > > - Original Message - > From:

Re: can't use the table. What happen, please!!!!!!!!!!

Did you flush-privileges? --- Sandra <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hi all, > > I am getting the error when trying to connect server > from my client: > > > Warning: mysql_num_rows(): supplied argument is not > a valid MySQL result > resource in . > > I had my

Re: Adding super user

Try this: Use mysql tables, change or add record in user table. If you add password (and you must) use password('password'). Then flush-previleges from mysqladmin. Also, you must change host and db tables. Go to www.devshed.com and read "access granted" article. Cheers --- Marius Pana <[EMAIL P

Re: How to separate different domains on an e-mail database

You must create an extra field in your database to store the domain. Use the explode() to seperate the domain from ...@ (array explode (string separator, string string [, int limit]) Returns an array of strings, each of which is a substring of string formed by splitting it on boundaries formed by