hi!
i had some trouble inserting utf-8 unicode into a table
in mysql 4.1.0.alpha. i creat the table with
CREATE TABLE chartab (
.
) TYPE=MyISAM CHARSET=utf8;
then I tried to insert utf-8 data, using a file with sql statements:
mysql
On Mon, Jun 16, 2003 at 11:56:59PM +0200, Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200:
mysql select * from unitest WHERE t LIKE 'A%';
ERROR 1210: Wrong arguments to like
SELECT * FROM unitest WHERE colname LIKE CONVERT(_latin1'A%' USING utf8)
On Tue, Jun 17, 2003 at 11:57:13AM +0200, Roman Neuhauser wrote:
and yes, I need the absurd CONVERT .. utf8 ... USING utf8,
with out the CONVERT ist doesn't work.
absurd? your connection has latin1 as the character set,
even if i supply a --default-character-set like so:
mysql
I'm trying to use 4.1.0-alpha's extensive unicode support.
What I've learned so far: unicode only works in 4.1.0-alpha,
but it's not activated in the binary distribution, so I had
to compile it myself.
I can create a table like this:
CREATE TABLE unitest (
ID mediumint(9) NOT NULL