Differet Char Sets in MySQL 4.0 ?

Does MySQL 4.0 allow mixing of character sets in a database? I'd like a table which lists the locale string for a particular phrase in multiple languages. I have it working in french, english, german etc in MySQL 3.23 but I needed a seperate instance of mysql installed for the russian database to

Re: MySQL Web Server ?

> Hi, I'm a MySQL newbie - Is there a "MySQL Web Server" > product ? Oracle has their OWS (Oracle Web Server) > for example. > As far a I know this is based on Apache. Of course it takes Oracle weeks to update it after a security vulnerability is exposed, whereas if you were using Apache you'd h

Russian in MySQL ?

I have a website which gets data from MySQL. The website is in several languages. I'm now working on Russian, and we have the translations, but I can't seem to get it into MySQL. I have a few questions which I hope someone can help with: 1) I see from research I must run another instance of MyS

Source compile on Tru64 Unix?

Hi, I'm trying to compile mysql 3.23.49 on a compaq DS10 box running Tru64 Unix 5.1 . The binary for ev6 doesn't seem to work on this architecture (Alpha 21264 processor) and so I'm compiling using the compaq c and c++ compilers (v6.2) from source. Compaq 'make' doesn't work so I'm using 'GNU m

Re: dumping between tables?

> > I want to dump the contents of one table in to another table > > which has the same structure in MySQL, with just one column type changed > > from VARCHAR to TEXT. Whats the best way to do this? > > > Would INSERT...SELECT suit you? > =dn > > Yes, but it's a big table. Is there a way to d

dumping between tables?

Re: sql query Hi, I want to dump the contents of one table in to another table which has the same structure in MySQL, with just one column type changed from VARCHAR to TEXT. Whats the best way to do this? Paul - Before

Re: dumping between tables?

> > I want to dump the contents of one table in to another table > > which has the same structure in MySQL, with just one column type changed > > from VARCHAR to TEXT. Whats the best way to do this? > > > Would INSERT...SELECT suit you? > =dn > > Yes, but it's a big table. Is there a way to d

dumping between tables?

Re: sql query Hi, I want to dump the contents of one table in to another table which has the same structure in MySQL, with just one column type changed from VARCHAR to TEXT. Whats the best way to do this? Paul - Before

Data Types for TEXT, BINARY?

Hi MySQLers, What's the best data type to use for a text field of say 500 words (~5000 chars)? Can I use VARCHAR(5000) or should I use TEXT or MEDIUMTEXT? Also whats the best column type for a binary upload of an image or word document of say a max 3 MB in size? Should this be a BLOB, MEDIUMBLO

Tru64 Unix binary?

Hi all, I've got the mysql-3.23.46-dec-osf5.1-alphaev6 binary, but can't get it to work on a DS10 Alpha Server. It hangs on the "Installing all prepared tables" part of the mysql_install_db script 'sizer -implver' reports that the system chip is indeed an 'EV6', so I would have thought thi

reset auto_increment?

Can someone tell me how to reset a column's auto_increment starting point back to 0 in mysql ? Thanks Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

terminal display width?

Hi, I like to chyeck my mysql db's/tables using the unix command line, and doing a "select * from table". However some field are very long - varchar 255 - is there a way to set the display width when viewing the data. ie - so that binary/large text fields are truncated after a few characters. Th