New charset for MySQL

2002-11-24 Thread Shyamal Banerjee
Dear sir, I want to create a website in my native language. I would like MySQL support for my native character set, which is Bengali. I think MySQL does not support this language. How can I add support for it in MySQL ? Thanks in advance for any reply. Shyamal -

Re: New charset for MySQL

2002-11-26 Thread Shyamal Banerjee
Dear Sir, Thank you for the tip.I am going to look the page you mentioned. Shyamal - Original Message - From: "Dean Harding" <[EMAIL PROTECTED]> To: "'Alexander Barkov'" <[EMAIL PROTECTED]>; "'Shyamal Banerjee'" <[EMAIL PRO

Re: New charset for MySQL

2002-11-26 Thread Shyamal Banerjee
Dear Sir, I found the following page after a google search on Bengali Character set:- http://www.alanwood.net/unicode/bengali.html Thanks Shyamal - Original Message - From: "Alexander Barkov" <[EMAIL PROTECTED]> To: "Shyamal Banerjee" <[EMAIL PROTECTED]&

GROUP BY - CONCAT query question?

2002-11-08 Thread Shyamal Banerjee
Hi, You can try the following. Store the result of your query into a temporary table, say tp, with two columns tc (ticketID) and pname (pipelineName). Run the following query : select concat("select @c:='';","select tc, (@c:=concat_ws("","",@c,pname)) as x, length(@c) from tp where tc=", tc," o

Re: Count Rows in two tables

2002-11-13 Thread Shyamal Banerjee
If you know the primary keys of the two tables, it may be done as follows: select count(distinct t1.pk1) + count(distinct t2.pk2) from t1,t2; where - pk1 is the primary key column name of table t1 and pk2 is the primary key column name of table t2. SB - Original Message - From: "Rick Bara

Re: Help! problem using MySQL C API

2002-11-13 Thread Shyamal Banerjee
Try using mysql_free_result each time after fetching the rows. SB - Original Message - From: "Ganbold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 13, 2002 4:27 PM Subject: Help! problem using MySQL C API > Hi, > > I'm having trouble writing dial-up user billing