RE: Character sets

2007-03-19 Thread Adam Graham
As habit I only use UTF in anything I do... and it has paid off many times over. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Character sets

2007-03-19 Thread Ales Zoulek
Hello. In general, You can never be sure that (some time in future) you won't need to store different national characters. For example some non-english surname or whatever. So, If you can easily decide it now, use UTF. It's painless choice now and it can come handy in future. Ales Zoulek On

Re: character sets.....(missing info)

2005-11-20 Thread BÁRTHÁZI András
Hi all, there is no conversion done, and mysql will stil be happy to export utf8 (if asked to do so with a set names). So what is the role of the character set and collation at the database level?From what I understand the collation is used when you want to order results for example, case sen

[OT]Re: character sets.....(missing info)

2005-11-14 Thread mel list_php
For information for other people who would have the same problem: Warning Do not issue the query 'set names' with Connector/J, as the driver will not detect that the character set has changed, and will continue to use the character set detected during the initial connection setup. To allow mu

Re: character sets.....(missing info)

2005-11-09 Thread BÁRTHÁZI András
Hi Melanie, Thanks for the explanation, I will try the SET NAMES to export my XML file in utf8 (I actually want it to be in utf8) I'm sorry if this is a basic question, but as I said before I'm kind of lost with the encodings I asked almost the same here about a week ago, so I don't think

Re: character sets.....(missing info)

2005-11-09 Thread mel list_php
'm doing thanks for your help, melanie If you write an hungarian article about your test, maybe you will plan an english translation?or is hungarian hard to learn? :-) From: BÁRTHÁZI András <[EMAIL PROTECTED]> To: mel list_php <[EMAIL PROTECTED]> CC: mysql@lists.

Re: character sets.....(missing info)

2005-11-08 Thread BÁRTHÁZI András
Hi, if the character_set_client is by default latin1, does that mean that the java application is sending latin1?or is it changed at runtime? kind of lost again. As I understand, the charset of the column/table/database is irrelevant, there will be no conversion if you query from or inse

Re: Character Sets in 3.23.58

2005-06-24 Thread Gleb Paharenko
Hello. Complete and rich character set support appeared only in MySQL 4.1. So if it is possible move to 4.1. Andrew Mull <[EMAIL PROTECTED]> wrote: > Hello, > > We are running mySQL 3.23.58 on a RedHat server. We have a database > that needs to store Chinese (big5) and Vietnamese (U

RE: Character Sets, 4.0 and 4.1

2005-02-04 Thread Kevin Cowley
Bruce We're sort of in the same boat but if you persevere you can eradicate all the problems. Now we don't run the server as utf8 which does cause a number of problems - we don't want all the databases to be utf8 just some of them, and just some tables on some of them. For a database that needs

Re: Character sets and character_set_results

2004-11-16 Thread Martel Valgoerad
>> The problem is, when I get the data from the database via a >> webpage (php) everything works as expected. The problem is when I >> try to get the results from the mysql client (ie. SELECT body FROM >> thread WHERE tid=30) the national accented characters are shown as >> "?". I have browsed thr

Re: Character sets and character_set_results

2004-11-16 Thread Martel Valgoerad
> The problem is, when I get the data from the database via a > webpage (php) everything works as expected. The problem is when I > try to get the results from the mysql client (ie. SELECT body FROM > thread WHERE tid=30) the national accented characters are shown as > "?". I have browsed through

re: Character sets

2004-01-30 Thread Jeremy March
but can I set multiple "default character set" options to multiple character sets (EUC-JP, EUC-KR, and ISO-8859-1) rather then just one. No, just one in 4.0.x. You have to use 4.1.x for multiple character sets. _ Let the new MSN Prem

re: Character-sets

2002-11-07 Thread Egor Egorov
Michelle, Wednesday, November 06, 2002, 4:25:32 PM, you wrote: MdB> If I want to create a database with an arabic MdB> character-set, will only the data-cells be affected by MdB> this or will the table names, column names etc also be MdB> in arabic? You can use characters from current character s