On Fri, Jul 13, 2001 at 02:56:05PM +0800, Rolf Hopkins wrote:
> In all the years I have worked/studied SQL, not once have I come across the
> INSERT INTO ... SET ... syntax.
> My questions are:
>
> 1. Is this a valid statement?
> 2. Is it ANSI standard?
> 3. Is this a MySQL feature / bug or do ot
Hi,
The purpose of the execute parameter I to execute a command and then
quit; An example of how to use the "--execute" or "-e" parameter
follows:
Prompt> mysql -e "select * from user" mysql
[prints everything from mysql.user to stdout]
If you want to execute the contents of a file through the
Hi all,
A week ago or so, someone on this list had a problem with inserting data.
I thought the reason was because they had mixed up the INSERT and UPDATE
statements.
ie. INSERT INTO table_name SET column1=a_value, column2=a_value, ...
However, they said this statement works from the MySQL pro
Hi,
I have approx. 110 SQL scripts in a directory. Each containing DROP TABLE, CREATE
TABLE, lots of INSERT INTO and finally a COMMIT.
I need to run all these script in mysql console.
My plan is to write a perl script that looks into the directory and fetch all *.sql
scripts and then execute t
Monty and all at MySQL,
I am sorry to hear about this most unfortunate situation. It is sad to see
that NuSphere have taken it upon themselves to attempt to steal your
intellectual property and try to benefit from all of the MySQL team's
hard work. My company has been licensing using MySQL for d
Hello,
I downloaded and pkg_add (installed) the following:
"mysql-server-3.23.39.tgz" , "mysql-client-3.23.39.tgz" and
"libtool-1.3.4_2.tgz" into FreeBSD 4.2
I seem to be getting an odd error.
Can't load DB driver: /usr/local/lib/mysql/libmysqlclient.so.10:
Undefined symbol "strtoll"
>From w
Didn't see a response to this so here's some ideas.
You can do an INSERT INTO tablename SELECT ... statement or if you are
creating a new table to put these values into CREATE TABLE tablename
(SELECT ...). Check the manual for the exact syntax and for which version
of mysql you'll need for th
PeterWR wrote:
>
> Then you can start wondering why one software company wants to promote "open
> source" by using another companys software - why is the Progress database
> not good enough for NuSphere ???
>
> Best regards
> Peter
> Copnehagen Denmark
>
Peter:
Have your ever worked with Prog
In the Win 32 version, I seem to have problem scrolling the tables. If I
grab the vertical scroll bar and try to pull it down, it won't work, unless
I use the arrow keys to move it down about 1/10 of the way, then and only
then and lower will it let me scroll by grabbing the scroll bar. Unkno
Here;s the tutorial i have been using
http://www.mysql.com/articles/ddws/2.html
Enjoy
Ken
- Original Message -
From: "Channon Quillen" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 7:38 PM
Subject: Multiple input using a form
> This question might b
Hi Monty,
When reading Your comments, I became very sorry for You and MySQL.
With almost four years experience on MySQL on Windows, I have had no
problems of any kind. You and Your people are doing a great job both on the
software and on the support - other major players could learn from MySQL w
Hi,
Your syntax is incorrect.
>cout << "ID: " << *Row[0]; // it
returns "48 too much"
It seems you are printing the ordinal value of Row[0]
Try using cout << "ID: " << Row[0]; Instead.
>cout << "Name: " << (char *) Row[1];
This works because all you're doi
This question might be a little off topic, but I can see that there are
many people using mysql with php.
I'm looking for examples using a multi-part form to have the user enter
items by way of pull-down menus. The info put into the form should query
the database and store the results in a var
> If anyone has any comments about how we at MySQL AB work as an open
> source company, please write to our CEO Marten Mickos via
> [EMAIL PROTECTED] and we will welcome your suggestions. We are
> totally dependent on the trust of our users, as everything we do are
> open source, and we are trying
Hi,
You need to check the ALTER TABLE syntax in the manual.
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Unless you use the "FIRST" or "AFTER" clause, all the new fields will be
added at the bottom of the table. This procedure will *NOT* break your
database.
Regards,
Jorge
For technical su
Hi!
>Enhanced MySQL(tm) is as the words say a value-added version of
>MySQL available from NuSphere and is available as part of two
>products that contain NuSphere MySQL: NuSphere MySQL Advantage and
>NuSphere Pro Advantage (which also includes a really nice PHP IDE if
>you haven't seen it). Ta
Hello,
Does MySQL support unicode? and if not, is there some way to store and
retrieve text encoded in multi-byte character sets. What datatype
should be used and what caveats should be observed?
Thank,
Minh Tran
The new URL is: http://michael.bacarella.com/research/mysqlmyths.html
The old one will still work, this one just helps feed my ego :)
Changes:
Reformatted the page. If this is going to be the major weapon
against FUD that I hope it will be, it should at least look nice.
Some new test
Hi all,
When using the 3.23.39 client to connect to the server, pressing tab to
complete table names and field names etc doesn't seem to work. I seem to
get the mysql commands, but I thought in past clients I was able to get
table name and field name completion as well.
Have others noticed t
On Fri, Jul 13, 2001 at 01:03:19AM +0200, Sander Pilon wrote:
>
> Rule number one on the internet: If you have a trademark, GET THE
> .COM, .NET, .ORG, .CC and .CX ASAP!!!
>
> The fine folks at MySQL ignored that rule, and are now left with a
> rotten situation. IMHO, their own fault - and the w
>
> "Sander Pilon" <[EMAIL PROTECTED]> writes:
>
> > > I think all of us should send a letter to the people who
> > > appropriated
> > > the MySQL.org name. In my opinion, if MySQL AB wants this
> domain they
> > > should have the right to it. To me, it is a show of
> disrespect to the
> >
I need some reasurance...
I have an existing MySQL database that has basic user information. I am
using it to authenticate users on our web site. I has ID, Password,
FirstName, LastName etc.
We want to add columns at the end of this database for more detail... City,
State, Zip, Phone, etc. I am
"Sander Pilon" <[EMAIL PROTECTED]> writes:
> > I think all of us should send a letter to the people who appropriated
> > the MySQL.org name. In my opinion, if MySQL AB wants this domain they
> > should have the right to it. To me, it is a show of disrespect to the
> > fine folks at MySQL AB an
> I think all of us should send a letter to the people who appropriated
> the MySQL.org name. In my opinion, if MySQL AB wants this domain they
> should have the right to it. To me, it is a show of disrespect to the
> fine folks at MySQL AB and I am disgusted that mysql.org has chosen
> to so
Jeremy;
I've been following this thread, and what I am unclear about is why would I
want to use replication?
Forgive me, I am very new to MySQL, and my point of reference at this
juncture of understanding is as a new administrator of a MySQL server used
for webhosting customers.
I found the
On 12-Jul-01 Christian Terboven wrote:
> Hi all!
>
> I`ve got a quite strange problem.
> When querying my database, all my integer values are exactly 48 too high.
>
>
>
> Assuming the following code (using Linux):
>
> Database layout:
> (ID INT, Name CHAR(100), ...)
>
> m_pResult = mysql_st
It is hard to say where I am confused because the
HOWTO requires me to try and follow it as I setup
replication. So let me try and follow the
documentation and if I see anything that can make it
more clear then I will let you know. One thing that
does come to mind though is maybe adding something
Hi all!
I`ve got a quite strange problem.
When querying my database, all my integer values are exactly 48 too high.
Assuming the following code (using Linux):
Database layout:
(ID INT, Name CHAR(100), ...)
m_pResult = mysql_store_result(&m_Connection);
// get the first record
m_iCurrentDatas
Hello everyone!
we recently upgraded from 2.23.27 to 2.23.39, and in the same time changed machine
from a p3-666, 512MB, ide to a dual p3 550, 896MB, scsi. The platform is Linux. As
expected
we got a enourmous increase in database speed. Then we encountered a strange behaivour:
Suddenly MySQL s
On Thu, Jul 12, 2001 at 02:58:17PM -0700, Jeff Philapy wrote:
> Thanks for the fast reply.
No problem.
> Where can I a step by step guide on how to setup replication. I have
> already looked at mySQL's howtom but now I like to find something
> with more information, that better explains the proc
On Thu, Jul 12, 2001 at 12:44:43PM -0700, Michael Collins wrote:
> The article mentions that the Web site will confuse new users, but I
> think this one will confuse them even more:
>
> http://mysql.net/
So maybe "mislead" would have been a more precise word?
--
Jeremy D. Zawodny, <[EMAIL PROT
Thanks for the fast reply.
Where can I a step by step guide on how to setup
replication. I have already looked at mySQL's howtom
but now I like to find something with more
information, that better explains the process.
Jeff
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> On Thu, Jul 12, 2001
On Thu, Jul 12, 2001 at 02:30:52PM -0700, Jeff Philapy wrote:
> Hello,
>
> I am looking at the mySQL replication feature. Can replication be
> setup on one server? In other words can we replicate between two
> databases on one machine?
If you mean running two copies of MySQL and having one repl
Hello,
I am looking at the mySQL replication feature.
Can replication be setup on one server? In other words
can we replicate between two databases on one machine?
Thanks,
Jeff
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
ht
Andy De Paoli <[EMAIL PROTECTED]> writes:
> Help, I have a very urgent problem, I installed RedHat 7.1 for a company
> that wanted to migrate to it with their MySQL database.
> Unfortunately I encountered problems with MySQL
>
> 1. I ran mysql_install_db
Don't do that. "service mysqld start" w
I just downloaded the MySql (version 3.23.39-nt) and I was following the the
tutorial. I was able to use some commands, but I couldn't create database
and tables. When I type mysqld-nt install tells me it failed to open the
service, but with mysql command I am able to type the instructions of
Products:
BCB 4 professional
MySQL latest
MyODBC latest
Here's the code I'm using
bool AnAuthor::CheckIfExists(int p_ID) {
TQuery *CheckAuthor = new TQuery(NULL);
AnsiString strQuery;
bool retVal;
strQuery = "SELECT COUNT(*) AS AUTHORCOUNT FROM AUTHORS WHERE
Is there anyway to get my hands on this object file?
I've downloaded all the parts listed for the GUI... and I've read through
the docs which noted that the edfile.o object was left out of the library
build for Fl_Editor... but when I looked around in the directories where I
built Fl_Editor it's
I think all of us should send a letter to the people who appropriated
the MySQL.org name. In my opinion, if MySQL AB wants this domain they
should have the right to it. To me, it is a show of disrespect to the
fine folks at MySQL AB and I am disgusted that mysql.org has chosen
to so blatantly
Hi!
I have various tables more or less similar to this :
mysql> desc disk;
+--+---+--+-+-+-
--+
| Field| Type | Null | Key | Default |
Extra |
+--+---+--+-
Hi Andy,
Try to kill the process first, then restart mysql server. Hope that helps.
Thanks,
Xi Jiang
ITSportsNet Technical Support
- Original Message -
From: "Andy De Paoli" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, Jul
Help, I have a very urgent problem, I installed RedHat 7.1 for a company
that wanted to migrate to it with their MySQL database.
Unfortunately I encountered problems with MySQL
1. I ran mysql_install_db and got the messages about running mysqladmin
to create a root password, OK so far
2. ran my
I typically do not ask for help, but in this matter it needs to be
correct and precise. I am installing MYSQL on a windows 2000 server
with IIS 5.0, I need help installing it, the documentation just
doesnt cover it for me. I know this is an unusual request but would
someone please help me instal
Hi
when i am trying to insert the following value into the text field, the
value is changing and the new one is inserting in the table.
I tried both preparedStatement and Statement object for insertion..
Input:
This is giving in textarea of html code
main()
{
fprintf("hi")
}
when i a
Be careful using REPLACE instead of UPDATE as it will destroy any fields in
the existing record that aren't in the update field set. Unless of course
you always plan on setting all the fields on every REPLACE.
REPLACE is basicly an INSERT which upon finding a duplicate will replace it.
So treat
That sounds like the bug. In my example, I specified all
five primary keys in both the update and the WHERE part, so that
matches the situation reported in the bug. Thanks.
I changed my program to use a REPLACE instead of an UPDATE,
which seems to have worked around the problem. Do
In the change log for 3.23.29:
Fixed a bug in UPDATE involving multi-part keys where one specified all key
parts both in the update and the WHERE part. In this case MySQL could try to
update a record that didn't match the whole WHERE part.
I think that was fixed. Try upgrading your mysql server
On 12-Jul-01 Sebastian Sanchez wrote:
> Hi all:
>
> I'm having this problem when deleting many rows from a very large table,
> after waiting for 3 hours or so mysql tells me that 20 mega rows have been
> deleted, but
> a df -k still says that no space has been freed.
>
Correct, the rows are *
Hi all:
I'm having this problem when deleting many rows from a very large table,
after waiting for 3 hours or so mysql tells me that 20 mega rows have been
deleted, but
a df -k still says that no space has been freed.
Thanks in advance,
Sebastian.
-
We have a table "ticker" with five primary keys. Sometimes we
do an UPDATE but don't change any values. This produces the
error "ERROR 1062: Duplicate entry". The manual indicates that
a no-change UPDATE is allowed. (ref page 583) Is this a bug,
or a documentation error?
There are no
At 15:01 12/07/2001 +0200, Järkeborn Joacim wrote:
Hi,
Did you had moved the mysql database (together with the grant tables)
for the new location ?
I can't to test Novell mapped drive on Win32, however I didn't find
problems with mapped drives on Win32:
E:\mysql\bin>mysql
Welcome to the MySQL mo
On Thu, 12 Jul 2001, Mike W. Baranski wrote:
> Not trying to step on any toes... I was told (awhile back) by Sinsa that
> mysql++ did not work with gcc 2.96 that redhat released b/c that version
> of gcc was not a gcc "release" and therefore not really supported by the
> gcc people. He also impl
RH 7.1
GCC 3.0
Did someone say there was a patch for this?
[mike@hanna mysql++-1.7.9]$ make
make all-recursive
make[1]: Entering directory `/home/mike/mysql++-1.7.9'
Making all in sqlplusint
make[2]: Entering directory `/home/mike/mysql++-1.7.9/sqlplusint'
/bin/sh ../libtool --mode=compile c
Andreas Iwanowski wrote:
> How can i fix the problem that the records are ordered by unixtime,
> beginning with the newest record ?
http://www.mysql.com/doc/S/E/SELECT.html
--
H | Hi, I'm currently out of my mind. Please leave a message. BP!
+
I think it's the same size as is defined in the server variable named:
max_allowed_packet
regards,
Gudmundur
- Original Message -
From: "Mary Ustinova" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 1:51 PM
Subject: Any limitations on SQL statement length ?
>
Not trying to step on any toes... I was told (awhile back) by Sinsa that
mysql++ did not work with gcc 2.96 that redhat released b/c that version
of gcc was not a gcc "release" and therefore not really supported by the
gcc people. He also implied that this was a problem with gcc, and when
gcc was
"Mike Baranski" <[EMAIL PROTECTED]> writes:
> Does mysql++ work any better with gcc 3.0 than it did with 2.96 (The
> RedHat "release" (I use the term loosly)).
2.96RH is working very well, thank you - it's was the best compiler
available (performance, bugs, standards compliance) until gcc 3 was
Mike Baranski writes:
> Does mysql++ work any better with gcc 3.0 than it did with 2.96 (The RedHat
>"release" (I use the term loosly)).
>
> M
There are actually 2.96 releases that work just fine with MySQL++
1.7.9, such as 2.96-67.
Regarding 3.0 I have a patch that helps builld and run MySQL
Hi !
Maybe anybody knows what is the maximim length of SQL statement ?
I could not find in docs.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Crazy its working this morning. Must of had some kind
of hickup, but I swear yesterday it was not working.
=)
Thanks.
--- Rolf Hopkins <[EMAIL PROTECTED]> wrote:
> In what way doesn't it work? Works fine for me.
>
> - Original Message -
> From: "Mike Mike" <[EMAIL PROTECTED]>
> To: <[EM
It may be the DESC that prohibits the use of the index.
Try an normal ascending order.
Gunnar von Boehn wrote:
> Could somebody please explain to me
> why mysql doesn't use an INDEX for ORDER BY
> in joined selects with LIMT and no WHERE clause.
>
>
> thanks
>
> Gunnar von Boehn
>
>
> On M
Hi
how can I recive parameters from an external aplications in my MySql queries.
for example in MS Access I do this in this way:
PARAMETERS (variable AS type)
SELECT ..
I want to do the same thing in MySql
Indexes will solve it magically, post the query and table structures (if
not too big, you can also just post the revelant cols and indexes) and
maybe describe the select, and someone can advise you on indexes to
create, this join should be no problem.
Mike.
Anthony Appleby wrote:
>
> Has anyone
Don Read wrote:
>
> On 11-Jul-01 Mike W. Baranski wrote:
> > Awsome answers! I'll clear a few things up where appropriate
> >
> > Don Read wrote:
>
>
>
> >>
> >>
> >> Why the LEFT JOINS ?
> >> They're (mostly) used for finding set membership; whenever you see
> >> 'LEFT JOIN b' without s fo
Has anyone found a problem (and solution) on LEFT JOIN when using
MySQL version 3.23.38 under SuSE Linux?
We have two tables of 5000 and 1000 records respectively but LEFT
JOIN takes over 10 minutes.
Can anyone give any guidance on this?
Thanks
Anthony Appleby
The table not locke error occures when you have issued a lock tables
command, and then access a table not included in the lock tables call.
You must lock all tables you intend to access between the lock and
unlock calls.
Werner Stuerenburg wrote:
> As I said earlier, I have troubles with 3 ta
>Description:
Unable to build. The ./configure script runs completely, but then
make stops with a linkage error at this point:
make[3]: Entering directory /usr/src/mysql-3.23.39/sql'
(...)
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implici
t
Hi there,
I have installed the Win32 mySQL binaries on 'C:\mysql' and databases on
'C:\mysql-data'. I have also an configuration file 'C:\my.cnf' containing (and other
things):
basedir = c:/mysql/
datadir = c:/mysql-data/
- Now I want to move the databases to a mapped novell disc 'K:\' and ch
I run SCO Unix and Linux here.
We have web Apache web servers here using PHP and perl, each accessing
MySql.
The reason I said "assuming your webserver supports MySQL" is because
I have no experience running win2000 web servers, but see that many who
post here do.
I thought from your statement
Does mysql++ work any better with gcc 3.0 than it did with 2.96 (The RedHat "release"
(I use the term loosly)).
M
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Has anyone found a problem (and solution) on LEFT JOIN when
using MySQL version 3.23.39 under SuSE Linux?
We have two tables of 5000 and 1000 records respectively but
LEFT JOIN takes over 10 minutes.
Can anyone give any guidance on this?
Thanks
Anthony Appleby
--
Thank you for the fine bug report.
We shall fix it soon.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ w
>Description:
Query doesn't work on temprory table while works on normal tables.
>How-To-Repeat:
CREATE TEMPORARY TABLE tree (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(10),
left_col INT NOT NULL,
UNIQUE (left_col),
right_col INT NOT NULL,
UNIQUE (right_co
[EMAIL PROTECTED] writes:
> >Description:
>
> Query doesn't work on temprory table while works on normal tables.
>
>
Hi!
This is documented in our manual.
Aliasing of temporary tables will be enabled in MySQL 4.0.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. S
Does anybody have a mapping of MS-Access data types matched to MySQL data
types? For example: AutoNumber in Access is the same as ? in MySQL.
I want to be able to copy a table from MS-Access to MySQL.
Pance Stojkovski
Database Consultant
I give file access to a user on tables in a database :
GRANT INSERT,SELECT,FILE ON LOGS.* TO www@localhost identified by
'hidden';
then :
SHOW GRANTS www@localhost;
+---+
| Grants for www@localhost
>Description:
Granting a normal user FILE privilege will be listed as DROP
and user has both FILE and DROP privileges.
>How-To-Repeat:
mysql -u root -p
CREATE DATABASE TEST1;
USE TEST1;
CREATE TABLE TESTING (COL1 CHAR(3) );
GRANT INSERT,SELECT,FILE
>helo
>
>anybody there to help me for my project
>my project is on PERL and Mysql in Linux
>
>please say me the procedure to
>study those stuffs.
>
>thanx in advance
Buy the book MySQL written by Paul DuBois.
Take a look at www.devshed.com and on webmonkey.
Bye,
B.
You could also have your php script write out a piece of javascript code to clear the
form:
formReset;
?>
Call this somewhere after the form.
Pieter
Werner Stuerenburg wrote:
> > Todays problem, ladys and gents is that I have a sinple form page that
> > updates a database. The form is in
Go to http://lists.mysql.com/ (the list archive) and do a search there for
MSSQL7 ... you should find several messages covering this subject.
Gerald Jensen
- Original Message -
From: "Stefan Wernicke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 4:20 AM
Subje
VIDAL Thomas writes:
> Hello,
>
> I have a problem to install Mysql Source (3.23.39) I have gcc (2.96) but
> at the start ./configure i have :
>
> cheking for gcc... gcc
> checking whether the c compiler (gcc ) works... no
> configure: error: ... C compiler cannot create executable
>
>
> C
hi,
please is there a way to get the number of records in a JDBC
ResultSet ? something like mysql_num_rows in PHP.
thanks
karel pitra
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello,
I have a problem to install Mysql Source (3.23.39) I have gcc (2.96) but
at the start ./configure i have :
cheking for gcc... gcc
checking whether the c compiler (gcc ) works... no
configure: error: ... C compiler cannot create executable
Can you help me please ??
Must i install an
William M. Quarles writes:
>
>
>
> gzip: stdin: not in gzip format
> tar: Child returned status 1
> tar: Error exit delayed from previous errors
>
> Now do you believe me?
>
> --
> William M. Quarles
>
No, not -xzvf !!
Try either :
tar xzvf mysqlgui-tar.gz
or
tar xvf .
helo
anybody there to help me for my project
my project is on PERL and Mysql in Linux
please say me the procedure to
study those stuffs.
thanx in advance
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.y
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
Hi,
I have an access database in MSAccess 2000 and I am trying to
export tables into mySQL database. I can import tables in MSAccess
but cannot export table.
When I try to export the table , I get the following error:
ODBC--call failed.
[Microsoft][Gestionnaire de pilotes ODBC ]
Type d'informati
Hi to all,
can someone tell me how to import a sql server db into mysql?
platform is win32
TIA
S.W
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
Could somebody please explain to me
why mysql doesn't use an INDEX for ORDER BY
in joined selects with LIMT and no WHERE clause.
thanks
Gunnar von Boehn
On Mit, 11 Jul 2001, Gunnar von Boehn wrote:
>using mysqlversion 2.23.30
>
>I have the problem that mysql doesn't want to use an index.
>I
Hi there
Have a look at V4 release notes/todo.
Full replication should be in there..
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 12 July 2001 09:27
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Parallel Databases
I've been trying t
I've been trying to think up a system
to achieve this myself, but with practically no success.
I'm not using mysql long (only about 6 months), and my
c/C++ is a little rusty, but if you get off the ground with
this and need a grunt, give me a shout.
Sean
-Original Message-
From: Trevor
Yes, Chinese characters isn't much of a problem. They will be stored in
ASCII format unless you are using a Chinese system for your server, which
should then display it as Chinese characters. Sorting isn't too much of a
problem as long as sorting is done in ASCII order. I have done it this way
back to my unique constraint again :)
i asked on irc but couldnt get anything out of them so i came here.
got a unique constraint with serveral columsn like so..
UNIQUE (col1,col2,col3)
id like to have col2 and col3 to use null values but it doesnt seem to like
this. Is there a way i can use co
Mark Lo wrote:
> Hi,
>
>Is it possible for mysql to store simpify and tranditional chinese.
Yes, storing is not problem at all. MySQL can store any data without
loss in binary fields. Problem is on sorting, upper->lower conversions
and fulltext search. We do not have any chinese sorting as
94 matches
Mail list logo
