unicode charset support ?

hi mysql guru's, does anyone put light on the unicode charset support of MYSQL? i searced everywhere in the archives and the docs , but couldn't find a related thing.It seems that it doesn't support, however i am asking you to be sure. My application needs to save both japanese and chinese

Re: Too many connections (again) (could Mark answer this please)

thanks a lot Mark, now i figured it out, i should have used finally {} statements around close() functions. Best regards :) - Original Message - From: Mark Matthews [EMAIL PROTECTED] To: yilmaz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 10:07 PM Subject: Re

Re: Getting to latest 5 Records

just to make it clearer: select * from your_table order by auto_increment_column desc limit 5 cheers :) - Original Message - From: Luis Ferro [EMAIL PROTECTED] To: 'Jack' [EMAIL PROTECTED]; 'Mysql List' [EMAIL PROTECTED] Sent: Monday, November 26, 2001 6:30 PM Subject: RE: Getting to

Re: Arrayoutofindexexception

time cheers :) Original Message - From: Joseph Roth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 26, 2001 9:41 PM Subject: Re: Arrayoutofindexexception At 04:01 PM 11/26/2001 +0800, yilmaz wrote: hi all, first of all, since this is a jdbc specific question, you

Re: Too many connections (again) (could Mark answer this please)

Me , too, have the same problem. it seems that every opened page establishes a connection but those connections can't be closed, although i explicitly close in my code I posted a message related with this problem a few days ago, unfortunately couldn't get a satisfying answer. So, i request from

Re: number of connections keeps increasing

regards :) - Original Message - From: "TAKAHASHI, Tomohiro" [EMAIL PROTECTED] To: "yilmaz" [EMAIL PROTECTED] Sent: Sunday, November 25, 2001 8:02 PM Subject: Re: number of connections keeps increasing I want to know environment about Java, JDBC, Servlet-Conatiner, an

Arrayoutofindexexception

hi all, first of all, since this is a jdbc specific question, you might say i should post to java mysql mailing list, but for some reasons my java mysql subscribtion seems didn't succeed although i got a confirmation and a welcome email. (of course i confirmed my subscribtion) Anyway my request

why doesn't prepared statement work?

Hi all, i have a strange situation here, i am trying to execute an sql insert via prepared statements. though it is a simple insert process, i am having a syntax error message. Doesn't mysql support this? can someone please tell me what is wrong with this query? String query=insert into

why doesn't prepared statement work?

Hi all, i have a strange situation here, i am trying to execute an sql insert via prepared statements. though it is a simple insert process, i am having a syntax error message. Doesn't mysql support this? can someone please tell me what is wrong with this query? String query=insert into

Re: why doesn't prepared statement work?

sure there are exactly 19 fieldnames and 19 ?s, also in the database there are 19 columns exactly matching the filednames. what could be wrong now? - Original Message - From: Hans [EMAIL PROTECTED] To: yilmaz [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 8:48 AM Subject: Re: why

Re: why doesn't prepared statement work?

at org.gjt.mm.mysql.PreparedStatement.set(PreparedStatement.java:1192) at org.gjt.mm.mysql.PreparedStatement.setString(PreparedStatement.java:581) It is very strange , isn't it? - Original Message - From: DL Neil [EMAIL PROTECTED] To: yilmaz [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent

Re: why doesn't prepared statement work?

easier if MySQL had thrown a sensible and a logical error message so that developers need not to waste a lot of time on a fairly small problem? - Original Message - From: yilmaz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 9:08 PM Subject: Re: why doesn't

nested select queries

hi everybody, i have a simple problem, but somehow i couldn't solve it i hope someone overthere can help me. i have a select query as below: select no,subject,ndate from cat1 where news like '%+search+%' limit +page_no+,5 i also want to find out how many rows are there in the result set. what is

how to auto_decrement a primary key?

Hi all, i want to keep the track of row numbers to display the results , say, five by five. the most common way to do this is defining a column which is auto_incrementing and not null. but htere is a problem with this approach. say, i have a table which stores the subject and contents of