[smc-discuss] how to search unicode string in a text stored in mysql db?

Manilal K M libregeek at gmail.com
Tue Aug 18 07:00:13 PDT 2015


Make sure that your database encoding is utf8.

regards,
Manilal

On 8 August 2015 at 21:57, ഫെന്നെക് എന്ന കുറുക്കൻ.
<fennecfox at openmailbox.org> wrote:
> Hi, I've stored some malayalam text inside mysql database. I've tried
> searching it with this query; SELECT * FROM `article-data` WHERE
> article_title LIKE'%53;്&#335&'; and it returned, nothing found.
> Actually, thats not true. Which is the best method to store malayalam text
> into database and retrieve it? Please help me..
>
> --
> എന്ന്, ഫെന്നെക് എന്ന കുറുക്കൻ.
> _______________________________________________
> Swathanthra Malayalam Computing discuss Mailing List
> Project: https://savannah.nongnu.org/projects/smc
> Web: http://smc.org.in | IRC : #smc-project @ freenode
> discuss at lists.smc.org.in
> http://lists.smc.org.in/listinfo.cgi/discuss-smc.org.in
>



-- 
Manilal K M | മണിലാല്‍ കെ എം.
http://libregeek.blogspot.com


More information about the discuss mailing list