dbTalk Databases Forums  

Mysql, PHP and UTF-8

comp.databases comp.databases


Discuss Mysql, PHP and UTF-8 in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Mysql, PHP and UTF-8 - 05-17-2006 , 04:31 PM






Hi!

I've created a mysql database (v4.1.9) with the default charset utf8
and I'm doing some web pages with PHP (v4.3.2) also using UTF-8.

Database insertion works great, even when using strange characters but
search doesn't work always:
For instance:
- a search for "não" or "NãO" gives 3 results
- "nao", "nÃo" and "NÃO" gives no results

Seems like the search is not case-insensitive (or accent-insensitive)
when using accented characters (or any greater than 127).

I've double checked the mysql table settings, did a "ALTER TABLE
mytablename DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci" just to
make sure and nothing works.

Anyone got ideas on how to solve this problem? Thanks in advance!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.