Hi Everybody,

We want a clarify from you

1)

We created a table xx as follows

create table xx( x1 char(10), x2 text)

Supose we want to insert a text of size containing 500 characters into that
table with a query statement

"insert into xx values('123456789x','The Brooklyn Tabernacle has become world
famous as a church of miracles a church that has flourished amidst the poverty
and crime of one of Brooklyn's harshest most unforgiving neighborhoods. A place
where professional men and women former prostitutes pimps drug addicts homeless
people and transvestites gather to worship their powerful and merciful God. Fall
on Your Knees is a book that will lead you on a journey to spiritual awakening.
In it Jim Cymbala pastor of he Brooklyn Tabernacle shares')"

it shows error as follows

parse error near 's harshest most unforgiving neighborhoods. A place where
professional men and wo' at line 1

But from your manual data type TEXT supports maximum of 655535 characters TEXT and BLOB A `TEXT'/`BLOB' with max length of L+2 65535 characters.

Why it won't support here.

we also tested with change of TEXT datatype to BLOB. But same problem.

Is there any wrong in the query statement.

2)

We faced problem for creating a database with password protection

WeI execute following query in mysql database

"insert into user
values('localhost','mak',password('mak10'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')"

Also we executed mysqladmin reload at command prompt after executing the above
query

But we are unable to enter to the user with mysql -u mak -p it asks password

But it shows the error "Access denied for User: 'mak@127.0.0.1' (Using
password:YES)"

we followed according to manual.

we are using mysql 3.21.29a-gamma for win32-3.21

Please reply with clear explanation.

Thanks KSatyanarayana