Re: MySQL Client unicode program

2004-11-16 Thread Gleb Paharenko
Hello. Look at output produced by: show variables like '%char%'; and show create table 'your_unicode_table'; If you use Unicode, the most obvious that all charsets should be the same. But if you see something else, probably you should correct that. More you may read at:

MySQL Client unicode program

2004-11-15 Thread Koon Yue Lam
Hi, I am using MySQL 4.1.1 and all databases, columns are set to UTF-8 encoding I have try both MySQL cc and Query browser and try to enter some Chinese character, but when I print out the HEX value of the character. It isn't in Unicode that I expected, but i can't see those Chinese character

accessing mysql 4.1.2 unicode features using C API

2004-06-09 Thread Paul Gavazzi
Hi, I am really pleased with the new unicode features of MySQL4.1.2 alpha release. I am just a little surprised that there is still only one API call which returns the character set??? (And it returns the collating encoding instead of the real character set?) I was wondering if there is a way

MySQL and Unicode

2004-04-20 Thread Stormblade
Hopefully this will be the last snag...least till the next one :) I'm having a problem setting the charset to unicode (utf-8). If I understood what I read I can set each table to support a charset. But what I want to do is set the default charset for a database to be utf-8. Is this possible? If

Re: MySQL and Unicode

2004-04-20 Thread Victoria Reznichenko
Stormblade [EMAIL PROTECTED] wrote: Hopefully this will be the last snag...least till the next one :) I'm having a problem setting the charset to unicode (utf-8). If I understood what I read I can set each table to support a charset. But what I want to do is set the default charset for a

Re: MySQL and Unicode

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 11:32:22 +0300, Victoria Reznichenko wrote: Stormblade [EMAIL PROTECTED] wrote: Hopefully this will be the last snag...least till the next one :) I'm having a problem setting the charset to unicode (utf-8). If I understood what I read I can set each table to support a

Re: MySQL and Unicode

2004-04-20 Thread Paul DuBois
At 9:38 -0400 4/20/04, Stormblade wrote: On Tue, 20 Apr 2004 11:32:22 +0300, Victoria Reznichenko wrote: Stormblade [EMAIL PROTECTED] wrote: Hopefully this will be the last snag...least till the next one :) I'm having a problem setting the charset to unicode (utf-8). If I understood what I

Re: MySQL and Unicode

2004-04-20 Thread Paul DuBois
At 11:02 -0400 4/20/04, Stormblade wrote: On Tue, 20 Apr 2004 09:21:00 -0500, Paul DuBois wrote: At 9:38 -0400 4/20/04, Stormblade wrote: On Tue, 20 Apr 2004 11:32:22 +0300, Victoria Reznichenko wrote: Stormblade [EMAIL PROTECTED] wrote: Hopefully this will be the last snag...least till the

Re: MySQL and Unicode

2004-04-20 Thread Paul DuBois
At 13:03 -0400 4/20/04, Stormblade wrote: On Tue, 20 Apr 2004 11:49:46 -0500, Paul DuBois wrote: Make sure the server really is picking up the option value: SHOW VARIABLES LIKE 'character%'; Look for 'character_set_server'. If it's utf8, then perhaps your GUI tools are overriding the

Re: MySQL and Unicode (Solved)

2004-04-20 Thread Stormblade
Embarrassing but I blame it on hunger! It's working now. Bottom line was I hadn't restarted the server. Now I know I said I did. Here's where I blame hunger. I was restarted A server. My Tomcat server. I kept restarting it thinking I was restarting the MySQL serverdon't ask. Like I said I

Re: MySQL and Unicode

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 12:13:07 -0500, Paul DuBois wrote: At 13:03 -0400 4/20/04, Stormblade wrote: On Tue, 20 Apr 2004 11:49:46 -0500, Paul DuBois wrote: Make sure the server really is picking up the option value: SHOW VARIABLES LIKE 'character%'; Look for 'character_set_server'. If it's

Re: MySQL and Unicode

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 11:49:46 -0500, Paul DuBois wrote: Make sure the server really is picking up the option value: SHOW VARIABLES LIKE 'character%'; Look for 'character_set_server'. If it's utf8, then perhaps your GUI tools are overriding the setting? Dunno. You might try creating a

MySQL and Unicode

2004-04-09 Thread Pascal Francq
Hi, I have a question. I have read that since MySQL 4.1, VARCHAR type can hold unicode characters. But, it seems that the API of the C library use to send queries to the server still use 'const char*' for the type of the query. So, praticaly, if I have a unicode string stored in C, how can I use

Re: MySQL and Unicode

2004-04-09 Thread Hirofumi Fujiwara
Hi, I have a question. I have read that since MySQL 4.1, VARCHAR type can hold unicode characters. But, it seems that the API of the C library use to send queries to the server still use 'const char*' for the type of the query. So, praticaly, if I have a unicode string stored in C, how can

Re: MySQL and Unicode

2004-04-09 Thread Pascal Francq
OK, you use a C char* using an UTF-8 encoding. On Friday 09 April 2004 11:45, Hirofumi Fujiwara wrote: Hi, I have a question. I have read that since MySQL 4.1, VARCHAR type can hold unicode characters. But, it seems that the API of the C library use to send queries to the server still use

Re: MySQL and Unicode

2004-04-09 Thread Warren Young
Pascal Francq wrote: OK, you use a C char* using an UTF-8 encoding. That's very commmon in the Unix world. 2-byte encodings are very rare on Unix-like systems, for compatibility reasons. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

mysql and unicode ....

2002-06-19 Thread toby -
does mysql 32.23.51 support unicode thnx a million ... toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before

RE: mysql and unicode ....

2002-06-19 Thread Dean Harding
uses Unicode for almost everything (though I don't need to sort on any text fields so it's OK) and I've not had any problems... Dean Harding. -Original Message- From: toby - [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 19 June 2002 5:13 pm To: [EMAIL PROTECTED] Subject: mysql and unicode