I can successfully LOAD a UDF in mysql-4.1.10, but I can't DROP it.
MySQL reports that the DROP FUNCTION was OK, but the function still
shows up in the mysql.func table. The function no longer works, but I
have to TRUNCATE the mysql.func table in order to be able to LOAD it
again. I am doing this
I just noticed that in the link I sent you Japanese utf8 characters are indeed
only 3 bytes long. So much for that idea.
> I am inserting data into mySQL via this script:
> http://www.feedsfarm.com/tmp.phps
>
> I've set default-character-set=utf8
>
> When I output the data to the browser (see
So its just the Japanese titles which aren't working? The Greek and Cyrillic
looked ok to me. If that's the case then the causes which occur to me would be:
1. The web browser doesn't have a Japanese font (I don't know if I have one or
not so I can't check that)
2. Japanese characters are lon
How are you inserting the data into mysql? LOAD DATA INFILE? Be sure the
client you are using to import the data is using the utf8 character set:
SET CHARACTER SET utf8 or --default-character-set=utf8
The best way to check whether the data was inserted into mysql correctly is to
use the mysql
I believe there is already a bug report about this. See if this is the same as your
problem:
http://bugs.mysql.com/bug.php?id=3453
I'm suprised by your result too. Did you have an index on the join column? If
not that might explain it. One place you might turn to learn more about how
mysql optimizes joins is internals.texi. This file describes a lot of the
internal workings of mysql and is found in the bk doctree and is
> This will give me sort of what I am looking for, but it shows the
> UserKey in the first column and I want the UserID. I have tried a few
> others but just got errors.
> SELECT f.UserKey, UserID FriendID, Name FriendName
> FROM User u, FriendList f
> WHERE f.FriendKey = u.UserKey
> ORDER BY f.U
Are you working from the mysql command line client? If so you can't. If not what
sort of client are you working with? There isn't much to go on from your description.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
