I hope you will recognize that what you stated as a problem is _not_
what this thread was about.
You are talking about --
(a) A new (and as yet non-universal) version of MySQL
(b) Only binary data
(c) Conf done by you, which is not standard
Whereas the thread was about simple Japanese
Hi Xuefer,
What are you talking about? A lot of people are using MySQL without any
problems with multibyte characters. Please post a reference URL, with
perhaps a detailed explanation of the problem -- you mentioned you have
brought this to the attention of people already, please post a relevant
27; to initialize a variable with your JP text
%>
<% Response.Write ("-YOUR JP TEXT COMES HERE-")
%>
That should do it.
Cheers,
Shanx
Shashank Tripathi
www.shanx.com
| -
Storing JP and EN data in the same table has worked for me ever since I
started using MySQL. Unlike Oracle, you don't need any specific charset
configs (I may stand corrected). The idea is to use the correct
character encodings when you *display* the data after pulling it out. In
your case, I'd th
around the operating system file limit for MyISAM data
files by using the RAID option.
Hope this is useful?
-Shanx.
Shashank Tripathi
www.shanx.com
Sql, query
-
Before posting, please check:
http://www.mysql.com/manual.
| Other big problem is why mysql locked all queries during
| executing this one ...
Agree on this one, this is a little unfortunate. But MySQL 4 should give
you row level locking, and well, using index on '%WORD%' as well.
Meanwhile, a full text index should be the only way out
#x27;John%'
These will NOT be fast --
field5 like '%John%'
field5 like '%John'
Putting a wildcard character ("%") before the term will avoid the index.
Shashank
Shashank Tripathi
www.shanx.com
Sql, query
--
heers
Shanx
| Yep i do that but varchar and text fields aren't index so ...
|
| I'm also having a look to FULLTEXT index, but i think
| that the index will be really really big ... :(
|
Shashank Tripathi
www.shanx.com
Sql, query
---
Paul,
Based on your original post, I'd have to agree with Brian. That query
should work. In fact, something as simple as this should work too:
select
order.order_id
from
order
,transaction_log
where
order.order_id = transaction_log.order_id
an
in all the other fields. You could make a FULLTEXT index on
this field, and use ONLY this field to do your searches. Also take a
look at REGEXP.
http://www.mysql.com/doc/en/Regexp.html
Hope this is useful,
Shashank
Shashank Tripathi
www.shanx.com
| -Original Message-
|
s
would be my recommendation if the only thing you want to do is to be
able to view contacts from anywhere.
...etc.
Hope this gives you some ideas.
Cheers,
Shashank
Sql, query
Shashank Tripathi
www.shanx.com
-
Before posting,
The website works fine for me, Bhanja. It seems like a select query, so I
wonder why you would expect an "insert failed" error? How do you get to know
that you get an insert failed error?
Some more info would be useful. You say, "When I am trying to insert *a*
record, after *10* or so records" --
Toby,
This is not a MySQL question, it is an issue of PHP and would be best asked
on a PHP forum. But in any case, the "value" tag is missing in your checkbox
HTML.
Shashank
sql,query
-
Before posting, please check:
http:
Java based
client so should work on Linux. I have used it with Oracle but since it
works with any JDBC database, perhaps should in theory support MySQL as
well (http://squirrel-sql.sourceforge.net/)
Hope some of this is useful,
Shashank
Shashank Tripathi
www.shanx.com
Hi,
Not sure which language you are using, but I hope this will give you some
ideas: http://www.phpbuilder.com/columns/rod20001214.php3
Hope this is useful,
Shashank
--
sql, query, select etc. all the jazz that will
make this message go through to the list.
--
Nope, the SQL query I suggested earlier is incorrect because it biases the
display by AVG of votes already. You do need to divide the average by all
votes, as suggested by Mark.
In what environment do you want to use this Ian? Can it not be done with two
queries...if it is in some programming lan
,avg(rating)/count(rating) as weighted
,(avg(rating)/count(rating))/count(titleid) as ordering
from
movieratings
group by titleid
order by avg desc, ordering
;
Wondering,
Shanx
Shashank Tripathi
www.shanx.com
.
|
| In php by example, there is a substr with a negative pos
| that give char at end ! no in mysql !
Is there any reason you feel PHP and MySQL should have the same syntax?
Anyway, hope I helped.
Shanx
--
If it goes without saying, let it.
Shashank Tripathi
www.shanx.com
, but saves ONLY the content (no html tags etc). This
way, the db does not have to search for a whole bunch of redundant tags
but still would have a link to your current html files which are saved
in a separate table that is used only for a layout.
Hope this helped,
Shanx
--
Shashank Tr
19 matches
Mail list logo
