CLOB is probably better for what you want.
Also, make sure the table is declared UTF-8 (or Unicode or whatever
mysql calls it.)
virtas wrote:
As it turns out issue was somewhere in mysql. Not sure exactly where, but
something to do to with BLOB.
Now, I changed text field from BLOB to varchar
As it turns out issue was somewhere in mysql. Not sure exactly where, but
something to do to with BLOB.
Now, I changed text field from BLOB to varchar and started using
mysql_real_escape_string in my php code and all started working just fine.
Thanks for the help
--
View this message in conte
Sounds like one of three things:
1/ Everything is set to UTF-*, but the content has another encoding.
2/ Something 'mirocosoftish' is adding a BOM (byte order mark) that is being
incorrectly interpreted.
3/ The byte order is wrong somewhere along the way and not being translated
correctly across
Holy cow, you already have this in place. I apologize. This looked exactly
the kind of problem I have solved this way.
On Fri, Oct 22, 2010 at 8:38 AM, Pradeep Singh wrote:
>
>
>> What would you recommend changing or checking?
>>
>>
> Tomcat *Connector* URIEncoding. I have done this several time
>
> What would you recommend changing or checking?
>
>
Tomcat *Connector* URIEncoding. I have done this several times on tomcat,
might be at a loss on other servers though.
- Pradeep
