Re: UTF8 support in MySQL 4.0

2005-08-11 Thread Warren Young
Marco wrote: So how can I do that? There's nothing special you need to do with MySQL itself. Somehow your program obtains UTF-8 data. Insert said data into database. That's it. Perhaps you should read up on UTF-8, to see why this is so. Again, don't expect the database server to be able

Re: UTF8 support in MySQL 4.0

2005-08-10 Thread Marco
So how can I do that? I've already tried SET CHARACTER SET and it didn't work since someone said its not available in MySQL 4.0. You can store UTF-8 in any database in the world. UTF-8 is compatible with any application capable of dealing with null-terminated strings of 8-bit characters. Tha

Re: UTF8 support in MySQL 4.0

2005-08-09 Thread Warren Young
Warren Young wrote: That's why it's possible in the Unix/C world, Typo: should be "That's why it's _popular_..." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: UTF8 support in MySQL 4.0

2005-08-09 Thread Warren Young
Marco wrote: So is there any solution on how I can properly use foreign characters and store them in a MySQL 4.0 database? You can store UTF-8 in any database in the world. UTF-8 is compatible with any application capable of dealing with null-terminated strings of 8-bit characters. That's

UTF8 support in MySQL 4.0

2005-08-08 Thread Marco
SET CHARACTER SET ut8; won't work. My server admin said UTF8 has not been mentioned in 4.0 thus I am unable to use it. So is there any solution on how I can properly use foreign characters and store them in a MySQL 4.0 database? -- MySQL General Mailing List For list archives: http://lists

Re: MySQL 4.1.3 Java/UTF8 support question

2004-11-26 Thread Ramesh Vadlapatla
Hi Gleb, The problem was with the JDBC Connect string, earlier it was; jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=utf8 I changed that to: jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=UTF-8 and it works now. thanks, Ramesh On Fri, 26 Nov 2004 13:53:

Re: MySQL 4.1.3 Java/UTF8 support question

2004-11-26 Thread Gleb Paharenko
Hello. What output produced show variables like '%char%'; show variables like '%colla%'; You should also set utf8 as server character set. See: http://dev.mysql.com/doc/mysql/en/Charset-defaults.html Ramesh Vadlapatla <[EMAIL PROTECTED]> wrote: > Hi, > > In my.cnf, I have: > [my

MySQL 4.1.3 Java/UTF8 support question

2004-11-25 Thread Ramesh Vadlapatla
Hi, In my.cnf, I have: [mysql] default-character-set=utf8 When I connect via mysql client and try to run a query which has a "CONCAT" string function, it works fine and I get the proper output. Example: SELECT CONCAT ('a', ' - ', 'b') = a-b Now, I am trying to do make this work via Java and: I

Mysql 4.1 with UTF8 support

2003-11-21 Thread Theo Dettmer
Hello, I was wondering if anybody has mysql compiled with UTF8 support. I don't have VC++ but needed to at least do some proof of concept so if someone could email the files or tell me where I could download them I would appreciate it. Thanks, Theo Dettmer [EMAIL PROTECTED] -- MySQL Ge

Re: utf8 support

2003-08-27 Thread Egor Egorov
"Li, John" <[EMAIL PROTECTED]> wrote: > > Any hint where and how to get mysql 4.1.1? > Official binaries will be available in September at: http://www.mysql.com/downloads/index.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored b

RE: utf8 support

2003-08-26 Thread Li, John
Any hint where and how to get mysql 4.1.1? Thanks John -Original Message- From: Jon Haugsand [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 3:14 AM To: '[EMAIL PROTECTED]' Subject: Re: utf8 support * John Li > MySql 4.1 should have utf8 charset support, I downloa

Re: utf8 support

2003-08-25 Thread Egor Egorov
"Li, John" <[EMAIL PROTECTED]> wrote: > > MySql 4.1 should have utf8 charset support, I downloaded the alpha version > but don't seem to have the utf8.xml file comes with it. > > Any one know how to get the needed charset support files? utf8 is a built in character set. -- For technical supp

Re: utf8 support

2003-08-25 Thread Jon Haugsand
* John Li > MySql 4.1 should have utf8 charset support, I downloaded the alpha version > but don't seem to have the utf8.xml file comes with it. > > Any one know how to get the needed charset support files? It looks like a bug. Try version 4.1.1. See e.g.:

utf8 support

2003-08-23 Thread Li, John
MySql 4.1 should have utf8 charset support, I downloaded the alpha version but don't seem to have the utf8.xml file comes with it. Any one know how to get the needed charset support files? Thanks John

Re: utf8 support

2003-07-17 Thread Paul DuBois
At 23:03 +0200 7/17/03, Yves Goergen wrote: > >2. What about fulltext search on UTF8 strings? Unavailable. Eh? Why should this be a special DB feature at all? Correct me if I'm wrong (I didn't have very much contect with fulltexts yet), but can't I just give mysql an UTF8 string to search in an

Re: utf8 support

2003-07-17 Thread Keith C. Ivey
On 17 Jul 2003 at 23:03, Yves Goergen wrote: > > >2. What about fulltext search on UTF8 strings? > > > > Unavailable. > > Eh? Why should this be a special DB feature at all? > Correct me if I'm wrong (I didn't have very much contect with > fulltexts yet), but can't I just give mysql an UTF8 stri

Re: utf8 support

2003-07-17 Thread Yves Goergen
> >2. What about fulltext search on UTF8 strings? > > Unavailable. Eh? Why should this be a special DB feature at all? Correct me if I'm wrong (I didn't have very much contect with fulltexts yet), but can't I just give mysql an UTF8 string to search in an UTF8 column (/data)? Shouldn't this wor

Re: utf8 support

2003-07-17 Thread Paul DuBois
At 17:25 +0300 7/13/03, Sagi Bashari wrote: Hello, I would like to know the status of the UTF8 support in MySQL 4.1. I tried to create a table using utf8 charset, and inserting hebrew text into it. it seems like it still treats this text as binary - for example the length() function returns 8

utf8 support

2003-07-13 Thread Sagi Bashari
Hello, I would like to know the status of the UTF8 support in MySQL 4.1. I tried to create a table using utf8 charset, and inserting hebrew text into it. it seems like it still treats this text as binary - for example the length() function returns 8 on 4 chars string, or when cretting a

Re: utf8 support

2003-06-06 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan Hinz wrote: > Okan, > > >>I want to enable UTF8 support for mysql.Thats why I have installed mysql 4.1 >>on a Win2K server and set the appropriate character set parameter at my.ini >>file. As the mysql service s

Re: utf8 support

2003-06-06 Thread Stefan Hinz
Okan, > I want to enable UTF8 support for mysql.Thats why I have installed mysql 4.1 > on a Win2K server and set the appropriate character set parameter at my.ini > file. As the mysql service starts, I get the error that mysql can not find > the utf8.xml file. > mysqld-opt: File

Re: utf8 support

2003-06-06 Thread Victoria Reznichenko
"Okan CIMEN" <[EMAIL PROTECTED]> wrote: > I want to enable UTF8 support for mysql.Thats why I have installed mysql 4.1 > on a Win2K server and set the appropriate character set parameter at my.ini > file. As the mysql service starts, I get the error that mysql can not

utf8 support

2003-06-06 Thread Okan CIMEN
Hi all, I want to enable UTF8 support for mysql.Thats why I have installed mysql 4.1 on a Win2K server and set the appropriate character set parameter at my.ini file. As the mysql service starts, I get the error that mysql can not find the utf8.xml file. mysqld-opt: File 'D:\mysql\share\cha