Major problem: MySQL 4.1 & utf8. Please some help!

aggelos

I am very desperate!
I want to continue with my work and i need to have MySQL's charset=utf8. I upgraded from 3.23 to 4.1 so as to have support for utf8 as they where saying in the documentation.

I finally found that they forgot to include the utf8 charset files while compiling the 4.1.0 and that i have to wait for 4.1.1

Do you have a solution?I have to continue my work and i don't know how much i must wait for 4.1.1.

My data are greek characters but it does not work with iso-8859-7 (greek) it works only with utf8.

Please, do you have any suggestion?

enterume

Just to share with you about the utf8 data(japanese chars) store in mysql blod type.

I have an application to save the data pass from a web form , which page is encoded with utf8. So, when I retrive the data and put on the webpage, i just declare the php header as utf8, then I am able to view the japanese chars.

aggelos

Do you mean blob instead of blod?

I want to use greek characters. Anyway, is there a relationship between the type of the data(blob,text,varchar...) and encoding of the data?

Tracer

And this doesn't Work?

http://www.mysql.com/doc/en/Charset-Unicode.html

http://www.mysql.com/newsletter/2003-04/a0000000148.html

aggelos

CREATE DATABASE d CHARACTER SET latin1;
export: Unknown character set 'utf8'

It should be known. But as i found out, they forgot to include the files when compiling the 4.1.0

Do i have to wait until the compile the next version or is there anything i could do?

Tracer

are you using *nix distro? If so you should be able to compile from source and add the character sets left out....?

From This Site:

http://www.mysql.com/doc/en/Character_sets.html

"You can change the character set with the --default-character-set option when you start the server. The character sets available depend on the --with-charset=charset and --with-extra-charsets= list-of-charset | complex | all | none options to configure, and the character set configuration files listed in `SHAREDIR/charsets/Index'. See section 2.3.3 Typical configure Options."

enterume

Originally posted by aggelos
Do you mean blob instead of blod?

I want to use greek characters. Anyway, is there a relationship between the type of the data(blob,text,varchar...) and encoding of the data?

hi, from what i understand, text is to store text only. varchar is to short text and numbering. blob is store binary data, like image, double-bytes data and etc.

Yeah, curretnly I am using binary MySQL. Why not you try with binary, instead of source code and recompile yourself? as the Binary version is alreadly optimised test from MySQL team. 🆒

oops.. it is blob, not blod, don't worry. 😃