Text and Long text returns garble variales

[manking]

I am using MYSQL with cold fusion 4.5. I put in the following query.


select *

where messageid > 5

order by messageid

One of the columns is messages, it is a text (longtext) colunm.

The message column returned is garbled garbage. In my MYSQL admin program I can see the text yet it returns *(^%*^%*(^(&*(((*$@@#@#.

ANy ideas

Manny

 

[sleipnir214]

Have you verified that the data in that column is different from what ColdFusion returns?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[manking]

yes I use a desk top msysql administrator and I can see the text clearly. Yet when COld fusion queries the server it returns garbage.

 

[sleipnir214]

Hmmm. I don't have any experience with ColdFusion and MySQL.

Although I don't generally advise this, have you posted this question tot the ColdFusion forum?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[hos2]

perhaps a different code page ???

is the problem also with other fields or only this field ??