Arabic text storing problem

i have one problem with Arabic text. I have created database with charaterset utf8. when i insatal sql file all the content which is arabic that content stored as arabic. but when i retrieve this content it is display something like ASCII value(فعاÙÙSØ© ادارة اÙÙ^Ù,ت). one more thing

Re: Use select within delete

Try this (I do not have 4.0.24 to try): delete table1.* from table1, table2 where table1.id = table2.id and dateoneweek Ravi. On 11/13/07, mark addison [EMAIL PROTECTED] wrote: Dario Hernan wrote: Hi all I need to delete some fields from a table but in the where clause I need to put a

SQL query problem

Hi, I have built a site with Dreamweaver and I have a problem with a query. I am trying to pass a parameter from one page to another to drill down. Basically, I have one product entry that is in multiple categories on my website. So, say it's a dress, it is therefore related to category

SET GLOBAL don't work

Hi all, i have a mysql 4.1.21 and i want to change the wait_timeout variable without restarting mysql. I found that this variable can be changed by using SET GLOBAL wait_timeout=XXX mysql show variables like 'wait%'; +---+---+ | Variable_name | Value |

Re: Transactions and locking

Yves, Did you read this reply I send earlier? I think it does what you want without needing to lock anything, thus making it portable. Damn, I found out that I need table locking *and* transactions. What makes you say that? BEGIN TRANSACTION SELECT MAX(id) FROM table INSERT INTO

Re: SQL query problem

Dear Mat, Your mail is not very clear. But I have a feeling that using '%' wildcard in the like operand should help you Regards, Ravi. On 11/14/07, Matthew Stuart [EMAIL PROTECTED] wrote: Hi, I have built a site with Dreamweaver and I have a problem with a query. I am trying to pass a

Re: SET GLOBAL don't work

Hi Thomas Raso wrote: Hi all, i have a mysql 4.1.21 and i want to change the wait_timeout variable without restarting mysql. I found that this variable can be changed by using SET GLOBAL wait_timeout=XXX mysql show variables like 'wait%'; +---+---+ | Variable_name | Value |

What am I misunderstanding here?

I'm running MySQL version 5.0.33. I have the 2 following queries: SELECT Resource.Id, Resource.Name, Resource.Description, Resource.IsVisible, Resource.UpdatedDate, Resource.CreatedDate FROM Resource INNER JOIN ObjectTarget ON Resource.Id = ObjectTarget.TargetId AND

Re: Arabic text storing problem

i have one problem with Arabic text. I have created database with charaterset utf8. when i insatal sql file all the content which is arabic that content stored as arabic. but when i retrieve When you retrieve this content, how are you viewing it? - browser? terminal? For the browser, it

Trigger/Locking question--

Hi... I'm trying to get me head around a possible situation involving locks/triggers. Suppose I have two tables: FooTBL CatTBL in FooTBL, I have a trigger that operates such that whenever a new row is added to FooTBL, it's immeadiately copied to CatTBL. I'm trying to understand what happens

Re: Arabic text storing problem

Thanks for the link Is there standalone jar/zip Just for auto_ef Not that I know of. Since I work on Solaris most of the time, it's not an issue for me. It's probably a bit much to install an OS just for a single utility... Company allegiance aside [I work for Sun], the Solaris Express

Re: Use select within delete

thanks all, I'll do it with a perl script! Dario 2007/11/14, Ravi Kumar. [EMAIL PROTECTED]: Try this (I do not have 4.0.24 to try): delete table1.* from table1, table2 where table1.id = table2.id and dateoneweek Ravi. On 11/13/07, mark addison [EMAIL PROTECTED] wrote: Dario

Triggers/Innodb/Locking

Hi... As I understand mysql, Innodb provides for row level locking, as opposed to myIsam which does tbl level locking. Is this correct? If I am correct, if I have a trigger on a Innodb tbl (foo), such that the trigger then copies a row to another innodb tbl (cat), foo should only do a lock of

MySQL - Replication (Master/Slave) Question

Hi... I have a number of servers that I want to treat as Master Servers or the purpose of Replication.. I'd like to have each of the Master, have the Slave DB on the same machine. Ie, a Slave server, might have 10 different Slave Databases/config files, with each of the SlaveDB tied back to the

