Hi
You can store Unicode text in a binary column (BLOB) and convert it to/from
native Unicode format in your application. The most efficient form is likely
to be UTF-8 format, which has a variable character length (the lower 128
characters are the same as ASCII).
I have such a database that is
You don't need to be at the mysql prompt to run it, just run this from the
DOS prompt:
mysql temp.sql
and that will run mysql.exe and read everything from your temp.sql file.
- Original Message -
From: Barbara Ferrell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: barbara [EMAIL
Chris
Are those columns really character types, or integers ?
The values you list are quoted, which suggests they're character based, but
'id' suggests integers, ie.
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES (1,3,2,3);
Phil
- Original Message -
From: Chris
Hello all
Grateful for any help on this -
I have a table (definition for MAIN below) with a number of indexes
corresponding to various frequently used queries.
A SELECT statement using one of the multi-column indexes is running very
slow if it retrieves data that is not in in the index itself.
are variable length, does MySQL have to do a linear scan through the
database to find the row ? That's what I'm wondering because of the
reference manual warning about variable length rows.
Thanks
On Wednesday 24 October 2001 06:52 am, Philip White wrote:
Hello all
Grateful for any help