Re: MySQL - Replication (Master/Slave) Question

bruce wrote: Hi... I have a number of servers that I want to treat as Master Servers or the purpose of Replication.. I'd like to have each of the Master, have the Slave DB on the same machine. Ie, a Slave server, might have 10 different Slave Databases/config files, with each of the SlaveDB

Re: MySQL - Replication (Master/Slave) Question

On Nov 14, 2007 3:40 PM, bruce [EMAIL PROTECTED] wrote: Hi... I have a number of servers that I want to treat as Master Servers or the purpose of Replication.. I'd like to have each of the Master, have the Slave DB on the same machine. Ie, a Slave server, might have 10 different Slave

German collation for UTF8 missing

Hello, I want to store my data with UTF8, thus I'm using the utf8 charset for my tables. But which collcation shall I use? I cannot find anything appropriate. I cannot use utf8_unicode_ci or utf8_general_ci, because this seems to treat Ä and A equally. So I couldn't store the words ÄBC and

RE: MySQL - Replication (Master/Slave) Question

Correction to a couple of replies I've seen -- a slave server can have more than one master, but not to the same database. That is, Slave reads Database1 and Database3 from Master1 and also reads Database2 from Master2. You may actually be able to get down to the table level, but I'd have to

Slow query not using index

Bad news: I have a slow query that doesn't appear to be using an index even if I force it. Good news: the forehead shaped dent in my desk is really progressing well. Here's the query: SELECT DISTINCT poster_data.* FROM poster_data, poster_prodcat, poster_categories WHERE

Re: MySQL - Replication (Master/Slave) Question

On 11/14/07 4:01 PM, Mike Johnson [EMAIL PROTECTED] wrote: Correction to a couple of replies I've seen -- a slave server can have more than one master, but not to the same database. That is, Slave reads Database1 and Database3 from Master1 and also reads Database2 from Master2. You may

RE: MySQL - Replication (Master/Slave) Question

hi... in very basic terms/pics... i have : masterServer1 masterDB1 my.cnf masterServer2 masterDB2 my.cnf . . . masterServerN masterDBN my.cnf this gets me N masterServers, each with it's own my.cnf file, as well as it's own masterDB. I'd like to be able to

Re: Transactions and locking

On 14.11.2007 12:50 CE(S)T, Martijn Tonies wrote: Yves, Did you read this reply I send earlier? I think it does what you want without needing to lock anything, thus making it portable. I would suggest the following -- create a table called SEQUENCES: Yes, I've read it and actually put a

Re: German collation for UTF8 missing

On 14.11.2007 21:43 CE(S)T, Marten Lehmann wrote: I want to store my data with UTF8, thus I'm using the utf8 charset for my tables. But which collcation shall I use? I cannot find anything appropriate. If I recall that correctly, utf8_swedish_ci is the collation to use for european/western

RE: MySQL - Replication (Master/Slave) Question

Update/Clarification: It's apparent that you need a master-slaveDB, and that I can have multiple slaveDBs on the slave server. But can I setup all the slaveDBs on a single machine. Thanks hi... in very basic terms/pics... i have : masterServer1 masterDB1 my.cnf masterServer2

Seeking assistance with recurring MySQL crash during nightly dumps

A message in the MySQL log file asserts that someone at this e-mail address may be able to assist in troubleshooting/diagnosing a chronic error we encounter during our nightly database dumps. Here is an excerpt of the log file (near the reference to your e-mail address): InnoDB: Error: semaphore

Re: Arabic text storing problem

Hi, Thanks for the link Is there standalone jar/zip Just for auto_ef Also see Perl module Encode::Guess. There are others out there as well. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives:

Re: Slow query not using index

Ian M. Evans wrote: Bad news: I have a slow query that doesn't appear to be using an index even if I force it. Good news: the forehead shaped dent in my desk is really progressing well. Here's the query: SELECT DISTINCT poster_data.* FROM poster_data, poster_prodcat, poster_categories WHERE

Re: Slow query not using index

One of the list readers (thanks Brent!) suggested using a full text index on the category names field. Queries dropped from 10-49 seconds down to 0.0085 Thanks for the emails folks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: